Create logins based upon the SID of one machine and create them on the other. When you restore the databases because the SID matches the one in the database it...

Perry Whittle (12/14/2008)

---

i havent...

Prakash.Bhojegowda (5/7/2008)

---

I called Microsoft and was on phone with them for 6 hours yesterday. They were not able to give me an explanantion. They turned around and said that, this...

You could also run this

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2

ALTER LOGIN [sa] WITH PASSWORD='the really really strong SA password'; ALTER LOGIN [sa] ENABLE;

/******* RESTART SQL INSTANCE TO TAKE EFFECT...

Per http://msdn.microsoft.com/en-us/library/ms175046.aspx you can only have a single set of quotes in an xp_cmdshell. Have you tried removing superfluous quotes?

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2

ALTER LOGIN [sa] WITH PASSWORD='the password'; ALTER LOGIN [sa] ENABLE;

/******* RESTART SQL INSTANCE TO TAKE EFFECT *******/

Is the developer instance running on your machine or on a remote server?

Have you run SP2 and ensured that you updated the tools to SP2 as well? There is potentially...

Are you seeing any error in the event logs or the SQL Server log?

Great, thanks Steve.

usman.tanveer (12/12/2008)

---

Nicholas Cain (12/12/2008)

---

You can either download a tool to perform these checks or you can run queries from a remote machine to check on the status of SQL and...

You can either download a tool to perform these checks or you can run queries from a remote machine to check on the status of SQL and whether logins are...

Sorry, I haven't found anything that speaks to this as an issue, and couldn't tell you what to try as regards finding this on the web.

The temp file is probably holding the resultset that it wants to return to you, however is waiting for the entire query to complete.

You could change the environment variables to...

Before canceling the query have you looked around the to locate the directory which is filling the C drive?

Have you downloaded and applied the DTS Designer Components from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en which allow you to manipulate the packages and make changes?