You probably need to execute sp_recompile for each table and sp_refreshview for each view on the database after the statistics have been updated.

Why by IP address ? It is much more flexible to connect to any computer on a network via DNS name for a number of reasons.

The -L option will only pick up servers on your current network segment that are broadcasting. As for SQLRecon missing things, you need to adjust the parameters. SQLRecon also needs...

No.

I was just curious if it was version/service pack/hot fix related since it only occurred on 1 of 3 SQL Servers - hence the request for version information looking for...

There truly is no 'best practice'. The only answer is #1 on the Top Ten List of answers you do not want to hear from your DBA - It depends....

Aside from posting the actual code could you post the results of:

select @@version

from you dev, test and prod SQL Servers ?

Here is a rack mounted solution:

HP DL-380 G5

I thas Dual 3 Gh Xeon processors, 2 Gb RAM and uses only 1/3 of the previous generations power and cooling.

Add 6 10K...

If you have sufficient resources I tend to agree that there may not e performance issues. However another point of view is that a SQL Server is a server dedicated...

The management 'style', and I use the word very loosely, is a throwback to something in the 50's. My sympathy for those who have to work, albeit not even directly,...

Have you tried to change the order of the databases that are being backed up ? If you have and still receive the error then you may have run into...

Life, for most, has always been about 'being the best'. The unfortunate part is that 'most' of us have forgotten that in order to 'be the best', one only need...

Give SQLRecon a try - it's a freebie to find all of the SQL Servers on a network or series of networks. It helps if you have domain level authority...

Accounting and HR type data retention requirements are 'a breeze' - usually 5-7 years. The reason I say 'a breeze' is because I am now involved in the healthcare industry....

As to the BOL citation, it is 2K5 not 2K as the post is directed to - there is a difference in the documentation, behavior and experience. Again, the heading...

The "Short List" makes a few realistic assumptions. These are:

• The database is in production
• The DBA has more than one database to care for
• The DBA has more than one server to...