Tables used by stored proc.

Question

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

SSC Guru

Points: 51650

April 21, 2003 at 9:51 am

Run sp_depends 'yourspname'.

Andy Warren SSC Guru Points: 119902 More actions · Answer 2

Sp_depends will give you some of it - isn't always 100% accurate since SQL allows you to reference objects not yet created.

Andy

genestepura Newbie Points: 6 More actions · Answer 3

Exactly i.e. #temp tables are not included.

should I be looking looking for a parser?

Lots of very big procs.