how to deploy stored procedures onsite

[scott]

Hi,

I created an sql script for my stored procedures. How can i execute this
script on customers sites ?

At the moment i can use the query analyser but its not going to be available
at customer sites.

What are my options ?

Many thanks for any information.
Scott

 

[Guest]

You can give a VB Script file as below.

Dim cn
Dim cmd
Dim rs
Dim params
Dim param
set cn=createobject("ADODB.Connection")
set cmd=createobject("ADODB.Command")
set rs=createobject("ADODB.Recordset")
cn.Provider = "SQLOLEDB"
cn.Open "Data Source = <SQL Server Name>", "testlogin"
Set cmd.ActiveConnection = cn
cmd.CommandType = &H0004
cmd.CommandText = "mainproc"
cmd.CommandTimeout = 0
' Prepare the command
cmd.Prepared = True
Set rs = cmd.Execute
Wscript.echo rs(0)
cn.Close
Set cmd = Nothing
Set cn = Nothing

 

[Eliyahu Goldin]

Scott,

You will need to have an access to the database server with enough rights
for creating stored procedures. You, or your customer, need to talk to IT
guys who are in charge of the database server and ask them to provide an
access for you. That's the down side of using stored procedures.

Eliyahu

 

[Bruce Barker]

the most common approach is a bat file and the osql utility.

-- bruce (sqlwork.com)