Without having the DDL for the table and indexes I can only offer the step for a general fix. Unfortunately it requires a little bit of down time.

• script out...

I always knew that there was a reason that I would not want to work with SAP - 25,000+ tables seems like a really good one.

Jeff, I really like your...

I've mulled this post over for quite a while. There are lots of interesting things that have been stated. The Junior/Mid-Level/Senior categories and application/development/production categories all have meaning. Unfortunately each...

Why are you monitoring for changes in 'system' stored procedures in the master database ? Do users have the 'sa' password or 'sysadmin' role ? or is this a compliance...

The default alerts just provide minimal monitoring, a starting point for more proactive maintenance. If you have something else to monitor your SQL Srvers like MOM 2005 then by all...

Do you have trace flag 3604 or 3605 set as well ?

Just a note on the probabilities of loosing both disks in a mirrored pair. We have experienced this twice in the last two weeks. Once each on two different servers....

One more point. The table identified as T1 is not qualified. Depending on the user ID supplied this may change what database the table will be looked for in. By...

The question made me think just a bit. I agree with Steve, there was not enough clarity in it. There are logical justification for more than one correct answer based...

Since we are not quibbling about details ... ...there are a few post deletion steps that need to be added to maintain the...

Alain, I have t go buy a hat now so I can take it off to you !

Most Excellent !

Why not try FERRISTS1_GP pointing to FERRISTS1.FERRISMFG.LOCAL instead ?

http://www.geocities.com/Hollywood/Set/4159/ABBY.WAV

Jeff, I still think that DNS and DNS aliasing are the answer since it is a global solution with a change in one place only whereas HOSTS entries are one to...