`Set-SqlDscDatabaseDefaultFullTextCatalog`: New command proposal

Description

Add a new public command Set-SqlDscDatabaseDefaultFullTextCatalog to configure the default full-text catalog for a SQL Server database using the SMO SetDefaultFullTextCatalog() method.

Details

The DefaultFullTextCatalog property on the SMO Database class requires calling the SetDefaultFullTextCatalog() method rather than direct property assignment. This command should be implemented as a separate cmdlet following the pattern established by other method-based commands.

Proposed Implementation

• Command Name: Set-SqlDscDatabaseDefaultFullTextCatalog
• Parameter Sets:
  • ServerObject + Name (with optional Refresh)
  • DatabaseObject (accepting pipeline input)
• Required Parameters:
  • CatalogName: The name of the full-text catalog to set as default
• Optional Parameters:
  • Force: Bypass confirmation prompts
  • PassThru: Return the updated database object
• Behavior:
  • Support ShouldProcess for -WhatIf and -Confirm
  • Call $databaseObject.SetDefaultFullTextCatalog($CatalogName) on the SMO Database object
  • Include proper parameter validation and error handling
  • Follow DSC Community PowerShell coding guidelines

Related Issues and PRs

• Related to issue #2177 (Expose settable SMO Database properties)
• Discovered in PR #2327 (Set-SqlDscDatabase refactoring)
• Comment: https://github.com/dsccommunity/SqlServerDsc/pull/2327#discussion_r2468121050

References

• SMO Documentation: Database.SetDefaultFullTextCatalog Method