It simply gives you an indication whether the error is informational, really important, fatal to a connection or fatal to the server. See the reference linked above for details.

I went and read the original message. It's whining, pure and simple. I then read as many of the comments as I could stomach. It's kind of freaky how attached...

The real problem is, I am a jerk. So I have to try to reduce the damage as much as possible. Emails are dangerous because, even a well crafted message...

Sorry, I wasn't trying to upset anyone. I'm serious. I screw up all the time. The checks I can put in place to prevent my own errors will help those...

In order to select FROM something, it needs to be a table valued object (table, view, function, temp table, table variable, OPENXML, XQuery). You can run a query against a...

What about literally breaking the query up into smaller queries? You can call them all from a single wrapper query. You get more discrete, tuneable execution plans and you can...

Works like a charm too... until the first time a request...

We're using this method and the same idea with whole databases in some of our datamarts. It works well to minimize down time. Best of all, if there is a...

Having sent a few e-bombs in my time, I try hard to look at what I've written before I hit send if emotion is an attachment. Usually, if I'm completely...

Oh, you'd have to drop the connections for the ms that the query takes, but, based on the process you've defined, you're slapping the users around at some point no...

How about sacrificing a little disk space;

Create the new table with a different name

load the new table

rename the old table

rename the new table.

drop the old table

The down time is completely...

Andras Belokosztolszki (11/29/2007)

---

You can download it from Microsoft's Codeplex site http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

Do read the instructions (after the install you will need to attach the extracted database files, but this is detailed...

You can get Adventureworks through CodePlex.

The 2005 version is located here.

You've got a slight syntax error. Your code should look like this:

CREATE TABLE BATCHES_LOT_DETAILS

(

[BATCHNO] varchar(15)

,[CALCULATED] char(1)

...

That last error sounds like you either aliased the table and then referred to it by name or that you dropped the table prior to that part of the script...