Envision: Why are we writing to the master database when collecting Microsoft SQL database logs
2 years ago
Originally Published: 2008-06-17
Article Number
000040189
Applies To
enVision Core 3.7.0, 4.x

Windows
Issue
Envision: Why are we writing to the master database. sql trace files
You observed that the collection process involves writing to the master database in the Microsoft SQL database. You wish to know why is that so

Resolution

Some of the reasons are:

1. master database is guaranteed to exist, not going to ask customer to create a separate database

2. one of the stored procedures requires sp_procoption and must be part of the master database to use it