Re: Unable to find stored procedure 'sp_tables'

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 02/15/04 

Date: Sat, 14 Feb 2004 22:49:08 -0600

See if the following corrects the problem:

USE master
EXEC sp_MS_MarkSystemobject 'sp_tables'
GO 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Frank" <anonymous@discussions.microsoft.com> wrote in message
news:BD12123F-A3CE-4BE7-AF23-12D98CD8CD28@microsoft.com...
> The stored procedure 'sp_tables' does exist in the master database.
However when I execute it from within any database on the server I get the
error.

Relevant Pages

  • Re: using sp_ as a naming convention for stored procedures
    ... > name for a stored procedure it automatically causes the ... > call to go to the master DB to look it up. ... Aaron Bertrand ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: unable to start SQL Service ... error code 3417
    ... If the Master database is corrupt, how would you advise I maybe replace with ... "SQL Server cannot start the master database. ... MVP - Windows Live Platform ...
    (microsoft.public.sqlserver.server)
  • RE: master DB users
    ... (No user other than DBA should be allowed to access the master database). ... explicitly to database users in master, except those that SQL Server ... Those that are not in the sys schema ...
    (microsoft.public.sqlserver.security)
  • RE: master DB users
    ... In my company I have a standard that Restric Access to Master Database ... the reason for lising the all master db user with their permission. ...
    (microsoft.public.sqlserver.security)
  • Re: Cross database granting
    ... Just create a user in the master database for your login and then grant EXEC ... Tibor Karaszi, SQL Server MVP ... > Chris Buys ...
    (microsoft.public.sqlserver.programming)
Loading