Click here to Skip to main content
14,665,550 members
Rate this:
Please Sign up or sign in to vote.
See more:
I have one table in SQL Server Database due to some reasons i don't want user to edit rows of table in edit mode

Is that possible to do?

What I have tried:

I have tried with Tools > options > SQL Server Object Explorer > Edit Top <n> rows Command to set with 1, But in this way it will have allow to edit that one record and even allow to add new records i edit mode.

That's not preferable way. Is there any other preferable way?
Updated 31-Jul-17 2:49am
Kornfeld Eliyahu Peter 31-Jul-17 8:35am
How exactly your users are getting into SQL Management Studio?
Tbs.User 31-Jul-17 8:39am
Over here user means my trainees and other employees. And I Gauss that not the concern is right? If you don't know the answer why you are wasting our times by this type of comments.

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Got my answer from MSDN forum. 
If anybody need for it 
<a href="">Can we disable table's row editing in edit mode?</a>[<a href="" target="_blank" title="New Window">^</a>]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100