Re: SQLServer Stored Proc Permissions

2002-01-23 Thread Sam Farmer
- Original Message - From: "Andrew Tyrone" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 23, 2002 4:25 PM Subject: RE: SQLServer Stored Proc Permissions > > Stored Procedures in the master database can be accessed g

RE: SQLServer Stored Proc Permissions

2002-01-23 Thread Andrew Tyrone
> -Original Message- > From: Samuel Farmer [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 23, 2002 4:21 PM > To: CF-Talk > Subject: SQLServer Stored Proc Permissions > > > Hi, > > I am trying to use a system stored procedure in SQLServer7 that is i

SQLServer Stored Proc Permissions

2002-01-23 Thread Samuel Farmer
Hi, I am trying to use a system stored procedure in SQLServer7 that is in the master database called sp_fkeys. My datasource accesses a database called 'mydb' that does not have the sp_fkeys stored procedure in the database. In Query Analyzer the stored procedure works with the sams database is