Is there any way to check when this change happened.

In my knowledge, I never changed it.

When I run sp_helpuser 'db_ddladmin' under this database in SSMS I can see the group account as a member of this role.

But when I go to SSMS and then server->Security->Login...

Command(s) completed successfully. 🙂

Please try putting the database into emergency mode and then try to delete it.

UPDATE master..sysdatabases SET status=-32768 WHERE name='<dbname>'

Hope this should help.

Please run sp_who2 and see the process if something is in use

Also, query sysprocesses table

select * from sysprocesses

Just check by dbid and see if there any processes.

Or...

Before deleting builtin\Administrators anytime, it is important to find the members in this group.

You can get from below query itself

xp_logininfo 'Builtin\Administrators','members'

Just make sure that the account that runs your services...

Please let me know how much time this procedure takes to run.

Steve,

The DMVs updated by MarkusB are pretty good. Even the performance dashboard gives charts similar to the output. The first DMV gives CPU usage (SQL and non SQL) in the...

Good question. Tests the basic 🙂

You can consider using the DMV's available in SQL Server 2005

You could also use some tools which includes Microsoft Add-on tools like Performance Dashboard reports which are extremely useful...

As per my understanding, partitioning will be useful in such a case right?

Have not implemented on my database, but I was going through some documents.

Anam,

Out of curiosity, how much...

Hey you are right. It is tough to wade through this one. Even experienced guys are wary to give their sign off if DBCC freeprocache is absolutely harmless or not...

Just a suggestion 🙂

If we use DBCC FREEPROCCACHE, it would clear the execution plan from cache globally, i.e remove all elements from procedure cache.

We could see the contents of procedure...

Dear All,

Thanks for your help. I wrote to the author of this book and he asked me to download the source code from the book he had written for...

Ganga,

Yours is an intersting scenario. Regarding the size of log file being more than 400 MB, is there a way by which you can reduce the time period of the...