SqlDatabase: Returns the SQL Server collation from Get-TargetResource if the database does not exist

[johlju]

Details of the scenario you tried and the problem that is occurring

The Get-TargetResource returns the collection of the SQL Server if the database does not exist.

https://github.com/PowerShell/SqlServerDsc/blob/1fd9a8acef4ac224abe3e312c95b49f1dfc7adca/DSCResources/MSFT_SqlDatabase/MSFT_SqlDatabase.psm1#L69

Verbose logs showing the problem

n/a

Suggested solution to the issue

If the database is not found then it should return $null as the database collation.

The DSC configuration that is used to reproduce the issue (as detailed as possible)

n/a

SQL Server edition and version the target node is running

All

SQL Server PowerShell modules present on the target node

n/a

The operating system the target node is running

All Windows OS's

Version and build of PowerShell the target node is running

n/a

Version of the DSC module that was used ('dev' if using current dev branch)

dev

[johlju]

Duplicate of issue #1395, keeping #1395 to track this.