If 2 is cast as a datetime, isn't it converting a null to 1-1-1900 then adding 2 to it? The explanation says:

The null value in SQL Server is converted to...

The explanation wasn't worded greatly and has been corrected. Also, the ordering can't be known, but it's assumed, at least by me, that the "second row" referred to the NULL...

I think you need to delete this file and initialize a new one for SQL Server backups.

Also: http://www.sqlservercentral.com/columnists/bahmed/backupscenariosforsuccessfulsqlserverrestoresandre.asp

No good one I've seen. Maybe mail the owner of this site: http://www.vba-programmer.com/RefDocs.htm

No,

hopefully in 2k5, but no way to do this now. I've administratively (through email/memo) set a policy and then used NGS Software' SQLCrack to look for passwords that don't meet...

This can and does occur. I think it might have been fixed in a SP so it's not the default, but it does happen. It might not happen on YOUR...

Store the user and pwd in a table. Pass them to a stored procedure and return a 1 or 0, true or false, approved, failed, whatever.

No easy way to do this in SQL that I know of. You can return these in rows and then compute the number of distincts. Create a temp table using...

Third vote here. Detach dbs, use sp_help_revlogin (from MS) to script logins. Save of DTS packages, uninstall, reinstall.

You're welcome. Sorry I couldn't get more detailed, but since it's Beta, I'm sure MS doesn't want to publish too much.

You can script it out and run the script on the other server or try the Copy Objects Task in DTS. Select only users, roles and permissions. The objects have...

Wow a complement. What do I do with those

Is the remote server running on localsystem? I think I've had issues with this.

don't forget to drop the old server with sp_dropserver