Does not work
SELECT * FROM information_schema.routines r
WHERE charindex('Dbo.People2', r.ROUTINE_DEFINITION)>0
Does work
SELECT * FROM information_schema.routines r
WHERE charindex('People2', r.ROUTINE_DEFINITION)>0
Nate Schmidt
fully qualified my tables ([database].[schema].[tablename], I suppose putting a period in the front would work...but I don't
Tried that and it does NOT work
My conclusion is it will not work with a fully qualified name, and/or the inclusion of the schema name.
Suggest that a note accompany your script to that effect.
Now knowing that ,it is an EXCELLENT script and will prove to be very useful... THANKS for contributing.