<div>
Hi, <br />
<br />
A little bit late !! you have closed the question :) <br />
<br />
Anyway, &nbsp;You could use logon triggers to restrict access from sql server management studio.<br />
<br />
Please see the link - <a href="http://www.sqlservercentral.com/blogs/erichumphrey/2011/06/18/prevent-sql-logins-from-using-ssms-_2620_-or-any-other-app/" rel="ugc">http://www.sqlservercentral.com/blogs/erichumphrey/2011/06/18/prevent-sql-logins-from-using-ssms-_2620_-or-any-other-app/</a><br />
<br />
Thanks, <br />
Anoo
</div>


Hi,

A little bit late !! you have closed the question :)

Anyway,  You could use logon triggers to restrict access from sql server management studio.

Please see the link - http://www.sqlservercentral.com/blogs/erichumphrey/2011/06/18/prevent-sql-logins-from-using-ssms-_2620_-or-any-other-app/ [http://www.sqlservercentral.com/blogs/erichumphrey/2011/06/18/prevent-sql-logins-from-using-ssms-_2620_-or-any-other-app/]

Thanks,
Anoo

<div>
<div class="content wysiwyg-content">
I have a very typical problem. The end user has the power to restore and backup the database.<br />
The application source code in not available. The user enters the data from application.<br />
But since he is aware of sql server he changes the data.<br />
So for this i want to stop or disable or corrupt sql server management studio so that user is not able to edit the data from backend.,<br />
<br />
Is there any good solution for this.
</div>
</div>


I have a very typical problem. The end user has the power to restore and backup the database.
The application source code in not available. The user enters the data from application.
But since he is aware of sql server he changes the data.
So for this i want to stop or disable or corrupt sql server management studio so that user is not able to edit the data from backend.,

Is there any good solution for this.

How to delete or stop sql server management studio.

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.