Beautiful, thank you!

Hi everyone,

Just as Gail had said, the user's default database was set wrong, once I corrected that, the entries in the SQL Server logs stopped happening. Thanks for all...

Hi Perry,

Yes, the other drives are separate physical drives, the data on their own set of drives, the index on their own, and the logs on their own.

There is plenty...

Thanks again, this is strange, since I have added the user as you had mentioned, but it's still not able to log in. I dropped the user and recreated...

Thank you very much for that information!

I have already created that user using code, and it still cannot log in...that's what I see in SQL Server logs. It's very...

Thanks everyone for your help.

In my new position, there is a Win 2003 server with a C:\ drive partition of 50GB. The tempdb files are on that drive. ...

Has anyone heard/used any of these products? What are your opinions?

http://www.appsecinc.com/products/compare.shtml

http://www.imperva.com/products/dsc_database-firewall.html

http://www.imperva.com/index.html

http://www.verdasys.com/data_loss_prevention.php

You got great points Rob, thanks for that!

And thanks for your response Burninator. Are you guys allowed to use USB or connect your cell phones to your PCs?

Works for me. 🙂

Thanks!

Thanks for your response. I wonder how Banks ensure that the DBAs or developers do not walk off with their data. And health insurance companies. Anyone know?

Strange that SQL Server uses only 1GB of RAM and there is 0 free space. Just to be sure, use MS's Process Explorer to see how much RAM different...

Give some more info:

1. Your Windows version.

2. Windows...is it 32-bit or 64-bit?

3. Your SQL Server version.

4. Is SQL Server 32-bit or 64-bit?

5. Have you enabled...

Thanks Kraig for the reply.

Not sure what this means, can you please explain further or tell...

Got it, thanks!

WOW, that worked, thank you so much. Can you please tell me why this had an effect on SQLCMD?