I got this error when I ran your script.

Msg 102, Level 15, State 1, Line 9

Incorrect syntax near 'D'.

Msg 105, Level 15, State 1, Line 9

Unclosed quotation mark after the...

Thank you for the info.

The database I am having issue with the recovry mode set to simple is been use by Sharepoint application. With the covery mode set to simple,...

Thanks. What is status 1217?

Thank you. It works.

When I login using SQL Server authentication or Window authentication on the server where SQL Server 2005 is installed, I can create Assembly using the file on a share drive....

Thank you very much.

How do I set or grant EXTERNAL ACCESS ASSEMBLY permission on the SQL server?

Thanks very much.

What is DAC?

I would like to change the value of object owner to 1 which is dbo in sysobjects table. I have users that owns objects and they do not work for...

That is my next question.

Thank you guys! The script works.

Thank you Scott.

Thanks guys.

We have not remove the BUILTIN\Administrators login.

I re-installed the Microsoft Search running under service. Now I try to enable the full text catalog in the database, I go this error.

The Microsoft Search service cannot be administered...