[dba-SQLServer] Fw: stored procedure

KensProgramming kens.programming at verizon.net
Thu Nov 6 14:16:34 CST 2008

Only if you are executing it within master, otherwise, sql server needs to
know where the sproc resides.

Business Analyst

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan
Sent: Thursday, November 06, 2008 12:13 PM
To: SQLList
Subject: [dba-SQLServer] Fw: stored procedure


However, is there anyone to call a stored procedure from master without 
using the syntax master..storedprocedure?

Susan H.

>I created a stored procedure and saved it to master -- when I call it from 
>AdventureWorks, I get an error -- can't find stored procedure. What am I 
>doing wrong?
> Susan H. 

dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

No virus found in this incoming message.
Checked by AVG - http://www.avg.com 
Version: 8.0.175 / Virus Database: 270.9.0/1770 - Release Date: 11/6/2008
7:58 AM

More information about the dba-SQLServer mailing list