Regarding Gail's Question, you have not clearly described what steps did you perform to move the System Databases, you have copy pasted almost the same post that you posted yesterday,...

Regarding your question on using replication from Views, You can replicate Views but the underlying tables must be present on the Subscriber.

Can you post the Script for create Table and Insert Data into, so that we would be able to use that and setup the same at our end.

Use the...

You can solve the problem using SSIS, I agree with Elliott, about the efficiency and Performance of SSIS packages doing this.

The only consideration I gave to BCP...

In the past, I worked in a company which has a Vendor Application which uses SQL Server 2000 / 2005, but the Application is designed in such a way that,...

You apparently have given a good description of what you have in place and what you intend to do, and also, you have pretty much figured out what are the...

You need to Shrink the Database.

Use DBCC SHRINKDATABASE or the Individual Data Files, using DBCC SHRINKFILE

Rather Use the Enterprise Manager

Right...

Completely Agree with John, there is no chance to rollback the Service Packs.

What do you mean by Master is in the command line arguments? Have you moved...

It seems you are using Windows Server 2008.

Did you check with the Windows Admin / Engineer about the Security permissions for the New location (New Drive where you are moving...

I Understand you are unable to login to SQL Server, but I was asking to look in the Error Log File

@ INSTANCE\MSSQL\LOG\ Location, may be that give more info.

Hi Pedro,

When you said moved the System Databases, did you follow the steps mentioned in MSDN about Moving System databases in SQL 2008. (Since there is a change in procedure...

My Suggestion...

Before Installing Service Pack on the Production / Staging Servers where Data is Crucial, Try installing on a test server and test the functionality of the applications / programs...

You cannot uninstall only the SP3 for SQL Server 2005.

You have to unistall the entire Product (SQL Server Instance)