the script text says that its for create user ....but its not .Actually i have tons of alerts created ..and when i wanted to create the memory alert i just...

you can join my blog @ http://ms-abhay.blogspot.com/...

Like you I am a WMI / VB lover ....and will not rest till crack this stuf 🙂 ..

I have the answer for you my friend but it might not serve your purpose completely ...

Youhave created the CPU table and feeding Textdata to it ....thats where the pain...

Siva ,

I have the answer .I also wandered like you and i could not find the answer anywhere.The answer is that there are a few log shipping tables that...

-> As Gail said check the error logs.

-> Dont run check db now .

-> If you want do a sp_resetstatus and then dbcc dbrecover .

-> You will get the error...

You need to use sp_update_alert and set the enabled value to 0

USE [msdb]

GO

EXEC msdb.dbo.sp_update_alert @name=N'Respond to DEADLOCK_GRAPH',

@message_id=0,

@severity=0,

@enabled=0,

@delay_between_responses=0,

@include_event_description_in=5,

@database_name=N'',

@notification_message=N'',

@event_description_keyword=N'',

@performance_condition=N'',

@wmi_namespace=N'\\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER',

@wmi_query=N'SELECT * FROM...

agree with Greg.

regards

Vivek , let me try to help you .

Can you please share the sp code to hi_abhay78@yahoo.co.in.

Regards

Were you loking for this 🙂

Use master

sp_msforeachdb "select column_name from ?.INFORMATION_SCHEMA.COLUMNS"

Hope this helps

Regards

Both queries are same so the plan should be same .But since you are trimming the spaces it will add some overhead .That extra overhead will be in the form...

In your case its not needed as you are specifying it in begin tran and commit tran .So update will roll back and SQL will internally throw the correct error...

Give me time till Monday (as its weekend) and your email address as I am on a location where there is no SQL Server (preparing documents to travel to US...

and if you also want to count the number of rows in each table :

sp_msforeachtable 'select count (*) as ''?'' from ?'

Regards

Abhay

Here is what you can do and you can always mail me for assistance during this time (hi_abhay78@yahoo.co.in).

First create or modify a job and run profiler at the background (filter...

This is almost similar :

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

Use Master

DECLARE @name VARCHAR(50) -- database name

DECLARE @path VARCHAR(256) -- path for backup files

DECLARE @fileName NVARCHAR(256) -- filename for backup

DECLARE @fileDate VARCHAR(20) --...