I'm not familiar with Litespeed.

Does it use some sort of extended stored procedure, or does it run as a standalone program?

Assuming you know your backup is good, can...

Can you post the scripts you used to do the backup, and the scripts you are using to try the restore?

I've had both 2000 and 2005 client tools on the same XP box before with no issues, so the previous 2000 install shouldn't be messing with you.

Have you tried playing with the @query_result_separator? Perhaps make it a space or comma instead of an empty string?

I found that. But it returns something different than the SID in active directory.

It looks like SQL keeps it's own internal SIDs seperate from the active directory SID.

Do you have the latest service pack installed? The RTM version of SQL 2005 had all sorts of pesky little issues like this with Maint. Plans.

It is an impressive system...it just has some quirks.

I'm working with their support (which is excellent) and I think we are going to end up getting it working...

Sorry...should have been more specific.

We pretty much collect everything.

Logins, (failed and sucessful), selects, updates, deletes, inserts, etc. New objects created / dropped.

🙂 Except for in my case we both report to the same person, who usually sides with the DBAs.

Agreed. We have Idera's compliance manager that catches everything for us. It gives us everthing this script gives us and then some...This little net send popup is just...

There is a pretty good article on this subject on the front page of SQLServerCentral.com: http://www.sqlteam.com/article/which-is-faster-san-or-directly-attached-storage

It should be easy. Assume the table you are copying to/from has 4 cols: id (identity), col1, col2, col3.

Something similar to this should get you where you need to...

Another thing you could do is register a server or two in each group you are going to create and then export them. Then you can look at the...

See if this helps any: http://msdn2.microsoft.com/en-us/library/aa215459(SQL.80).aspx

I've used it to fix the opposite problem you are having (can go from 2000 to 2005 but not 2005 to 2000), but perhaps...

I don't know about registering all servers in the domain automatically, but once you do have them all registered on one machine, you can export the resistration information and import...