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? Thanks Sam Farmer - Senior Developer Certified Advanced ColdFusion 5 Developer [EMAIL PROTECTED] INTELIX - Intelligent Solutions <http://www.intelixinc.com> ______________________________________________________________________ Get Your Own Dedicated Windows 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=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
