| 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
|