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, ...

"Guestimate" is the keyword.

You could start with determining each columns max data length (/2 for the number of chars)

Then create your trial table and try the import.

Keep in mind to...

someone forgot to update the download xls :blink:

the chaps already helped out 😉

the complex and/or/and/or where clause

The suggested:

WHERE QO01ACCIDENT_YEAR in ('2008','2009','2010')

AND

(QO01SUBMIT_AGENCY_ORI = 'XXXXXXXXX'

OR

QO01MUNICIPALITY = 'XXXX')

provides the same predicates,...