Alert raised when mirroring databases:
Collection 'Mirroring' failed : Cannot insert the value NULL into column 'unsent_log', table 'tempdb.dbo.#QS_Monitor_Results_________________________________________________________________________________________________00000001D71D'; column does not allow nulls. INSERT fails.
Product defect.
Copy the attached QS_Mirroring.sql file into the following folders on the Diagnostic Server, replacing the existing files:
<Diagnostic Server>\Agent\conf\Package\sqlserver_spotlight\2005
<Diagnostic Server>\Agent\conf\Package\sqlserver_spotlight\2008
It is not necessary to restart the Diagnostic Server service after applying this change.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center