SQL Server Performance Forum – Threads Archive

customizing sql server mgmt. studio

Hi all,
One of our hardening steps with sql2k was that only query analyzer was available for the developers to attach to our db’s. (we removed execute permissions on all master db’s stored procedures that made enterprisemanager unusable) In sql2005 all functionality is in sql management studio and a lot of the stored procedures (more then in sql2k) are copied into a new created user db. How are you guys handling this?
Is there a way to hide/customize sql management studio?? TIA
Dan

Check: http://msdn2.microsoft.com/en-us/library/ms174173.aspx HTH Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Security is verymuch locked down in 2005 compared with 2000… Hackers Beware
Keep Bad Guys at Bay with the Advanced Security Features in SQL Server 2005 http://msdn.microsoft.com/msdnmag/issues/05/06/sqlserversecurity/default.aspx
Mohammed U.

]]>