I prefer to use DBCC ShowContig and utilize the following criteria as to rebuild or reorganize.

On indexes with more than 10,000 pages

Rebuild when Logical Scan is 20% or higher

Please...

It depends on what SQL services you have running. The upgrade will inform you of which services are running and which will require a reboot if they are not...

On Wednesday evening I went from Service Pack 2 to Service Pack 4 in under thirty minutes.

Recently applied SP4 to our Development server and tested by moving a database from that particular server to our QA (which is still SP3) all worked fine.

You can use a file splitter application to make smaller chunks - thus allowing you to even email yourself the file.

Another option would be to use a http://FTP...

srpd.m123 if you are new to Admin role and you are unfamiliar with where to run the code, maybe a Maintenance Plan would be best for you. You can...

Have you attempted to remove the Microsoft SQL Native Client prior to applying the Service Pack 2? There is a good chance that this is corrupt.

SKYBVI is correct, the easiest way to address linked servers after an upgrade is to use the SSMS and script the linked servers. Be aware, unless you copied the...

A company I worked for in the past was a certified SQL Server resellar. Unfortunately I never found the proper/correct way to answer this exact question. My work...

SQL Distributed Management Objects is the original COM API which was used to manage SQL Server. Your challenge will be to figure out which program the API is using....

Please review the following forum thread - http://www.sqlservercentral.com/Forums/Topic491773-146-1.aspx#bm491978

Shouldn't be a problem, please have a look at this MSDN link - http://msdn.microsoft.com/en-us/library/ms143393(v=SQL.90).aspx

As Lowell mentioned, for the executable and services, you don't have a choice. However, during the installation process, when you get to the step regarding file location, this is...

Find a copy of the ODBC32.dll file and replace it on the affected machine. More than likely it got overwritten.

Please review this MSDN link, it should answer all of your questions.

http://msdn.microsoft.com/en-us/library/ms143293(SQL.90).aspx

Good luck