How to delete a small letter alphabet in code field in NAV?

chandrurec

Dear all,

Some external vendor has inserted a small letter character named "admin" in user id which is a code field in user system table . As a result of which I cannot able to open the user table form or cannot able to retrieve the record using report . and I cannot delete this record also.

When I try to open sql I cannot find the user table since its a system table.

Is there any alternative to delete the admin record from user system table?

I am getting a error as follows

"The User table contains a value in a Code field that cannot be used with Microsoft Dynamics NAV:

Field : User ID
Value : admin

Thanks in advance.

sekar.

Kishorm

The user table should be available in SQL - but note that it won't have the company prefix. Try the following in SSMS...

SELECT * FROM dbo.[User]