I actually do run this:

use [cs_DotNetNuke]

EXEC sp_addrolemember N'db_datareader', N'S602561DC4EW31\GPWebUser'

EXEC sp_addrolemember N'db_datawriter', N'S602561DC4EW31\GPWebUser'

and like I said before db is not checked, but rolemember is and don't know why?Thank you

Thak you

Do I change @dbname to my database name. I know I have change id?

Thank you

Thank you very much, But will it kill my process?

I am sorry that you don't understand my question. I know how to check properties of the role, after the code runs and when I check properties, I see rolles...

I sat up a maintance plan and when I ran I get an error:

This is my subplan:

BACKUP LOG [Prod_Efficiency] TO DISK = N''F:\\Prod_Efficiency_backup_200901140944.trn'' WITH NOFORMAT, NOINIT, NAME =...

Do I need to have it?

Thank you

Thank you for your help, but my db is set to full, what 3rd party software are you refering? When I run your code I get an error:Invalid object name...

Thank you::D

Thank you This is 2000 and there is no option for that.

To clean up the white space

How you do that?

47619.07mb(26%)