>From SQL Server 2005 SSMS query analyzer we would like to change the

<mplpost@yahoo.com> wrote in message
news:1179210467.491828.115410@e51g2000hsg.googlegroups.com...
> >From SQL Server 2005 SSMS query analyzer we would like to change the
> database context(USE [@dbname](tried dynamic sql, both exec() and
> sp_executesql, but this doesnt work) .
> We would like to run the alter scripts(service pack) for tables and
> stored procedures in some specific databases. Our requirement is that
> from our web application when each organization is created a separate
> database is created for it. The database names of these organizations
> are maintained in our main DB. When we supply the service pack
> script(this is applied using query analyzer) for any further database
> changes, these scripts are to be run in the corresponding organization
> DBs too. If we could dynamically switch contexts, from the query
> analyzer while applying the service pack script in the main database,
> we could have avoided creating a separate tool to update all the
> databases. We could run manually in all the databases
> , but the issue is that the client applies this service pack and it
> would be cumbersome for them to check all the database names and
> update it.
>
> If anybody has any workaround for this, would appreciate your
> suggestions.
>
> Thanks,
> MPL
>

> From SQL Server 2005 SSMS query analyzer we would like to change the
> database context(USE [@dbname](tried dynamic sql, both exec() and
> sp_executesql, but this doesnt work) .
> We would like to run the alter scripts(service pack) for tables and
> stored procedures in some specific databases. Our requirement is that
> from our web application when each organization is created a separate
> database is created for it. The database names of these organizations
> are maintained in our main DB. When we supply the service pack
> script(this is applied using query analyzer) for any further database
> changes, these scripts are to be run in the corresponding organization
> DBs too. If we could dynamically switch contexts, from the query
> analyzer while applying the service pack script in the main database,
> we could have avoided creating a separate tool to update all the
> databases.

> I think it is a much better idea to run this from an application, since
> you have more control over other things. I don't think it is a good
> idea to run things like this from a query window.

> If you are on SQL 2005, you may want to investigate what variable
> substituion in SQLCMD can do for you.

> Thanks for the reply.
>> I think it is a much better idea to run this from an application, since
>> you have more control over other things. I don't think it is a good
>> idea to run things like this from a query window.
>
> But it would have been a save of time if we could have dynamically
> changed from the query analyzer.

> If only the dynamic 'USE '+@dbname would have changed the context of the
> query analyzer. Hope this would be a microsoft wishlist.