Find out ENABLED GUEST user in all registered SQL Servers with HTML output via PowerShell
  1. Get all registered SQL servers from list
  2. Prepare T-SQL Script
  3. Prepare HTML/CSS style
  4. Put them together in Powershell
Typically, finding a user inside SQL server is pretty much a easy thing to do. You can either use the tranditional system table or the new system table.
But the STATUS of the user, enabled or diabled that you can only get from the table: sys.sysusers
Let’s jump to the code directly.

Error message:
Could not load file or assembly ‘Microsoft.SqlServer.Management.IntegrationServicesEnum, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG)) (mscorlib)

CDC Table Diagram for ODS - Part 1

No comments


Finally, I am able to release this from my works. This diagram (part 1 ) was not produced by any ER tool but just via old school way - PowerPoint. 😀😀😀

PDF link here (Diagram PDF download)