[AccessD] SQL Server 2005 Stored Procedures (Confused !!!!!)

Maybe if it saved as a query  then it saved it wherever queries get saved in SQL
(is it views?) and not where the PROCS get saved


Many thanks
 
Have a great day
 
Darren
------------------
T: 0424 696 433

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-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: [AccessD] 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)
         )
AS
SELECT Username, Password
FROM  tblUsers
WHERE Username = @strUser AND  Password = @strPass

GO

Thanks in advance for any help on this...

Paul Hartland 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com