I'd agree with the above. Load into SQL and then dedup.

There isn't a good way natively. Products like Red-Gates and others allow you to do this fairly easily, but you have to do it. I think some of them do...

You'd need to code something in the DTS package to look for the change in the file.

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...