It could be N/A, but that implies a specific meaning. Using NULL there as a placeholder works, but you are assigning a value to NULL. I prefer to keep it...

Let us know if you figure it out. Would be a nice piece of info to keep handy.

Sorry, forgot to include a link to help: http://www.sqlservercentral.com/Forums/Topic854028-148-1.aspx

You would need to read the XML and split into rows. There is a task in SSIS that can help here. Is this a one time thing or a repeatable...

If you shrink regularly, you're creating fragmentation in your tables. Remove that from your system. If it grows beyond 50MB, determine why. don't just shrink.

You must have your DR version at SQL Server 2008 R2. It is an upgrade from SQL Server 2008. You can have a second instance on your laptop with this...

Is this SQL 2000? I don't believe EXECUTE AS works in 2000.

AFAIK, in 2000 you had to be the owner of the table for truncate.

http://msdn.microsoft.com/en-us/library/aa260621%28SQL.80%29.aspx

There is a master/target type of relationship for managing jobs in SQL Agent, but I have never liked it.

I have preferred to have each box manage it's own backups, and...

Is there something confusing about this: http://msdn.microsoft.com/en-us/library/aa258824%28v=SQL.80%29.aspx

AFAIK, back to FoxPro for DOS, it used DBF files for storing data, and .IDX by convention for indexes. I don't know what those are.

I think you have handled it pretty well if you are using one CHANGEID for each batch of changes.

I do like Brandie's idea of moving data to another database. It...

Restores do build files the same size as the original. That is a problem for some people, and a shrink is the way to handle this if the data will...

http://msdn.microsoft.com/en-us/library/ms365415.aspx

sp_unsetapprole

You say you are returning the ID value with an OUTPUT parameter. What do you return if you have multiple rows changed?

NULL seems like a variable to me, in an equation that can't be currently solved. Or maybe like "i". We know that it has some value, but we cannot pick...