Could not find store procedure 'xxx'

• dr43058

  SSC Journeyman

  Points: 86

  More actions

  November 30, 2011 at 8:50 am

  #251257

  On a local instance of SQLEXPRESS08, which is named instance as in machinename\myinstancename, in the query editor, I am getting "could not find stored procedure 'mysprocNAME' !!!

  Whenever I try to reference a table, no problem, Intellisense works CORRECTLY, it shows the tables for the database in my USE statement, USE MYDATABASE. Beware, I do not understand the security architecture of SQLSERVER05-08(schemas, users, logins, etc...). Please help!!!

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  November 30, 2011 at 8:58 am

  #1414746

  Execute following query & verify whether your SP exists in your database. If yes, which schema?

  USE <database_name>;

  GO

  SELECT name AS procedure_name

  ,SCHEMA_NAME(schema_id) AS schema_name

  ,type_desc

  ,create_date

  ,modify_date

  ,schema_id

  FROM sys.objects

  WHERE type_desc LIKE '%PROCEDURE%';

  GO

• Jared

  SSC Guru

  Points: 61793

  More actions

  November 30, 2011 at 10:06 am

  #1414812

  dr43058 (11/30/2011)

  ---

  in the query editor, I am getting "could not find stored procedure 'mysprocNAME' !!!

  So this is before you try to execute it? If so, does it execute properly?

  Jared

  Jared
  CE - Microsoft