How to execute script oin all databases of an instance.

Question

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

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

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 1

Powershell is an option.

or

exec sp_msforeachdb 'USE ?; SELECT ?;'

Personally, I'd consider writing a generic powershell script which took a .sql file as parameter.

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 2

I do not want to use sp_msforechdb because its a long script.

Also it may be necessary to execute that in a few speceific databaseas in future.

I tried using cursor by saving the required databases in a temptable browsing through each tables.

Pbm is it's actualy not changing the database. 'use '+@dbname doesn't work.

Thanks.

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 3

Well, if Powershell doesn't work for you, you could consider SQLCMD (either like this or like this), or SSIS.

John