Introduction
Management
Technology
ISO9001
About us
Copyright
colourful technology...
Dyetech
March 1st 2006

SQL Management Studio

Having moved up to SQL2005 (as mentioned last week) we have one annoyance - the management studio. It's written in .NET - and unfortunately (in our view) isn't a good advert. We get crashes (not fatal, just annoying) every so often and it can be very slow. It also seems to struggle to run at the same time as VS2005, especially when debugging in VS2005. OK so are we asking to much?

The "missing feature" - or rather the one thing that we've really missed so far is the grid view of security attributes for a role - we were used to this in SQL2000 management tools and happily ensured all tables had the relevant security settings for our group of users. This is missing in the SQL2005 version so has to be done table at a time.

Update to above - though we still can't find this feature a simple SQL command string can sort it out (just have to remember to run it!):

-- grant rights to our_group
-- stored procedures, functions etc.
grant execute to our_group
-- tables
grant select to our_group
grant insert to our_group
grant update to our_group
grant delete to our_group

 

Comments? - Contact us here


Home
IT and Management consultancy
Copyright Dyetech 2005-7
All rights reserved