September 23, 2004 at 1:53 am
good morning all,
I have a requirement,whereby I want to pass a stored proc a table name, and have it list, all the other tables referencing the given table (only 1 level deep)
what would the best way to accomplish this be?
thanks in advance,
Alex
September 23, 2004 at 2:09 am
You don't need to write one, you simply use sp_depends.
September 23, 2004 at 2:15 am
hiya, thanks for that.
i didnt explain my question very well, (infact my explanation was attrocious).
I want to be able to determine what order I need to insert the table in...
so rather than just a list of dependencies, i would like them in the order that i need to insert into them...
thanks,
Alex
September 24, 2004 at 9:02 am
Look at this article here on SSC. We've used it and it works well.
Greg
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply