Mike, one question on the Synonyms. What is their "lifetime" in the server ...meaning if i create the synonym how long will the server track that synonym for me...

Thanks Mike...i think i'm going to try that as it's more in line of what i was looking for.

And thanks to everyone else on the dynamic sql. ...