Thanks, but the one that promoted me was in oraclecom?.

Word of mouth...I've heard of that. People actually talking in the same room. Odd concept. It will never catch on.

There...

Hmmm, SQL Server convention...I just imagine a long line of cubicles with everyone typing in their computers sending messages back and forth...pretty much what happens anyway.

Dr. Peter Venkman: Generally...

In Enterprise Manager check under Security/Logins. Find the user and see what the Default database is. It sounds as if you have it pointing to MASTER instead of Test.

Bonne...

Configuration Options in BOL:

tempdb in ram placed the tempdb database in RAM, if needed. No longer supported because SQL Server 2000 has been optimized for maximum performance.

Remove all...

Yes, there are so many variables that without more information about the setup there's not much advice to offer.

Dr. Peter Venkman: Generally you don't see that kind of behavior...

I'm not a fan of cross-posting. You answer a question and then find that there is a much longer thread in another section of the forum. Pick your best...

bonne anniversary Frank. Have a beer and relax this weekend. Try not to sneak in and answer any questions.

Dr. Peter Venkman: Generally you don't see that kind of behavior...

Also be sure that your passwords are secure and give sa a very strong password.

Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance.

Patrick

Another thing to think about (as if you need more) is that the new database should be on the same directory. If not, then you will need to do...

I'm an App DBA (therefore I may be wrong) but you may have problems with your logins with a backup/restore.

One thing you might think about is...

Experience says that if you open the database to the web someone will get in. It's a very big door and there are some very talented people out there.

Bonne...

I guess this comes back to your first posting - that you wanted to become a DBA/Developer in the fastest way. Books, while they have information, are not the...

Have you downloaded any of the third party software that will give you QA abilities?

I realize that QA came with the software package, but if doesn't work then...

sp_defaultlanguage would only be for login sessions. If you want to run sp_configure which will change the global configuration options for the server.

Dr. Peter Venkman: Generally you don't see...

Yes, we use downtimes (documented), either planned or unplanned, service packs, and database optimization.

Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance.

Patrick