Open SSMS> New Query> Copy paste and run the query
update USERINFO SET ENABLE=0
where NAME in ('Uma Shankar')
You can disable multiple users by passing comma separated user names in the where condition.
Thanks,
Uma
Subscribe to:
Post Comments (Atom)
Get Enum Id and Enum Value in D365FO using SQL and X++
Below is the sql get enum id and enum value of a enum in D365 F&O using sql. SELECT enumidtable . NAME 'Enum Name' ...
No comments:
Post a Comment