debug a stored procedure in schema RRS feed

  • Question


    hi, i'm trying to debug a stored procedure (in sql server 2005) with visual studio 2005, but all my tables and procedures are inside a schema and when i configure my login in sql server for being in sysadmin role, it dosn't map the schema so i need to write the schema before the tables and procedures, and i don't need it in that way...

    how can i do to have a login in sysadmin role and a schema maping in than login???,

    thanks ....

    Monday, November 26, 2007 4:36 PM


  • Change the schema owner as the login/dbuser you use to connect to db



    ALTER AUTHORIZATION ON SCHEMA:Tongue TiedeattleProduction11 TO SandraAlayo;




    Monday, November 26, 2007 5:00 PM