Sure. Sorry I couldn't help.

You might run into problems with those non-ansi joins too.

Instead of "FROM X, Y WHERE X.Id = Y.Id" you would use "FROM X INNER JOIN Y...

It's just a server with databases on it as far as normal operations are concerned. You shouldn't have any issues of any kind running a restore.

Amit Tiwari (3/14/2008)

---

Hi Everybody,

I have a table having Five Columns

CREATE TABLE TABLE_X (

Col1 INT NOT NULL,

Col2 varchar(10) NOT NULL,

Colc Datetime NOT NULL

)

PRIMARY KEY CLUSTERED IS ON COL1 & COL2.

THERE is...

WILLIAM MITCHELL (3/14/2008)

---

Grant,

Since the status column is an int, I am guessing that there is a table of statuses that gets joined on the status column, so I would think...

Wallace Wood (3/14/2008)

---

As a contractor for the $$$ I have been paid I would clean up the person's yard. Large canids in extent not withstanding.

Given that this is a...

I served mainly on pretty small boats & ships (short time on an LST) so I didn't see any of the crews I worked with die. Considering some of the...

What do your execution plans look like. What kind of indexing is on the table.

While 16 million rows is not small, it's not so outrageously large that you can't...

Really? They feed that crap to people? That's nasty. I'm glad I'm not too bipolar (shut up... no you shut up... shhh, they can hear us).

Chrissy (3/14/2008)

---

Hi guys,

I am very much a newbie, and I just wanted to say this forum has actually given me confidence to start training as a SQL DBA in my...

Oh, we had freon too. Did you know that freon, when...

Brandie Tarvin (3/14/2008)

---

Chris said:

Grant Fritchey (3/14/2008)

--------------------------------------------------------------------------------

I don't know if I'd call poking holes in water the "front lines" but from what I saw of the AF, you guys had...

Also, do a search in the Scripts [/url]section here in SSC. You'll find all kinds of examples for doing what you need.

OK. I'm confused.

You can use a wrapper proc to call the other procedures. You just have to make sure that the wrapper proc has parameters for those procedures. I do...

Which CTP are you running. I'm running the February version. I just finished generating an entire data model using the Adventureworks database. No problems. Assuming you're running the February CTP,...

Short of out-right illegal behavior (and that doesn't count stealing tools & supplies from the shipyard) I've done just about anything I had to for or at work. Between retail,...