erro specified schema(logins)

• srimkumarp-720356

  Ten Centuries

  Points: 1300

  More actions

  October 7, 2009 at 12:38 am

  #210565

  Hi All,

  One of your developer having problem with sql server 2005, user is able access the stored procedures functions and other db objects using application.If user is trying to access using sql server console..

  it is throwing error msg

  --------

  Msg 2760, Level 16, State 1, Procedure getting_date, Line 14

  The specified schema name " db\testing1" either does not exist or you do not have permission to use it.

  ---------

  That user is having access all databases with db_owner permission still user unable to create,alter procudure,functions.

  please do the needfull

  thanks,

  kumar

• Nabha

  SSCrazy Eights

  Points: 8534

  More actions

  October 7, 2009 at 8:11 am

  #1062797

  sql server console meaning sql server management studio?

  Can you copy paste the code that you are running which is giving you the error here?

  ---------------------------------------------------------------------------------