Interesting that you posted this question today because I'd just been answering the same question here at work yesterday.  There are numerous scripts on this site that will give you...

I've used this for a quick find of like columns:

select

 CAST(so.name AS char(25)) 'Table Name',

 sc.name 'Column Name'

from

 syscolumns as sc

 INNER JOIN sysobjects as so

 ON sc.id = so.id

where

 sc.name like 'site%'

 and

 so.type...

Thanks, noeld.  I appreciate the input and alternate suggestions.  I knew the difference in the two. I just don't understand why truncate would throw a FK error message and delete didn't.  On...

I agree that No is the answer to your question, however I wanted to see if anyone could give me a clue as to why a

Delete tablename

works and a...

Have to make my first post by putting in my 2c that the one line answer is the one in BOL...

 --N.O.