Thanks all but its created by client mistakenly.I want to know how update stats is failing in first run and executing successfully in second run?

Sorry its Update statistics operation not backup operation:

Error:

If Object_..." failed with the following error: "156 Incorrect syntax near the keyword 'BACKUP'.
156 Incorrect syntax near the...

Thanks Pradeep you are genious.

I have the error :

An error occurred while attempting to access the subscription. (View Synchronization Status)

------------------------------

To synchronize, you must first create an agent job for this subscription. (View...

Yes its running at Mozilla.

Hi Ritesh,

Could u pls help in running this script on sql server 2005 9.00.4060.00.

Its giving many errors.

your script is great.

For Me its working fine 2012 but on 2008 its running and running only.

Script is:

USE [msdb]

GO

/****** Object: StoredProcedure [dbo].[uspEmailSQLServerHealth] Script Date: 01/28/2010 15:15:27 ******/

IF EXISTS...

For Me its working fine 2012 but on 2008 its running and running only.

Script is:

USE [msdb]

GO

/****** Object: StoredProcedure [dbo].[uspEmailSQLServerHealth] Script Date: 01/28/2010 15:15:27 ******/

IF EXISTS...

We have also received Alert: The log for database is not available Resolution state: New

from SCOM

I am checking and done on principal but not on mirror because it requires down time.

its production

Looping.I have the same prob.

I want to do this actually this

===================================================

with Remove

as (select X.id1 from X

except

select X.id1 from X inner join Y on X.id2 = Y.id2)

DECLARE @BatchSize INT

SET @BatchSize = 1000

WHILE @BatchSize <>...

I have lakh of rows to be deleted in this table it will full my log file...

I want to use top in delete statement..

I am using 2008 R2 Std edtn.

I think it is giving error due to brackets..

It is giving error:

Msg 156,state 1,Line 6

Incorrect syntax near the keyword except.