Hi
Select is not supported through the CREATE PROCEDURE wizard. Try using Query
Analyser and the CREATE PROCEDURE statement described in books online.
http://msdn.microsoft.com/library/de...reate_4hk5.asp
If you require select statements for a given table you can right click the
table in object browser and script the select statement to a new window.
John
"compraj" <ra***********@hotmail.com> wrote in message
news:b3**************************@posting.google.c om...
I was using the SQL 2000 stored procedure wizard to create stored
procedures. I can create insert, delete and update SPs however I am
not able to create the select SP. The wizard does not offer the option
of selecting "select" type SP. thank you for your replys
compraj