I do not think you can.

Builtin\Administrators is a group with local admin administration provilege. All users in this group have sa privilege by default, including networking domain administrators. Unless you...

Add the role, ddladmin, to your custom_role.

I believe that in the profiler, the % is included implicitly, i.e., you do not need to add it.

If you would like to re-install SQL 2005, you can remove this registry. If you are afraid anying may happen, you can save this registry before removing it.

Since SMO is more than a client tool, I cannot see any point why they need it.

I mean to check the health of each physical drive in your array.

I think it is understandable. Here is a scenario.

The system needs some time to go to the next step after one is completed.

For example, we need to warm our food...

It is the synchronization issue in MS SQL Server. I tested successfully. Refreshing the current database helped me solve this error.

Hopefully, the following steps helps.

Add a new log file to your new drive;

Empty your old existing log file using DBCC SHRINKFILE command;

Remove your old existing log file using ALTER DATABASE...

Did you try to use [] to include the UserName?

Run the following command on the current database before yours.

sp_grantdbaccess @loginame = 'UserName'

Hopefully, it helps.

Go to the properties of the database, tempdb. Set its sizes. Next time, these sizes will become its default.

By default, the tempdb has 8 MB size.

The following link may help.

http://msdn2.microsoft.com/en-us/library/ms190693.aspx

Did you check the discussion in this forum recently?

http://www.sqlservercentral.com/Forums/Topic255556-5-1.aspx#bm255664

If you cannot afford downtime, you may have to consider adding new drives.