Post reply

Changing a system stored procedure

  • June 30, 2004 at 12:17 pm

    #83258

    ODBC V2 apps not working on SQL 8.0.  Found an article with a patch to sp_datatype_info system stored procedure.  Would like to test the patch but unable to update the procedure.  Looking for instructions for updating a system stored procedure.

    Able to drop it with T-SQL and recreate.  Thanks

  • July 1, 2004 at 12:44 am

    #512809

    Playing around with SQL Server's system objects is one of the easiest ways to fubar SQL Server. In doing so, you're running an unsupported system. I would rather contact the vendor of the ODBC V2 app and see what he suggests.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • July 6, 2004 at 11:17 pm

    #513569

    Do not play with the system SP's. What you can do is :

    Find the body of System Proc using sp_helptext 'spname', and then create one for you with different name.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply