Darrell - as Remi is my current role model (may change next week)...

hth! Amen! <:-)

Here's ONE way...

using Darrell's query:

select column_name from INFORMATION_SCHEMA.KEY_COLUMN_USAGE

where table_name = 'TableName' and constraint_name like 'PK%'

Yes indeed - I'm in denial...unfortunately the madness extends to Egypt as well for I just read that the diplomat captured yesterday may have been killed....

The scary part about all...

Phill - I'm putting all my money on Remi (sorry!) - though not given to any blustering (none that I've detected so far anyway) he is a very fast typist...

Yes indeed - there's more than 1 way to skin this cat...

don't forget to add "where table_name = 'TableName' to Darrell's query!

psarrell -...

Amen! I'm trying not to read the news at all...sometimes burying your head in the sand does help...those ostriches do know a thing or two...

thanks s (swords)...

huh ?!?!

Too too kind Mike...am all choked up with your generosity - the only time I baked there were "four and twenty blackbirds"....will send you some "singing birds" in exchange for...

Remi - why did I know you'd come back with this ?!?! Just listing all columns is all...in case there're no indexes etc...HTH! Amen!

Or even more specifically:

EXEC sp_columns @table_name = 'TableName'

How about if you run it without the xtype = 'PK' filter ?! What do you get then ?!

This may seem silly to suggest - but please check the spelling of the table name carefully - I just tried it with a misspelled table name and it did...

Are you running this in QA ?! My query should work if you're connected to the right datbase - ie, the database that has the table that you want to...

I'm so sorry to hear about your ex-wife and it's really distressing to hear about how people have to find ways to circumvent the Law and/or bend it....

considering that the...

Here's one suggestion - Have you looked into Openrowset function to see if you could use that maybe ?!?!