[dba-SQLServer]Execute sproc with SQL7

Mark Boyd MarkBoyd at McBeeAssociates.com
Tue Apr 1 14:53:28 CST 2003


Franciso -
Perfect!  Thanks a lot.

Mark

-----Original Message-----
From: Francisco H Tapia [mailto:my.lists at verizon.net] 
Sent: Tuesday, April 01, 2003 3:47 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer]Execute sproc with SQL7

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


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



More information about the dba-SQLServer mailing list