Update a Sproc from VB.net

  • Thread starter Thread starter Stan Sainte-Rose
  • Start date Start date
Change its declaration?
You will have to invoke sql stataments to do it.
 
In fact, sometimes, I have to update some Sproc and I use Sql Server
Enterprise Manager.
So, I would like to do it using my vb application.. but don't know how to do
it...
 
Use SqlCommand.
Set the CommandText to "ALTER bla bla " and ExecuteNonQuery().
 
Looking at the rest of this thread, it appears you are familiar with
Enterprise Manager, which is a good spot to alter your procs. You can
certainly alter them from code, using the DDL statement ALTER PROCEDURE,
followed by the entire header and body of the sproc.

If you are attempting to create a tool for this, I can see where you are
going. If you are altering sprocs based on application logic, that is not
wise. Sprocs should be solid when a product is released.

NOTE: Depending on the version of Visual Studio .NET used, you can alter
sprocs directly in the VS.NET IDE using the database tools.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Generate Tables and Sproc with vb.net 1
Severe Error selecting ntext using sproc vb.net 5
Linq: #Temp tables in SPROCS do not have return values in generatedmethods 5
SQL CLR Sproc isn't running right 3
Sproc performance over vpon 12
Cannot conceptulize how it should be done 5
I have two questions about the TableAdapter Configuration Wizard 5
Beginner question on using sprocs 3

Back
Top