Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Other SQL Server Topics (2005)  SSMS alternatives specific to data retrievers

Author  Topic  MarkWB Starting Member 8 Posts Posted - 2008-09-18 : 11:07:59 I am working on a project in which a couple of hundred users are to be migrated from using Access with linked SQL Server tables to using SSMS. These users retrieve data only - no administration. The only schema changes they will be making are to views, sps and udfs and, obviously, security is configured so that's all they can do. So to make it easier for them, can anyone recommend tools other than SSMS that are more specialized to just managing and running queries? In other words, I am wondering if there are any options to focus the UI better and eliminate all of the other admin features that they will not need. These are engineers and manufacturing pros that need ad hoc access to data and they are competent enough to handle basic t-sql, although they do prefer the graphical query design tools. Thanks, Mark