[$ndo$usrproperty] missing?

sc00by

Hi can somebody help me please?

I've just tried to setup a test v4sp3 database on a new server and when I try to delete one of the objects it fails with an error saying "inavalid object name '$ndo$usrproperty'"

This is from a SQL statement that I've traced - "SELECT [sid] FROM [$ndo$usrproperty]"

I can login to this database fine and have installed the xp_ndo.dll correctly but can't see this object on either this new system or our production system so I'm a bit confused as to what the problem is :? .

Thanks,

Rob.

sc00by

Update:

I've checked this on our development server and it has the same problem

This may be a clue to somebody :?: - the object is a table but it references a SQL View that accesses data on a linked SQL Server.

Still trying to figure it out - any pearls of wisdom or ideas would be greatly appreciated.

Rob.

kine

I do not see this table in NAV 5.1. I see it only in NAV 5.0. The table is defined as

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]

You can try to create it by this SQL query.

sc00by

Hey this worked =D>

Still a bit strange though as our database has never been near a 5.0 or 5.1 one and started life as a 3.1 Attain database :?

Oh well, it's definately fixed my problem.

Thanks very much.

Rob.

kriki

[Topic moved from 'NAV/Navision' forum to 'SQL General' forum]