| Author |
SQL Server Stored Procedure Create
|
|
|
| Is there a way to connect to a SS database and load a new stored procedure?
TIA
LH
| |
| man-wai chang 2005-07-07, 3:30 am |
| lh wrote:
> Is there a way to connect to a SS database and load a new stored procedure?
what did you mean by "load a new stored procedure"? You meant creating
temporary SP in sql server?
| |
|
| I don't mean temporary.
I mean execute the CREATE PROCEDURE... statement.
"man-wai chang" <toylet.toylet@gmail.com> wrote in message
news:eHSdOnpgFHA.1868@TK2MSFTNGP10.phx.gbl...
> lh wrote:
>
> what did you mean by "load a new stored procedure"? You meant creating
> temporary SP in sql server?
| |
| man-wai chang 2005-07-07, 3:30 am |
| > I don't mean temporary.
> I mean execute the CREATE PROCEDURE... statement.
You can do that, unless your DBA revoked your right to do so.
| |
|
| yes, I think there is something wrong with my attempt to connect with
adodb.connection then execute a statement. I have just done a create
procedure with SQLSTRINGCONNECT / SQLEXEC.
thanks for your help
"man-wai chang" <toylet.toylet@gmail.com> wrote in message
news:O$QFmEqgFHA.3936@TK2MSFTNGP10.phx.gbl...
>
> You can do that, unless your DBA revoked your right to do so.
|
|
|
|