The reason is to just capture the reason why its failed and trigger a mail for every hour. The reason for truncating the temp table is to avoid the increase...

Hi Friends,

Any update

i have search many sites.It won't helpful.please provide the script.

Restarting the sql server services is not possible in this server. Let me explain clearly what is the exact issue.

This is the log shipping server. The logshipping is failed for...

We are getting the below output when we trigger the query given.

55Our DB Name

When i execute i get the below error:

Server: Msg 5061, Level 16, State 1, Line 2

ALTER DATABASE failed because a lock could not be placed on database 'DBNAME'. Try again...

We tried to kill the restore log operation. But we get the below error msg:

Server: Msg 6101, Level 16, State 1, Line 1

Process ID 55 is not a valid process...

In our servers, Server team don't allow us to use Powershell. We have only limited access. So only we are using these kinds of SP's to meet our requirement. Please...

sorry :blink:

I am confused because of this task. There is lot of torture for me in this task. So please help me.

Hi,

I need SP which scripts all the databases and store it into a CSV file with the name DBNAME_DATE.csv This CSV file should contain all the scripts of tables,views,triggers,etc..

Please treat...