locked
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

Answers

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

     

    Eg

    ALTER AUTHORIZATION ON SCHEMA:Tongue TiedeattleProduction11 TO SandraAlayo;

     

     

    Madhu

    Monday, November 26, 2007 5:00 PM