microsoft/sqlmanagementobjects

View on GitHub

Sql Management Objects, an API for scripting and managing SQL Server and Azure SQL Database

Stars: 143
Forks: 28
Open beginner issues: 0
Indexed issues: 79

Dominant language: C#
License: No license data
Last GitHub push: Aug 18, 2026
Latest indexed: Sep 19, 2026
Contributing guide: No contributing guide
Code of conduct: Code of conduct
Beginner labels: No beginner labels indexed
PR merge metrics: No merged PRs in 30d

Beginner friendly Everything

Open All

79 open issues indexed

Login.ChangePassword() leaves MustChangePassword and IsLocked stale - the property bag is never updated or invalidated Open

Difficulty 3/5 1-2 days Newbie friendliness 72/100

microsoft/sqlmanagementobjects#234 · Opened Aug 28, 2026
Index.Rebuild() silently ignores DataCompression = None - the ALTER INDEX ... REBUILD is generated without DATA_COMPRESSION and the index stays compressed Open

Difficulty 4/5 3-5 days Newbie friendliness 74/100

microsoft/sqlmanagementobjects#233 · Opened Aug 28, 2026
Scripting a Distributed Availability Group throws ArgumentException: Unexpected value for enumeration type AvailabilityGroupAutomatedBackupPreference Open

Difficulty 3/5 1-2 days Newbie friendliness 78/100

microsoft/sqlmanagementobjects#232 · Opened Aug 28, 2026
SmoMetadataProvider throws bare NullReferenceException when the current database cannot be resolved (Azure/Fabric endpoint) Open

Difficulty 3/5 1-2 days Newbie friendliness 68/100

microsoft/sqlmanagementobjects#227 · Opened Aug 7, 2026
Connection to SQL Endpoint on Lakehouse using SMO Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

microsoft/sqlmanagementobjects#221 · Opened Mar 24, 2026
Severe performance degradation in SQL Server 2022 when SMO enumerates databases with ActiveConnections due to sys.sysprocesses query Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

microsoft/sqlmanagementobjects#210 · 1 reaction · Opened Nov 2, 2025
`ClearAndInitialize()` fails when called on the Databases property of a Dynamics CRM server Open

bug

microsoft/sqlmanagementobjects#207 · 1 comment · 1 reaction · 1 assignee · Opened Oct 9, 2025
[Bug]: Script as Create does not provide valid script Open

bug

Difficulty 3/5 1-2 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#214 · 4 comments · Opened Oct 3, 2025
Change SMO performance tracking from a compile time setting to a runtime setting Open

Difficulty 5/5 Over a week Newbie friendliness 38/100

microsoft/sqlmanagementobjects#206 · Opened Sep 21, 2025
[Feature] Copy objects from live Server to offline (design mode) Server Open

Difficulty 5/5 Over a week Newbie friendliness 30/100

microsoft/sqlmanagementobjects#205 · 1 comment · Opened Sep 11, 2025
Intermittent errors with SMO expanding databases when they're in an AG Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#201 · 3 reactions · Opened Aug 20, 2025
SMO Scripting - Missing regular property NotForReplication property bag state Lazy for type Trigger Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#198 · 1 comment · Opened May 29, 2025
Block comments immediately before a batch separator prevent the separator being detected Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#196 · 1 comment · Opened May 11, 2025
Nuget packages after 172.52.0 do not support netstandard2.0 Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#195 · 1 comment · Opened May 11, 2025
Script as ALTER and Create Opening Blank Window with Synapse database Open

bug

Difficulty 3/5 1-2 days Newbie friendliness 38/100

microsoft/sqlmanagementobjects#211 · 9 comments · 1 reaction · Opened May 7, 2025
Dependency System.Formats.Asn1 flagged as vulnerable Open

Difficulty 2/5 1-3 hours Newbie friendliness 30/100

microsoft/sqlmanagementobjects#192 · Opened Mar 26, 2025
SMO 172.52.0, skips generation of "hidden" tables. Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

microsoft/sqlmanagementobjects#190 · 1 comment · Opened Feb 6, 2025
ConnectionFailureException when user running the command does not match the ConnectAsUserName Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#186 · 3 comments · Opened Jan 13, 2025
[Feature] Support Multiple `JobHistoryFilter.OutcomeTypes` Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#185 · Opened Jan 13, 2025
Some Dependencies are flagged as vulnerable Open

Difficulty 4/5 3-5 days Newbie friendliness 30/100

microsoft/sqlmanagementobjects#179 · 2 comments · Opened Nov 18, 2024
Extended properties not supported on Azure Sql? Is there a plan to support? Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

microsoft/sqlmanagementobjects#178 · 4 comments · Opened Oct 31, 2024
SMO issue with default column values. Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

microsoft/sqlmanagementobjects#175 · 3 comments · Opened Oct 17, 2024
SMO is incorrectly defaulting the schema-identifier, when it shouldn't be (e.g. on CREATE PROCEDURE). Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#174 · 3 comments · Opened Oct 14, 2024
[Feature] Add `CreateOrAlter` to `Transfer.TransferData` Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

microsoft/sqlmanagementobjects#173 · Opened Oct 5, 2024
ResourcePoolAffinityInfo is null Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#169 · 16 comments · Opened Aug 16, 2024
Failed to load assembly Microsoft.SqlServer.Management.IntegrationServicesEnum.dll Open

Difficulty 3/5 1-2 days Newbie friendliness 25/100

microsoft/sqlmanagementobjects#168 · 3 comments · Opened Jul 19, 2024
SqlClient error when getting IsSqlDw property from a Fabric DW Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#167 · Opened May 31, 2024
`ADD` and `DROP SIGNATURE` Support Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#166 · Opened May 28, 2024
"Model" database size is read by transfer when not creating a database. Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

microsoft/sqlmanagementobjects#164 · Opened May 17, 2024
net8.0 + Microsoft.Data.SqlClient <5.2.0 incompatibility Open

Difficulty 2/5 1-3 hours Newbie friendliness 45/100

microsoft/sqlmanagementobjects#163 · 1 comment · Opened May 1, 2024
NullReferenceException with Microsoft.Data.SqlClient 5.2.0 and with event handler for Backup.PercentComplete Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#162 · 2 comments · Opened Apr 22, 2024
Can TaskCompletionSource be used with Backup class? Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#161 · Opened Apr 3, 2024
Error While Transfering System Versioned Temporal Tables Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

microsoft/sqlmanagementobjects#160 · 5 comments · Opened Mar 28, 2024
Move from newtonsoft to System.Text.Json Open

Difficulty 5/5 Over a week Newbie friendliness 20/100

microsoft/sqlmanagementobjects#156 · 3 comments · Opened Mar 8, 2024
Missing newer configurations from ServerConfigurationFacet Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#153 · 2 comments · Opened Jan 4, 2024
Obtaining Table SMO object causes table scan to be recorded Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

microsoft/sqlmanagementobjects#151 · 5 comments · 1 reaction · Opened Nov 6, 2023
Microsoft.Data.SqlClient is not supported on this platform Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

microsoft/sqlmanagementobjects#149 · 11 comments · Opened Oct 10, 2023
DependencyWalker.DiscoverDependencies fails with System.ArgumentException: Item has already been added. Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#148 · 1 comment · 1 reaction · Opened Oct 6, 2023
The space available property is not computed correctly Open

Difficulty 2/5 1-3 hours Newbie friendliness 62/100

microsoft/sqlmanagementobjects#147 · Opened Oct 6, 2023
SMO, CREATE DATABASE: doesn't always replicate file/filegroups accurately. Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#144 · 1 comment · Opened Jul 27, 2023
Replace SmoSortedList usage of SortedList with SortedList<ObjectKeyBase, T> Open

Difficulty 3/5 1-2 days Newbie friendliness 42/100

microsoft/sqlmanagementobjects#140 · Opened May 12, 2023
Replace type-aware factory methods in ObjectKeyBase with collection instance methods Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

microsoft/sqlmanagementobjects#139 · Opened May 12, 2023
Replace the custom URN name-to-type mapping in SqlSmoObject.GetChildType with SfcElement attributes Open

AoT

Difficulty 4/5 3-5 days Newbie friendliness 38/100

microsoft/sqlmanagementobjects#135 · Opened Apr 7, 2023
Move reflection and dynamic code invocation out of SqlSmoObject Open

AoT

Difficulty 4/5 3-5 days Newbie friendliness 38/100

microsoft/sqlmanagementobjects#134 · Opened Apr 7, 2023
ScriptForCreateOrAlter still not working Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#126 · 7 comments · 1 reaction · Opened Feb 6, 2023
Backup Path in SMO? Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

microsoft/sqlmanagementobjects#121 · 1 comment · Opened Dec 27, 2022
Using .Databases with a misspelled database name changes database name in SMO Open

Difficulty 3/5 1-2 days Newbie friendliness 55/100

microsoft/sqlmanagementobjects#115 · 6 comments · Opened Oct 21, 2022
Trying to create User of External UserType against a SqlManagedInstance results in error Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

microsoft/sqlmanagementobjects#112 · 4 comments · Opened Sep 27, 2022
Could not load file or assembly Microsoft.Identity.Client, Version=4.22.0.0 Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

microsoft/sqlmanagementobjects#110 · 1 comment · Opened Sep 16, 2022
LogReuseWaitStatus enum is incomplete Open

Difficulty 2/5 1-3 hours Newbie friendliness 35/100

microsoft/sqlmanagementobjects#105 · 10 comments · Opened Jul 26, 2022

microsoft/sqlmanagementobjects

Get new issues in your inbox