thank you for your feedback, but part of the Error message trying to set up the SQL 2008 distributor is that the SQL server Replication does not support

VIPs, IPS...

From our company they only send one a year. There were some really great pre-seminar things during the day, but because of cost, they wouldn't send our SQL DBA...

I do want to say, I was not here when anything was done and would agree with anyone that it's not good practice to be using the system tables...

Rich,

I am looking for something similar, except my linked servers are two SQL 2000 servers talking to each other, same issue you are having.

I...

I had not fully realized the difference and do appreciate the explanation of both. Yet a new thing I can catalog in my Brain of Books online...:D

I"m glad you got to use Cross Joins! Thank you for your input, it helped greatly with what I was trying to achieve. 😀

I appreciate the reply to my post. I have to say I learned something new from you today! Thank you. As with all thank you for the...

Thanks for the quick response. I'll check that out.:)

Thank you Fraggle, you partially answerd my second question. I will try and clarify a bit.

Second Question:

Will sp_executsql of your string variable (ie: @SQLStr) physically see the # table when...

The reasoning behind that is because I was trying to get just one row with all elements for each PageType instead of having for example:  15 records for a pagetype...