> -----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 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 chosen. > But, every time I call the stored procedure from the datasource using > <cfstoredproc I get no records back but also no error. > > Has anyone dealt with something similar to this? Any solutions?
Stored Procedures in the master database can be accessed globally, that is why you can perform the operation in query analyzer using sp_fkeys with the 'mydb' database selected. The problem sounds like you're calling the procedure with wrong/insufficient parameters. Post the code so we can analyze it, and also tell us the desired result. Andy ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

