August 7, 2012 at 8:29 am
Change: INNER JOIN sys.tables st ON st.[object_id] = si.[object_id]
To: INNER JOIN sys.objects st ON st.[object_id] = si.[object_id] AND st.type IN ('U','V')
Your script will be of use to me. Thanks.
August 7, 2012 at 8:36 am
Please ignore this topic.
I am a newbie and I created a topic when I was trying to post a reply to a topic.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply