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

[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

"scott" <no****@yahoo.com> wrote in message
news:OV**************@TK2MSFTNGP09.phx.gbl...

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

[Vijayakrishna]

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

--
Vijayakrishna
Software Architect
"scott" wrote:

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

[Bruce Barker]

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

-- bruce (sqlwork.com)

"scott" <no****@yahoo.com> wrote in message
news:OV**************@TK2MSFTNGP09.phx.gbl...

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