Hmm, actually, looks like my information may be a little out of date.

It has a one line statement in the Windows Server Backup document that mentions an awareness of VSS...

The backup log looks like this:

Database backed up. Database: eGActiveDB, creation date(time): 2011/03/07(14:25:37), pages dumped: 99998, first LSN: 178:187120:196, last LSN: 178:187202:1, number of dump devices: 1, device information: (FILE=1,...

I don't see what's wrong with your original query (although my personal weapon of choice is NOT EXISTS)

Do you have duplication within v8.dbo.Country? E.g the same Serial twice? If so,...

SDB15 (9/27/2011)

---

Use CTEs with care, if the expected row count is very high, you're actually better off with a temp table. I've also read that CTEs have a hard time...

No worries!

R.P.Rozema (9/27/2011)

---

Please read this page on Operator...

martin.kerr 34088 (9/27/2011)

---

Thanks for your responses; I have tried all the SELECTs you have suggested but I am still receiving records back which contain a value in the 'Pass2' column.

Any...

I suspect someone's probably started playing around with DENY permissions (either for your user/group/role or are trying to lock down the public role incorrectly).

If your user/role definitely has permissions, then...

Whoa. Do not make the Filestream store a shared folder.

It's part of the referential data in your database and you'll end up with corruption if anything else can modify it....

Hi Gianluca,

Have a question about this code:

IF @localTran = 1 AND XACT_STATE() = 1

ROLLBACK TRAN

Once you're in the catch block, wouldn't you want to roll back the transaction...

Absolutely. Which is exactly what I did once Drew pointed it out and apologised for my mistake.

I'm not sure how that comment's helpful.

In this case, I thought I knew the functionality well enough,...

Actually, this is going to be a tricky one to solve. From what I can see, the latest driver that can connect to Oracle 7 (and it actually mentions a...

According to metalink, it's definitely incompatible. Remember Oracle 7 was released in 1992, so is nearly 20 years old now!

I've never dealt with such old versions, but you should be...

CELKO (9/21/2011)

---

However, this sounds like it might as candidate for a better schema design. Why would you ever have the same data in two places when the whole purpose of...