Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-29 : 22:48:38
|
Narayanan writes "I found a Design Problem in MSSQL Server 7.0
I wanted to see which of current tables are in use by looking into all the Stored Procedure's dependency information.
The problem is that the dependency information given by the SQL7 Enterprise Manager doesn't show the tables which are involved with temporary tables?
Example: - the problem -
Say I Have two Tables Tbl1 & Tbl2 in the DataBase
and I Have the following code in the SPDoSomeTask:
--------------------------------------------
--SP starts here
>Procedure SPDoSomeTask()
>create #tmpTbl(....)
>Select * from Tbl1
>Insert into #tmpTbl
>Select x,y,z from Tbl2
--SP ends here
---------------------------------------------
The Dependecy Information for the SPDoSomeTask should show Tbl1 & Tbl2 but, as of now it shows only Tbl1.
Can you suggest me a solution or a workaround?" |
|
|
|
|
|
MS-SQL-SERVER 7.0 Dependecy information