Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-03 : 08:13:04
|
| mehul writes "hi,I know about sqldmo object and using it in my vb 6.0 code.but, i am confused about "how to alter stored procedure using dmo object in vb 6.0"thanks for your interest.regards,mehul patel" |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-09-03 : 09:33:53
|
| Dim s As New SQLDMO.SQLServer, d As SQLDMO.Database, sp As StoredProcedures.Connect "(local)", "sa", ""Set d = s.Databases("myDB")Set sp = d.StoredProcedures("myProc")sp.Alter "alter procedure myProc as print 'oops!!!' return"s.Close |
 |
|
|
|
|
|
how to alter stored procedure using dmo object in vb 6.0?