Or, you could use Query Analyzer. I personally use CodeSmith (
http://www.ericjsmith.net/codesmith/) to generate all my CRUD stored procs. It's much less work than creating these SP's manually...
>You can create them by code if you know the syntax. Otherwise you need to use SQL Enterprise manager.
>
>
>>Ok, so how do I create the stored procedures? DO I have to
>>go into SQL Server and do it?
>>
>>Thanks
>>
>>
>>>Surely because you only have the Pro edition of Visual Studio. You need the Enterprise.
>>>
>>>
>>>>Ok, I right clicked on the Database in the Server Explorer, and
>>>>then again on Stored Procs. The only 2 options provided are
>>>>Properties and Refresh.
>>>>
>>>>
>>>>>>How do I create a stored procedure in SQL from within Vb.Net?
>>>>>>
>>>>>>Thanks
>>>>>
>>>>>Go thru the Server Explorer, drop down the DB you are interested in. Right click on "Stored Prcedures" and it will give you an option to create a new one.
Al Williams
Anola MB, CANADA