Michael's tactic of only loading PKs that aren't already present in the table is pretty much the only way to go. The only shortcut I can think of to...

Tricky. You cannot backup the log-shipped database, because it is literally in the middle of the process of being restored. I half-way suspect they wrote that without thinking...

jpipes' revision should work. Here's the why.

There are essentially two forms for the CASE statement. The first (jpipes example) is based on the programming standard:

CASE

<if condition...

Just to spell it out, EM will "convert" the table by creating a new table, copying over the data, dropping the old table, and renaming the new table to the...

WAH!

I selected the correct answer in the email, clicked the link, got the web page, clicked "Answer" again... and only then noticed that it had "reset" the question, automatically setting...

Would "Maximum Worker Threads" (SQL Server internal value) affect this at all? We were advised to adjust this value for our Production database server from the default of 255...

I'd vote a general thumbs-down as well--but they do have their uses.

The primary negative point is Confusion. Schemas are a pretty abstract concept (the closest analogy I can come...

I went through a world of pain a long time ago to get linked servers to work. Here's a quote from BOL, from sp_addlinkedsrvlogin:

true for useself is invalid for...

Well, I for one completely disagree with the preceding post -- clearly that bozo doesn't know what he's talking about. (And since he's me, I think I'm qualified to...

I hit this once. Somehow, they didn't get installed, or were uninstalled. We uninstalled and reinstalled SQL Server, and they appeared--not a very good solution. Go through...

I found a partial answer. BOL does not indicate that the TEXT data column is pertinent to this event, but when it gets included the "name" of the lock"...

Just to mention, it is my understanding that writing to the transaction log is a key, integral part of SQL Server, in that it is absolutely essential for maintaining database...

You can use Visual Interdev to develop stored procedures and manage source control between Visual Source Safe and SQL Server (2000 or 7.0). I am obligated to point out...

I do what Greg does, use EM to generate the script--but only generate. I then tweak that script as necessary (particularly if new columns need to be assigned...

One night, there was this box with SQL 2000 loaded on it that was going to be formatted the next day. The other DBA said "yeah, you can rename...