Steve Jones - Editor (2/28/2008)

---

I like seeing the proposals for new nuclear plants. The newer designs (I hope ) will get better and pay dividends.

Matt, not sure I agree with...

Let's rephrase that to see if I'm hearing the question correctly.

Are you looking to simply enforce uniqueness across those three columns? If you simply create a UNIQUE CONSTRAINT on...

You can dump the one record into a table var, and read that.

Or - set the return status of the SP so that the calling app knows why it didn't work....

(not a huge fan of raiserror)

Also - do the management reports work in Express? do they work in every version? (with SP2 on)

I could swear I had an SP2 install, and nothing under right-click....

You should be able to see one in the device manager under Manage. Right-click my computer, Manage (which you can also connect to a remote machine with the right...

Good to know it worked - thanks for the feedback!:)

I don't think Access allows for CAST. It uses the more "VB-like" functions for casting: Cstr (cast to string) Clng (long int) cdbl (double) cdate....

For some reason I've seen this disabled on occasion, but assuming your install is "fully functional": right-click on the database name, pick "reports", "standard reports", "disk usage by table".

I'm not sure what yuo're using this table for - but just shuffling the identity fields around usually causes a LOT of throuble.

Reusing identity numbers previously used is a relational...

Depending on a lot of factors, but yes - you can do it without SSIS. Whether you SHOULD is an entirely different topic.

Assuming the Access database is in a...

jeremy.giaco (2/28/2008)

---

There really isnt much of a...

Hmm - I think this give you what you wish (not sure it's all that performant)

Select O.* from Orders O

where

exists (

select null

...

So - if I understand you - you want to return all orders (and all of their line items) if the lineitems include any of the product ID's you list?

Select...

Instead of bringing the mountain to Mohammad, why not bring Mohammad to the mountain?

As in - why not copy the database and move it to the data directories where SQL...