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.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com