• Michael Intravartolo

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]

#microsoftdynamicsnav

28 views
Contact Us

Solution Systems, Inc.

3201 Tollview Dr. 

Rolling Meadows, IL 60008

Office: 847-590-3000

Email: info@solsyst.com

Support: 224-345-2020

Support Email: support@solsyst.com

Connect With Us
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Chicago
  • Manufacturing Software | Illinois
  • Microsoft Business Podcast
  • Manufacturing Software | Chicago
  • Manufacturing Software | Chicago
  • Manufacturing Software | Chicago
Join our Mailing List

© 2020 Solution Systems, Inc.