Well, here's the behaviour I'm seeing. I created a view, using the information that you provided. I then attempted to delete a single row from that view using Query Analyzer....

How are you getting the ProductName column? You'd have to do a join between Order Details table and the Product table; correct? Unless your view is in turn accessing another...

- Each node keeps its own binaries on its own local disks.

- Quorum goes on a shared disk.

- Any data that is to be failed-over, e.g. Database data files, go...

Regarding bit columns:

Bit columns can, but won't necessarily save you space. Although SQL Server can fit 8 bit columns into a single byte, my understanding is that if you have...

There's an easier way to do it. Use a statement like this:

--

SELECT dbo.tblUser.iUserID,

dbo.tblCampaign.iCampaignID,

dbo.tblCall.sBTN,

...

It really depends on whether or not there are other columns in the table beside the two columns that are used in the index. If there are other columns in...