USE DB - not working while exec dynamically

Question

USE DB - not working while exec dynamically

haichells

SSCrazy

Points: 2713
More actions
December 11, 2009 at 8:43 am

#136847

Hi,
I am trying to execute some script in a list of dbs. i wrote a generic script to change the db which is not working. Please find below the code.
Declare @sqlcmd varchar(max)
Select @sqlcmd = 'use testdb'
Exec (@sqlcmd)
The above script is not changing the db as desired. Please help. Thanks in advance.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 1

haichells (12/11/2009)
Hi,
I am trying to execute some script in a list of dbs. i wrote a generic script to change the db which is not working. Please find below the code.
Declare @sqlcmd varchar(max)
Select @sqlcmd = 'use testdb'
Exec (@sqlcmd)
The above script is not changing the db as desired. Please help. Thanks in advance.

Please read the jeff moden article added in my signature.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

RyanRandall SSChampion Points: 13623 More actions · Answer 2

Similar question (and answer) here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=130994

Recommended article here: http://www.sommarskog.se/dynamic_sql.html

Ryan Randall

Solutions are easy. Understanding the problem, now, that's the hard part.

haichells SSCrazy Points: 2713 More actions · Answer 3

Thanks RyanRandall ! It helps !

Muthukkumaran, Thanks for you too 🙂 Will try forum etiquette