Exception to tables in the master database

BrentOzarULTD / SQL-Server-First-Responder-Kit

sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.

http://FirstResponderKit.org

Other

3.37k stars 997 forks source link

Exception to tables in the master database #2426

Closed parlevjo2 closed 4 years ago

parlevjo2 commented 4 years ago

I would like to add an exception to tables in the master database. That is table '$ndo$srvproperty'. The $ndo$srvproperty is used to store your NAV (Navision) license file. You will not find it in master if you have selected "Per Database License" in the NAV "Per Database License" configuration.

AND name NOT IN ('CommandLog','$ndo$srvproperty','SqlServerVersions');

Rgds Johan Parlevliet

BrentOzar commented 4 years ago

Sure, sounds good! Go for it - that pull request would be welcomed. Makes sense.