skb 44459 (3/22/2013)
SQL 2005. Our Database Server is 2005 . Is there a way to use -d option with 2005 server ?
Unfortunately, no.
Can you help us understand the setup a little more about this statement:
But we have hundred's of procedure provided by our ERP vendor which we can not change technically.
Is there a work arounnd for
IF OBJECT_ID(N'extgen_ki_TestLoop1') IS NOT NULL
Why are you trying to check for the existence of a stored procedure in a database other than the one you are in? And if that is needed, why are you opposed to fully-qualifying the existence-check?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato