Yes. What I described was...

Jeff Moden (12/19/2007)

---

Sorry... I didn't say it quite correctly... if the table is preformed with an IDENTITY column, you'll be ok... it's actually when you use the SELECT/INTO with the...

Jeff said: "The only thing you sometimes have to worry about is if you expect an IDENTITY column to keep the insert order. Turns out that the identities are...

ROFL! That will at least get their attention.

Good column, Steve. We faced that issue in my shop. We needed a database to test scaling and while we had one that met the requirements it did...

Jeff Moden (12/18/2007)

---

10 hours to 15 minutes? Heh... I like SELECT/INTO a lot but I've not seen that type of performance gain just by switching like that before... Are...

Matt said: "The million $ question is whether you are ALLOWED to "reverse engineer" the sequence assigning process (or in this case - leave the existing process alone, but...

Jeff Moden (12/14/2007)

---

I think David recommends his method because SELECT/INTO will temporarily lock SysObjects while the data is transferring...

However, I prefer the SELECT/INTO method for two reasons...

1. If...

I've been using SSMS for a couple of months to manage my SQL Server 2000 development work and so far I have not run into any problems.  (I don't use...

Daniel, I'm glad that did the trick.  Win 2003 can be a real pain in the neck with SQL installs.  The improved security comes with a price. 

"I can log in using osql and the sa user name, but I can't connect to the SQL Server from a client computer on the network.

There is only the default...

Sorry for the delayed reply.  I was not talking about installing a service pack, I was talking about installing databases via an InstallShield front end.  The front end invokes OSQL...

Have you considered using a derived table inside the stored procedure rather than a temp table or are the parameters too varied?

Part of the problem is likely to be that a delete logs the records deleted.  You might want to test selecting the data you want to keep into a temp...

Are you connecting with a domain account or with a SQL Server login?  Have you tried dropping the login (NT or SQL) and recreating it them granting it access to...