Microsoft.SQLServer.Smo EnumDatabasePermissionInfo

Dhanaraj D 1

Hi Everyone,

I am trying to compare the database servers using Microsoft.SQLServer.SMO. While checking the EnumDatabasePermission method I am getting the Argument out of range exception.

My SMO Version is 10 and My SQL Server version is 2019. Please refer the below screenshot for reference. Please help me to resolve this issue

Karen Payne MVP 35,036 Reputation points

2022-10-03T09:16:21.743+00:00

Please provide code that is throwing the exception and indicate which line is the problem.
Dhanaraj D 1 Reputation point

2022-10-03T09:24:58.1+00:00

CompareDatabasePermissions(DbComparisonType.Database, destDatabase.Name, DBOp.DbComparisonOperation.Deleted, destDatabase.EnumDatabasePermissions(), sourceDatabase.EnumDatabasePermissions())
CompareDatabasePermissions(DbComparisonType.Database, sourceDatabase.Name, DBOp.DbComparisonOperation.Added, sourceDatabase.EnumDatabasePermissions(), destDatabase.EnumDatabasePermissions())

Private Sub CompareDatabasePermissions(ByVal type As DBOp.DbComparisonType, _
ByVal objectName As String, _
ByVal op As DBOp.DbComparisonOperation, _
ByVal srcPermissions As DatabasePermissionInfo(), _
ByVal destPermissions As DatabasePermissionInfo())

End Sub
Karen Payne MVP 35,036 Reputation points

2022-10-03T14:51:13.357+00:00

Looks like VB, not C#. Next up, there is nothing helpful in your reply regarding what you are asking help for.

Next time you post code use