Link to home
Create AccountLog in
Avatar of Allan
AllanFlag for United States of America

asked on

List All Tables From Views, Functs, Sprocs Access

Hi Experts!

Hope you had a Merry Christmas.

You have an AD (active directory) account that has access to views, functs, and sprocs, and you want to know all the tables that are involved. How do you script a sql for this? This is for MS SQL 2008 box.

TIA!

ASKER CERTIFIED SOLUTION
Avatar of Ryan McCauley
Ryan McCauley
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Allan

ASKER

thanks. I will try it.