If you upgraded and were using Identites, then it's possible that some numbers were lost. Depending on how many times you upgraded and rolled back. And depending how you...

You will need some type of process to download the data. This probably needs to be via HTML, XML, or even csv. One thing you have to be sure...

You don'tneed to restore the dbs. Use sp_help_revlogin (from MS) to script logins. Uninstall. reinstall, and attach your databases. Run script to load logins.

Step 2 may not do it. If it doesn't, try this:

http://www.sqlservercentral.com/scripts/contributions/26.asp

The above is the most likely cause. The stored procedure creates a cursor in each database and uses that to gather information.

I think horzintal partitioning can be a database design technique, but I'm not sure I'd recommend it in your case. I've used it in places where we had a wide...

Had a request and it was a quick one, so I did it. Glad you like it.

Keep sending suggestions!

Ai, you are correct. The documentation on the main site was out of date as well as BOL since 64-bit is new. I'll correct that for next time.

I don't think you want to delete and system objects yourself. If they were setup, you want to use EM to remove the subscriptions.

If you really want to, you can...

It needs to be readable by the service account, so if it's on a UNC share, permissions should be granted to the SQL Server service account.

not that big. Done a few million, but that's it.

Steve,

Thanks for that. I'm still tweaking it a little here and there, but Surfinity generously gave us a copy to entice us to use it and I have to say...

The issue has to do with virtual log files. Here's a script that can help

http://www.sqlservercentral.com/scripts/contributions/26.asp

Different questions. a typo in the other one, this one should have been better.

They are similar questions, but different to see if you are reading them or understand the different parts of this. They probably should have been spaced a few more months...