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

Did the server reboot or SQL restart? I wouldn't expect this to reboot the server.

Ouch, questionable quality?

Some typos and perhaps some you don't agree with, but I'd like to think there aren't that many.

I'm happy to correct our mistakes, as I'm happy to admin,...

Apologies everyone for selecting the incorrect answer. Somehow in the cut and paste and answer load I picked the wrong one. Guess I'm not so good at the question loading.

Points...

Need an external control to do this. You could use sp_oacreate to instantiate some COM object that can handle this. Or run a program from DOS and pipe the output...

Sorry to disagree, but on a fresh install of SQL 2000, nothing changed, creating a table like this allows NULLs. Perhaps this depends on the config of the base OS,...

There is not version fo SQL Server that's a "client". There are eval versions available from http://www.microsoft.com/sql you can use at home.

It will compile the first time and that is all.