I have passed all the exams for MCITP DBA for 2005. I have used Exam Cram books and Microsoft Press books. Exam Cram gives you a good bit...

http://msdn.microsoft.com/en-us/library/aa337083.aspx

I have traveled 2 hours to the SQL Saturday Event in Birmingham, AL. Then I have gone 3 hours up to Huntsville to some other user group meetings. ...

Open the properties window of the user and go to user mappings. You will probably need to make change to the properties (like check a database and then uncheck...

Open up SSMS. Right-click the account in question. Script Login as >> CREATE To >> New Query Editor window.

Then you will just need to change the entries of...

Are you talking about creating a template script to create logins?

You could use the SQL Agent, there is an output option you can point it to a file. So you could just create a SQL Agent job and execute the...

So you backup a database from 'server a' and then move move the backup file to 'server b' and restore it.

Unless you restore the system databases as well the logins...

So if you login to SSMS with the sa account it is not allowed to create a DB either?

Not knowing why you want to install it on XP, Microsoft does approve it. I would be more prone to use Express editions on a desktop though.

However there...

Don't install SP3 for Windows XP.

What version of SQL Server 2005 Standard Edition are you trying to install?

Well I guess microsoft is sticking to what it knows best, "Keep the people that use/support your product, confused."

I did come across this article on SSC. He has some...

This SSC post is similar to your situation, I believe. This is just trying to separate with a space but you could adjust the query to insert comma.

Trying to...

This SSC post should point you in the right directory:

How can I set the authentication mode for a SQLServer from TSQL

This is a double post. It is under the SQL Server Newbies forum as well, posted there first.