Monday 8 June 2015

Invalid object name '$ndo$usrproperty'

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]