Finding out if a view is used

[akki007]

I have many many views and I would like to do some housekeeping. Is it possible to run a SP to find out if a view is in use by a stored procedure or another view etc?

Ta

 

[JayKusch]

You could script out all the Stored Procedures and Views to a text file and then edit the file(s). Do a simple FIND on the needed view name w/in the file and BINGO.

Thanks

J. Kusch

 

[Juice05]

How about querying the syscomments table.

Try this:

Select * From syscomments
Where Text Like '%[Your view name]%'

 

[vongrunt]

Or sysdepends... though it won't help much if dynamic SQL is heavily used.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)