Home Forums SQL Server 2008 T-SQL (SS2K8) BCP Error : Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'dbo.EXTGEN_InitSessionContextSp'. RE: BCP Error : Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'dbo.EXTGEN_InitSessionContextSp'.

  • March 22, 2013 at 8:16 am

    #1599790

    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