Francisco H Tapia
my.lists at verizon.net
Tue Apr 1 14:47:18 CST 2003
Use YourDbName exec dbo.YourSprocName (in a new window) -Francisco http://rcm.netfirms.com On Tuesday, April 01, 2003 12:41 PM [GMT-8], Mark Boyd <MarkBoyd at mcbeeassociates.com> wrote: : This is probably a simple question. Sorry for the ignorance. : : I usually use SQL2k's Query Analyzer to run sprocs. I can select the : sproc from the Object Browser, right-click to Open, then click : Execute. : : However, I can't find the Object Browser in SQL7. Therefore, I can't : find another way to execute a sproc without creating an Access module : and using DoCmd. : : Is there an easier way to execute sprocs with SQL7? : : : : TIA, : : Mark Boyd : : Sr. Systems Analyst : : McBee Associates, Inc. : : : : : : : :: _______________________________________________ :: dba-SQLServer mailing list :: dba-SQLServer at databaseadvisors.com :: http://databaseadvisors.com/mailman/listinfo/dba-sqlserver :: http://www.databaseadvisors.com