I guess the problem is trigger_events: it contains every event that makes the trigger fire, not the event that fired the trigger NOW.

You could guess the operation type looking at...

You can set up a Linked Server if you have the right OLEDB Provider.

I use HitOLEDB400 from Hit Software, but you can use any one you like.

I suggest you...

What command did you run?

If you run DROP DATABASE there's no log of deletion, you just get rid of the DB and free the disk space.

If you selected the database...

Choose one:

http://www.sqlservercentral.com/Forums/Topic762902-149-1.aspx

http://www.sqlservercentral.com/Forums/Topic762910-150-1.aspx

http://www.sqlservercentral.com/Forums/Topic762907-150-1.aspx

http://www.sqlservercentral.com/Forums/Topic762905-149-1.aspx

http://www.sqlservercentral.com/Forums/Topic762899-149-1.aspx

http://www.sqlservercentral.com/Forums/Topic762894-149-1.aspx

http://www.sqlservercentral.com/Forums/Topic762892-149-1.aspx

http://www.sqlservercentral.com/Forums/Topic762890-149-1.aspx

It must be very important to create 8 threads for this:

http://www.sqlservercentral.com/Forums/Topic762902-149-1.aspx

http://www.sqlservercentral.com/Forums/Topic762910-150-1.aspx

http://www.sqlservercentral.com/Forums/Topic762907-150-1.aspx

http://www.sqlservercentral.com/Forums/Topic762905-149-1.aspx

http://www.sqlservercentral.com/Forums/Topic762899-149-1.aspx

http://www.sqlservercentral.com/Forums/Topic762894-149-1.aspx

http://www.sqlservercentral.com/Forums/Topic762892-149-1.aspx

http://www.sqlservercentral.com/Forums/Topic762890-149-1.aspx

Save it into a file and send it to your mailbox.

You coud create it in one of your databases ad then create a cursor for master.dbo.sysdatabases. In the cursor fetch loop you could run sp_helptext (another cursor needed to get...

There are several approaches and I've seen around all flavours of solutions, but I still think the best way is setting up a strong VPN and then work over it...

I think the real question is "Why truncate the log file?".

See this article for more info:

http://www.sqlservercentral.com/articles/64582/

I guess the problem is the way you declared @UserName as NVARCHAR.

If you don't specify a length, this will be 1 by default, so, when you fetch the value...

Not yet. I will check tomorrow.

If you use standard SQL you have a chance to make it, but I don't think it's neither easy nor fast.

Try explaining your needs deeper, maybe we can suggest something...

I'm unable to understand your needs, please specify:

1) DDL for the tables involved

2) Sample data

3) What you have coded so far

Read this article for more info on how effectively post...

I'm sorry, these are not the correct lines.

Try looking for "adodb.connection".

Why not posting the whole script? You can attach it to the post.

Great, Mark!

Much cleaner and smoother than my suggestion!

Kudos!