Krishna ... I use the following outline:

Round II

DBCC DBREINDEX

UPDATE STATISTICS (with FULL scan) for all tables

Because I only do indexes that need...

Hey Grant - no problem - was just trying to get some suggestions out there based on the limited information - personally I index-defrag before index rebuild and then only...

Why don't you try a low-tech debugging aid

print @eml_id

print @rcpnt_cc

Just prior to the exec for the mail send and see of the addresses...

... they do not like what they do ... (yeah, direction, tools, technology or whatever)

... they do not like who they work with ... (coworkers, other teams/departments/organizations)

... they do not...

Point taken Lynn. However given the size and scale of the issue ,the minor inconveniences that making partitioning work in standard edition would probably far outweigh the potential fallout from...

Take a look and see if there is any database maintenance/optimization. If not, then that is a great first step. As Jeff said, there is no reason things should run...

Partitioning anybody ???

We have the same issue but via a maintenance plan backup or query window for that matter. There are a couple of work-arounds we have found.

- Use the same service...

We currently use 16 15 Gb files for tempdb data on a 64 CPU active/passive cluster with 128 Gb of RAM and things start up/failover in less than 2 minutes....

I am going to assume that you went to x64 for SQL 2005 as well.

Right off you doubled the number of processors - always good.

Then you quadrupled RAM - even...

There could be many reasons. Let me ask a few questions.

- Is the hardware different ?

- Are the OS's different ?

- Is the load on the server the same ?

-...

Getting down to "brass tacks" ...

- 200+ servers and/or instances thereabouts

- roughly 50/50 SQL 2000 & SQL 2005

- no plans at all for 2008

- why, licensing...

... Pruning ?

... we don't need no steenking Pruning !

Here are the instructions that we use:

Note – before you begin

The following instructions are for changing service account password ONLY.

These instructions work for Active/Passive clusters and n+1 clusters as well.

If...

I'm with Ed Vassie - in the past I have used nothing but FQDNs and aliases for SQL Servers , application databases and web and application servers. This allowed us...