Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Creating stored procedure through vb.net

Hi there,

The have a store procedure written. Now I generate the script from SQL Enterprise Manager. My client does not want to use SQL Query Analyzer to first run this script that will create this stored procedure in SQL Server. He want to load this script in text box control and then on click of button, create this SP through VB.NET. I know this can be done using SQLDMO but do not know how! Can anyone help?

Regards,
Vilas
[449 byte] By [vbtest5] at [2007-11-11 8:02:42]
# 1 Re: Creating stored procedure through vb.net
http://www.google.com/search?q=sqldmo+create+procedure
Phil Weber at 2007-11-11 21:48:12 >
# 2 Re: Creating stored procedure through vb.net
Have you ever heared of SQL Injection, Use that hacking technique to create SP's directly to update database
aaaaa at 2007-11-11 21:49:12 >
# 3 Re: Creating stored procedure through vb.net
Try this link, it's useful: http://www.codeproject.com/cs/database/DBInstaller.asp
THByte at 2007-11-11 21:50:11 >