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
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...
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
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
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]
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]
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]
Bookmarks