parameterized sql scripts - Microsoft SQL / MS SQL Server

[Pierre]

During the installation of our project we want that the end-users to be able
to rename the database. We generated the sql scripts for the default
database schema. But for renaming the database object we want to use
parameter values instead of the hardcoded database name in the scripts. Is
it somehow possible using isql or bcp?

Or is there any other solutions that you might suggest except using sql
scripts?

Thanks for replies...

Can

[Mohanjit]

Move your sql scripts to a stored procedure and pass database name as input
parameter.

"Pierre" <pp.com> wrote in message
news:phx.gbl... 
able 

[Nurten]

Thanks..I tested it..But itsnt save the stored procedure..have an error.
following

"incorrect syntax near the keyword 'CREATE' a use database statement is not
allowed in a procedure or trigger"

Why?

Nurten


"Mohanjit" <uc.edu>, iletide şunu yazdı
news:ep%phx.gbl... 
input 
> able [/ref]
Is 
>
>[/ref]

[Mohanjit]

can u post the body of the stored procedure which u are trying to create?
"Nurten" <com.tr> wrote in message
news:%phx.gbl... 
not 
> input [/ref][/ref]
be [/ref][/ref]
scripts. [/ref][/ref]
sql 
> >
> >[/ref]
>
>[/ref]

[Nurten]

creating a database from the "generated sql script"..
Nurten

"Mohanjit" <com>, iletide şunu yazdı
news:%phx.gbl... [/ref]
error. 
> not 
> > input [/ref]
> be [/ref]
> scripts. [/ref]
> sql 
> >
> >[/ref]
>
>[/ref]