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...

Or do a search in the little box near the top of the page. You'll find tons of discussions and articles and scripts on the topic, all on this site.

As far as I know, you're going to have to monitor that table. That means setting up some type of service to check the table periodically and respond to the...

Do you mean something like this:

ALTER TABLE dbo.X

ADD CONSTRAINT MyConstraint

FOREIGN KEY (aa,bb)

REFERENCES dbo.Y(aa,bb)

Like that?