you must understand the Concept if XML before using it

please go for BOL at

http://msdn.microsoft.com/en-us/library/ms175160.aspx

Gila ...you are genius....i always find reply everywhere and with sounded logics:):)

welll r u DBA or Developer and from which country?

check this link

http://www.sqlservercentral.com/Forums/Topic567637-146-1.aspx

have i provided right answer ????:)

hi gila ,

i need to pass spid as parameter

so its giving error :

declare @spid int,@lstr varchar(100)

set @spid = 52

set @lstr = 'insert into Sp_info dbcc inputbuffer( ' +cast(...

Madhu,

Follow the 3 steps sequencially and forget about JOB.:) where ever you calling

FAILURE_NOTIFICATION ,dont pass parameters

step 1 :

create table #error_status

(

logdate datetime,Processinfo varchar(20),text nvarchar(4000))

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

step 2 :

CREATE...

you need to pass SPID or hard coded it

use following script

CREATE TABLE [dbo].[#Sp_info](

[Eventtype] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[parameters] [int] NULL,

[eventinfo] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]

GO

declare @spid int,@lstr varchar(100),@text nvarchar(max)

set...

Hi,

1.Modify sp_send_cdosysmail proc with my script

2. call above SP in FAILURE_NOTIFICATION proc .

And sorry I couldn’t reply you yesterday as I left at 6 30 IST 🙂

And...

i also in queue with vrailean ...actually i want do SQL server certification 2005 ..can somebody give me some papaers or notes 🙂

if it would happened say on wednesday .....then do we require to restore the differential of mon amd tuesday...if yes then what would be the sequence ???

Try This........Hope this will give required results

create procedure [dbo].[P_EMP_INSERT](@PARTYID BIGINT, @NAME VARCHAR(200), @DOB DATETIME)

as

begin

begin transaction

...

i m not sure but that file may contain commented line(those 4 line)...this ia a blind guess...it might help you 😉

i really dont understand ur need actually ....u have one column with identity propertiy in sql table and u want to update that table which actually doesn't contain any...

create table #error_status

(

logdate datetime,Processinfo varchar(20),text nvarchar(4000))

insert into #error_status

exec sp_readerrorlog

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Notification@express.com',

@recipients = 'bkumar@express.com',

@query = 'select top 10...

if you generate backup script from management studio either for APPEND option OR for OVERWRTIE option

,you cant see any difference in scripts.

only you can do is ,generate a backup...

Have you discovered that why it was giving msdb related error ??

you can do it with the help of error log