Find out ENABLED GUEST user in all registered SQL Servers with HTML output via PowerShell
Tasks:
  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.
sysusers
sys.database_principals
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

2018-10-04

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)