just my 2ct.

Since you aim for minimal prod sys interference .... let's keep it simple.

How about lightweight tracing just for the the sp_prepare and sp_execute statements (of course capture...

As you have experienced, control server results in the same permission set as sysadmin.

A very good SSC ref pointing to this issue: http://www.sqlservercentral.com/blogs/brian_kelley/archive/2010/09/02/for-sql-server-2005-2008-consider-securityadmin-sysadmin.aspx

forsqlserver (4/27/2011)

---

I have SS2008R2 in mixed mode auth.I have forgot my sa password.

Only sa has sysadmin.

Before 11 months I have add one windows domain user 'sqladmin' as login and I...

can you reveal the version info of your sqlserver instances that participate in this dbmirroring setup ?

@@version

or

Select Serverproperty( 'Edition' ) as Edition

, Serverproperty( 'ProductVersion' )...

That problem can be solved using a service broker solution ( event AUDIT_ADD_DB_USER_EVENT to be investigated ).

or maybe even using extended events. ( could be in the audit events. I...

Please elaborate on your findings, situation and results or side effects.

Now you have it: Gail answering an question referencing her article.:hehe:

And she did answer it very good (as is her article).

Nothing to add.

My guideline for clix:

- pick one

- keep it...

you have been bit by the "select * " monster !!!!!!

Specify the columns you want to use and you'll be ok.

Try to avoid the cursor in the first place.

did you...

Condolences and prayers to your friend's family.

I've lost an ex colleague last Friday who fought the battle against her cancer for a year.

That are the kind of events that really...

did you try:

http://support.microsoft.com/kb/918992

or

http://www.sqlservercentral.com/scripts/31776/

Keep in min you would better do this procedure including login SIDs !

Before Okt 2008, Easter day and New years day where the only two days our production would be in full stop.

The only occasion to do some real systems maintenance for...

Jack Corbett (4/23/2011)

---

So now we have someone saying don't REORG indexes only REBUILD and you don't need to do statistics maintenance.

http://www.sqlservercentral.com/Forums/Topic1094168-146-3.aspx

I hope my reply isn't too terse. I made...

you would have walked a safer path just posting the requested info !

Your solution may have worked, but might have been avoidable.

If I'm correct 2TB is the default max size...

Based on the statistics ... ( are they accurate ? / auto_updateon ? )

how about:

create procedure sp_DBA_RowCount

@TableName varchar(130) = null

, @TableSchema varchar(130)= null

, @MinRows int...

Post your sql errorlog file.

What's the db status ?

Is it online/offline/in recovery ?

Did you try sp_who_is_active to figure out what's going on ?

( http://sqlblog.com/blogs/adam_machanic/archive/2010/11/23/who-is-active-wins-gold-from-sql-server-magazine.aspx )

(b)locking, ...