My only thing I need to do is delete the old database files older than 7 days.

Thanks,but need a shortcut on the server desktop to ease my users execute it.Is there any way to generate all script from maintenance plan?because plan to deploy 100 over server....

Thanks Chris,it because maintenance plans can't be run manually or execute manually by users.Is there any way to do that ....

Yes,master database.Currently size of master database is abt

7GB.I have already moved the data to the new database before clean the master database.However,the size of

master database still show same after...

Thank you guys, thank you! ...

Dwen ....

Thanks Joie,Can this be done via Transact-SQL?before this i manually configure from EM ....

Thanks Greg,wht i need to add for Mixed Mode security?

Thanks,

Dwen

Ya before this i use Transform Data task to copy the data.By using SQL query i was add the cast but the DTS still not working.The error msg is "Syntax...

Ya before this i use Transform Data task to copy the data.By using SQL query i was add the cast but the DTS still not working.The error msg is "Syntax...

I would like to implement the conversion as part of a DTS package.I just want to know wht i need to add into the package to allow the datatype convertion?pls...

if there any query that can i drop all non-system stuff from master.Currently i drop the table one by one.Hope anyone can help me ......

Thx for advised .......

1. I have a system which user tables was created in master.mdf in SQL server 2000.My understanding this is not good practice to create any user object in Master DB...

Thanks for advised....

Currently i'm using SQL 2000.Yes,i plan to separate data into its own DB.How can i refresh the master file if i wanted to use same SQL engine?or can...

Tq Greg ......