[dba-VB] SQL Server 2005 Stored Procedures (Confused !!!!!)

Michael Maddison michael at ddisolutions.com.au
Wed Jul 12 18:35:20 CDT 2006

Save will save as a script, execute places it in the db... ;-)))


Michael M
-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of
paul.hartland at fsmail.net
Sent: Wednesday, 12 July 2006 7:30 PM
To: accessd; dba-sqlserver; dba-vb
Subject: [dba-VB] SQL Server 2005 Stored Procedures (Confused !!!!!)
Importance: High

To all,

Sorry for cross posting this again to those of you that will receive
this email more than once, I have eventually got the SQL Server
Management Studio and fairly happily playing with it.  However I thought
I would create a stored procedure so wrote a very simple one, and
clicked save and it asked me to save it as SQLQuery1 which I thought
strange as I thought the name would be genesis_select_UserLogon (as
below)....But saved it none the less, but I can't seem to find it
anywhere in the database I created, but I wrote a quick VB app to use it
and it works ok....Can anyone tell me where I find the stored procedure
that I create in the database ? 

CREATE PROCEDURE [genesis_select_UserLogon]  (
  @strUser  [nvarchar](100),
  @strPass  [nvarchar](100)
SELECT Username, Password
FROM  tblUsers
WHERE Username = @strUser AND  Password = @strPass


Thanks in advance for any help on this...

Paul Hartland
dba-VB mailing list
dba-VB at databaseadvisors.com

More information about the dba-VB mailing list