help how to exclude master, msdb while EXEC master..sp_MSForeachdb 'USE [?]

Question

help how to exclude master, msdb while EXEC master..sp_MSForeachdb 'USE [?]

Viewing post 16 (of 16 total)

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

JediSQL SSCrazy Points: 2121 More actions · Answer 1

While it is maybe not technically a system database, things skipping system databases should probably also exclude [distribution]. In recent versions of SSMS (SQL Server Management Studio), Object Explorer groups [distribution] under the "System Databases" node.

Sincerely,
Daniel

help how to exclude master, msdb while EXEC master..sp_MSForeachdb 'USE [?]

Cookies on SQLServerCentral