[dba-SQLServer] Fw: stored procedure

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

Thanks
 
Ken
Business Analyst

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

Nevermind...

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
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.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