April 24, 2014 at 12:16 am
cannot drop function because it is being referenced by object in sql server
Plz give me the solution with brief explanation
In Advance Thanks
April 24, 2014 at 12:21 am
Another object is referencing your function. For example another function or stored procedure is using the function you want to drop. If you would drop it, it would break the other function.
You either have to change the other object, or drop it first.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 24, 2014 at 12:35 am
ANY ANOTHER ALTER WAY WITH OUT DROP THE OBJECT.......
April 24, 2014 at 12:41 am
It seems your caps lock is broken.
This thread lists some solutions to find the object that is referencing your function:
Find it and alter the code so that it stops referencing your function.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 24, 2014 at 11:18 pm
exec sp_help 'procedure name'
and check the output
😎
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply