We are looking into migrating our Sybase servers to SQL2000. We have a SQL2000 server with a CPU license. We have user communities that use Sybase client tools to access various databases on our Sybase server. The client provides odbc drivers and tools similar to "SQL Server Enterprise Manager".
1.) Does anyone know if it's legal to install "SQL Server Enterprise Manager" on any machine or is it licensed product? (This is what we did with Sybase)
2.) Is there a better way to provide select and update access to the user community without building interfaces or supplying a client to each user?
So long as the server(s) you are connecting to is licensed, the tools my be installed anywhere. I checked this with MS some time ago, but you may want to do it yourself to be safe. You may wish, however, to only distribute Query Analyzer or a custom interface just to avoid distracting your users with so many features that are unecessary for them.
"hmmmm... I wonder what happens when I right-click and select delete"
Of course, with proper object-level and role-based security in place, this isn't an issue...