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.

If you have a linked server, then it's pretty simple. Same process, just include the server and database name wiht the owner and table name.

Otherwise, DTS might be the...

Good questions. You should be able to query syspermissions and see things in there for your UID. Perhaps EM will let you see a limited view for what you have...

Each is only compiled the first time, or when it's not in cache. These aren't grouped in any way other than similr naming as far as I know.