Tripwires have been around for awhile. If you pay attention, every once in awhile trading gets halted.

I want to say some were done after the crash in 85/86 and more...

How do you know which one to keep? The first one? Or the one that has all the fields?

That's important otherwise you could say row 2 duplicates row 1.

Multiple passes...

Have you logged in with the account? It should ask for a new password.

First of all, good for turning off shrink.

Second, the log file is allocated, it doesn't grow like a Word or Excel file. If you need that space for index rebuilds...

Please don't cross post. Other one deleted.

What do you mean by xp user? That doesn't really make sense to me.

If a user does not have rights to a database, they...

I'm with Michael, you need to test.

Just going for it is a good way to lose a lot of goodwill at this job.

If you have issues copying, the backup won't run across the network. Any latency or delays will cause it to fail.

If it's taking that long to copy, you likely have...

It returns the values in Query Analyzer as well, they're in the messages tab

I think you want to make multiple passes, remove those duplicates based on the combinations. Jeff might have a one pass method, but I think the simplicity might run quickly...

user_name() or suser_sname() might be what you want if you want the account making the change. Host_name is the computer name, if it's sent.

I'll give a few:

- Possible lack of continuity with your staff/applications. An outsourced DBA service might send different people to work on the system over time.

- Variation of quality with...

I don't think you can prevent this. The thing to do is deal with it in your application somehow.

http://msdn.microsoft.com/en-us/library/ms178615(SQL.90).aspx

Shows the default is every 10%, but you can set a STATS=...

You could set a minimum duration in Profiler/Trace, grabbing everything that takes longer than say, 10 sec. That would help.

A quick try on my 2008 instance doesn't give me a way to grab table variable values in the debugger.

declare @t table (id int, mychar char(2))

insert @t select 1, 'A'

update...

I agree with Grant. You might need to rethink the SP.