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.

You can definitely load up HTML documents as binary documents. I'd assume that XML would work as well.

As far as querying, it would query like any other XML document,...

There are actually limits to that automated selling. Various tripwires will actually stop selling to prevent that from cascading across all stocks.

I'm not sure there was a lot of forcing...

The reason I might set a limit is to prevent someone from running something that makes heavy use of tempdb, and perhaps tracking it down. It's a fairly heavy handed...

I'd completely agree with Andrew. You're unnecessarily loading the server to build this when you could handle it on the client.

PS - names are in bold. You're referencing post levels....