Now I can post .  Yesterday I can only click the face expression to post.

Could it be that someone change the password for that domain account which your sql server agent used to log in and start service.

mom

I am not sure why your db_owner can create logins...  I think this privilege can only be given to "sa".  I don't mind having db_owner giving user access to their...

If you can't attatch the MDF file because it is corrupt, can you find the latest backup and restore it?  I am sure you have it backup every night.

mom

If you can't remember what the sa password you should be able to reset sa password provide that you previously set yourself up as sa.  I don't think it's the best...

This is how we do this in our group:

SQL Program file can be on C:\ or it's own drive.

Data on it's on drive

Log on it's own drive.

backup on it's own...

1st. of all your client should not have sa right to create database as he pleased.  (We don't give our client sa right!)

2nd.  I think your client need to close...

OK. Besides running is there an option such as trying to find similar product that does the job without giving much headache.  I am sure you could findout about that...

There are many reason to downgrade to Standard Edition.  I have downgrade a couple of servers from Enterprise Edition to Standard Edition.  Here is how you want to do it. ...

From BOL

"TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are not transferable."

mom

Jonathan,

You are very right.  Poor Tom.  Sorry I can't help you. 

mom

Did you login to the server using sql server agent account when you set your the email profile?  Your SQL Server Agent account also has to have the right to...

here is my other 2cents.  Please send test email from outlook to yourself to see if you receive email from that server.

If you are unable to send email from outlook,...

I wanted to say good job for everyone at sqlservercentral.com.  I was amaze at how clean the site really look and to my suprise, I also had to learn how...