Error: The following error may come while
deleting company or table
---------------------------
Microsoft Dynamics NAV Classic
---------------------------
The following SQL Server error or errors occurred:
208,"42S02",[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name '$ndo$usrproperty'.
16945,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared.
SQL:
SELECT [sid] FROM [$ndo$usrproperty]---------------------------
OK
---------------------------
Problem Statement: $ndo$usrproperty table is not
available in database.
Solution: Open SQL Server Management Studio
Run below
query
CREATE TABLE
[dbo].[$ndo$usrproperty](
[sid] [varbinary](85) NOT NULL,
[artoken] [varchar](128) NOT NULL,
PRIMARY KEY CLUSTERED
(
[sid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
No comments:
Post a Comment