web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Mohana's Dynamics Business Central / Nav blog / Invalid object name '$n...

Invalid object name '$ndo$usrproperty'

Views (4532)
Mohana Yadav Profile Picture Mohana Yadav 61,017 Super User 2025 Season 2
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]

This was originally posted here.

Comments

*This post is locked for comments