Greatly appreciate all you do Grant!  I have learned so much from you over the years.  Wouldn't be where I am in my career without all the things you share...

Thanks for the reply. Yes, I am aware of the limitations. That is why I was not sure the alt snapshot folder would work without the agent but...

I guess I was not clear on the problem. There are OLE Objects stored in an image column.

For example a JPEG file stored as an OLE Object. The...

Thanks! That works great.

I really appreciate the help.

Mark

My appologies for the missing tags. Below is the code.

I have a table with and XML column similar to the example below:

CREATE TABLE Test1 (ItemID int, SerialNumbers XML);

GO

INSERT INTO...

I grabbed it about a year and a half ago. I think it was somewhere on http://www.census.gov but I don't recall for sure.

Sorry Jeff, I do appreciate your feedback. Sometimes trying to simplify the post can confuse the issue. I am taking data from US census on names and...

Thanks Matt.

That will work.

I would still like to understand why the optimizer chooses to do a table spool on my query and change how the query functions when...

Ther query appears to work fine in SQL 2000 until the Last_Names table get more than about 10,000 rows. Then the optimizer changes the execution plan and the query...

Thanks for the feedback.

That would work but the performance is terrible (I killed it after 10 minutes). A cross join between my first names and last names produces over...

Here is some sample code and expected results. When I ran this sample code it worked fine in both SQL 2000 and 2005 but when I use my real...

Ideally yes. It currently works on 2005. I do need it to work on SQL 2000 but it does not necessarily need to be the same code. ...

Sorry. I tried to simply the post and may have confused it more.

This is part of a script that inserts data into one of our tables. So I am...

Actually PubID exists in both but PartnerID was removed in SQL 2005.

I could probably use PubID for my purposes but still wonder if there is a cleaner way.

Thanks.

Never mind. I found the problem. I needed to include ";Provider=SQLNCLI.1" at the end of the Expression and then it worked fine.