Thanks.

Seems like there is no option in SQL for this to do.

I will give a shot to this via Powershell.

🙁

can you share the solution step by step.

i need to audit event id 18264.

I want whenever this event id occur i should get a mail and run a job specific...

THanks :smooooth:

Question is not clear.

Please explain what you want to try?

Hi,

I modified like this:

SELECT Request_ID,firstname,Subject,End_Date,Mail_ID

INTO #Data from test

declare

@Request_ID varchar(20),

@firstname varchar(50),

@End_Date varchar(10),

@Mail_ID varchar(100),

@Subject nvarchar(max),

@htmlbody nvarchar(max)

declare c1 cursor for

select Request_ID,

firstname,

End_Date,

Mail_ID ,

Subject

from #Data

open c1

fetch next from c1 into

@Request_ID,

@firstname,

@End_Date,

@Mail_ID,

@Subject

While @@fetch_status <> -1

begin

select @Subject =...

Thanks a ton man.

I modify this script according to me and it worked smoothely..

🙂

Superb..

Hi All every thing is working fine.....

i got the output also. But i want servername also in the output file .

Pls help.

current output is:

name,Backup_Type,LastSuccessfulBackup,IntervalInDays

I want it should be:

Server_Name, ...

Its a permission issue on Drive...

Thanks.

This link is really useful...

Now i got...

Thanks 🙂

Can we do point in time recovery in Bulk loged recovery model?

If yes then how?

thanks

What is called Object in SQL Server? Tell me some objects name?