SQL Server 2005 Tidbit 014

DataStorage

Number 14

Credit for this one goes to my friend and teammate Matt Hester...

Q:  What if I do no want to give SQL 2005 Management Studio to my Developers how to I give them access to the databases?

A:  Matt was talking with some of his event attendees, and they recommend that you use SQL 2000 query analyzer for that type of access.  During their testing this worked fine with the 2000 QA specifically if you used SQL 2005 Express. 

My thought on this is that you should go ahead and USE THE MANAGEMENT STUDIO.  The issue isn’t one of what tool is installed, but of security.  If you’ve set things up right, you won’t be giving your developers anything they shouldn’t have… and you WILL be giving them a tool they can use powerfully. 

Got an IT question?  Give me a comment, or contact me.