I have implemented using @body. But the problem is that , i am getting multiple emails for each backup script. I need to have all backup scripts within a single...

We would like to change the servername.

i.e New ServerName is A (2014) and old ServerName is B (2005). Then we want to rename A (2014) to B.

Never mind. We might...

Thanks Grant. I agree with you and will keep this in mind from now onward.

My apology.Yes, it is duplicate post by mistake. Somehow, i am not able to delete that post. This issue persisting on SQL Server 2000.

Yes. User facing the slowness at specific time. They claim that switching tabs takes about 2-3 minutes or when they enter patient information to the application.

Thanks all of you for the help.

I found the backup for the database that was removed. I had a talk with senior person and decided to restore the backup.

Thanks...

Neither of them exist (no database and no table name).

It seems like they have dropped the database sometimes back.

I have run the query below:

use azADT

go

SELECT t.*

FROM sys.triggers t

WHERE

t.parent_id = 0 AND

(OBJECT_DEFINITION(t.object_id) LIKE '%amOperations%' OR

OBJECT_DEFINITION(t.object_id)...

It seems like something wrong with the below statement.

EXEC sp_executesql @SQLStmt

I have already set the @SQLStmt to nvarchar(max).

Am i missing something?

We are having a similar kind of issue for update statistics as well.

This job is running under NT AUTHORITY\NETWORK SERVICE.

Message

Executed as user: NT AUTHORITY\NETWORK SERVICE. Invalid object name 'amOperations.dbo.DatabaseObjectAudit'....

Yes. I did run against each dB using msforeachdb as well as using the script.

But i couldnt find anything.

There are few triggers but it doesnt seems to be related to...

Actually, i haven't created this SP. I just moved with this company recently and there are no other DBA's over here. So, i really dont have any idea about this.

I tried with msforeachdb but not able to find out that object.

Is there any way to find that object from the database?

I had a talk with senior person today. And he said they configured Limited file-growth to Unlimited. But at that time they were getting Drive space full alerts. And now...

GilaMonster (9/2/2015)

Remove the limited autogrowth, you mean?

I...