Forgive my ignorance but are you talking about SQL auditing? How do I turn that on? Where is the information stored?

Forgive my ignorance but I am running SQL2000. Is 'execute as' available in this version?

Maybe I am lost on this how would this work?

How did you setup the accounts on the target server? Does the sid have to be the same on the source and destination in order for this to work?

Oversite on my part. That would explain a lot. So the rest of the weeks differential backups will be at least 19GBs and increase with whatever data changes were made?

i can't alter the rights of the users they use and dropping tables (gulp) hasn't been the issue. i can't stop them from creating the objects. I would just like...

Thank you gentlemen.. you were of great help!

Unfortunately, I can't seem to download the product and the article is to advanced for me to try and incorporate. Just a newbie here. Could I call the xp_cmdshell to...

Function Main()

Dim oConn, sFilename

' Filename format - exyymmdd.log

sFilename = "ex" & Right(Year(Now()), 2)

If Month(Now()) < 10 Then sFilename = sFilename & "0" & _

    Month(Now()) Else sFilename = sFilename &...

First I have a sql statement... say select message from test.

The sql statement results would have to be written to a file dynamically using todays date... say 20050922.txt

Lastly, that newly created...

i was able to parse my trigger but i still don't receive my expected results.

i thought this would have been pretty basic but its turning into a huge headache.

the...

basically its a text field that a user can add/remove comments from the front end. what management wants is the ability to track all of those changes(before/after)

So am I out of luck on this?

Basically I need a summation of the converted data to the decimal. So my final output for those two records would be

2434.56

+ 2345.67

4780.23

So the end result would be the...

I am trying to massage tables from a vendors file and map it over to a system that I support that requires line numbering.