Viewing 2 posts - 1 through 2 (of 2 total)
Try:
SELECT Table_Name
FROM Information_Schema.Columns
WHERE Column_Name = 'myCol'
Hope this helps
April 29, 2005 at 7:47 am
#555913
Jeremy
One extra point to add. If your user is only in database2, then you will need to use cross db ownership chaining to allow the procedure from database2 to call the...
April 12, 2005 at 9:28 am
#552166