I'm sorry I meant SSMS. That's what we have.

I created a user and then checked the box that says user much change password at next login. Then I logged...

I know about the checkbox. But if the checkbox is checked (that you must change password at next login)...how do you change password at next login? I tried it...

Thank you so much for your response. I will just download the 86 version of SP3. Thanks again!

Also, would it make more sense to just apply sp3 instead of the security updates for SP2?

Hmmm good point. We have standard edition. I'll try that first. I will be taking this ancient server and upgrading workgroup to standard edition.

Thank you so much for the info. Now, I'm thinking about upgrading to the Enterprise edition. Unfortunately I inherited THESE databases and there is no documentation what so ever. They...

It's workgroup edition. NO service pack has been installed. Product level states "RTM"

I shrank the log file and it did absolutely nothing. 🙂 The lowest it would let me allocate space was 7720. I did that and the log file went from...

Also, do I need to rebuild indexes AFTER I shrink the files??

sorry, I goofed.

database_sizeunallocated space

7725.06 MB 71.88 MB

Database is 7.45GB

mdf is 7.53 GB

ldf is 4.6MB

Boss insists that something should be shrunk. I have...

The server does not have a printer installed so I dont even have that option. 🙁 The server is also cut off from the internet so I can't even...

I'm not sure I will be able to download a third party tool. Is there anyway to do this using SQL server management tools? Or something within SQL server?

I'm not sure I want to change the database owner. Is this safe? Can it mess up anything?

Ok, so I compared this on both databases. It's the same on both databases. The dbo login is associated with the sa user. The sa user has both public and...

Both servers/databases are SQL Server 2005 service pack 2.