August 10, 2011 at 7:22 am
@Remi
darn them for closing it. worth another comment asking for it to be looked at again?
---------------------------------------------------------------------
August 10, 2011 at 7:33 am
george sibbald (8/10/2011)
@Remidarn them for closing it. worth another comment asking for it to be looked at again?
Not on my first read. I'd want to protect SA as much as possible. It's not much trouble to createa "jobs" user and create everything with that and then give them that account to play with.
August 10, 2011 at 7:33 am
george sibbald (8/10/2011)
Koen Verbeeck (8/10/2011)
Ninja's_RGR'us (8/10/2011)
Brandie Tarvin (8/10/2011)
Help me bug Microsoft about a minor issue that is driving me sane.This one is giving me heartburn. I almost ran something in Production that was supposed to be run on Dev yesterday because I didn't catch what instance the query opened up against.
I casted my vote (had another thread just like yours yesterday).
In the meantime you can install this. This allows you to change the background color based on the env. you are in.
I believe you can already change the color of the connection at the bottom of the query window with out-of-the-box SSMS.
Anyway, +1 for connect item.
you can
http://sqlfool.com/2009/03/ssms-server-settings/
perhaps you would care to vote for this connect item?
https://connect.microsoft.com/SQLServer/feedback/details/156852/sql2005-sqlagent-msdb-security-roles
One thing that I've noticed... if you use registered servers, then you have to set the colour in both the registered servers properties, as well as the Connect to Server dialog as described in the link above. I think that if you have it set up in Registered Servers, then all of those settings should be the default for when you use the Connect to Server dialog for that server, with the ability to change the default in that dialog.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 10, 2011 at 7:46 am
george sibbald (8/10/2011)
Koen Verbeeck (8/10/2011)
Ninja's_RGR'us (8/10/2011)
Brandie Tarvin (8/10/2011)
Help me bug Microsoft about a minor issue that is driving me sane.This one is giving me heartburn. I almost ran something in Production that was supposed to be run on Dev yesterday because I didn't catch what instance the query opened up against.
I casted my vote (had another thread just like yours yesterday).
In the meantime you can install this. This allows you to change the background color based on the env. you are in.
I believe you can already change the color of the connection at the bottom of the query window with out-of-the-box SSMS.
Anyway, +1 for connect item.
you can
http://sqlfool.com/2009/03/ssms-server-settings/
perhaps you would care to vote for this connect item?
https://connect.microsoft.com/SQLServer/feedback/details/156852/sql2005-sqlagent-msdb-security-roles
It would be nice if they finally build the authorisation level for "job category" so that can be granted for non sysadmins to be administered/managed.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 10, 2011 at 9:20 am
Koen Verbeeck (8/10/2011)
Ninja's_RGR'us (8/10/2011)
Brandie Tarvin (8/10/2011)
Help me bug Microsoft about a minor issue that is driving me sane.This one is giving me heartburn. I almost ran something in Production that was supposed to be run on Dev yesterday because I didn't catch what instance the query opened up against.
I casted my vote (had another thread just like yours yesterday).
In the meantime you can install this. This allows you to change the background color based on the env. you are in.
I believe you can already change the color of the connection at the bottom of the query window with out-of-the-box SSMS.
Anyway, +1 for connect item.
another +1
Tom
August 10, 2011 at 9:35 am
Ninja's_RGR'us (8/10/2011)
george sibbald (8/10/2011)
@Remidarn them for closing it. worth another comment asking for it to be looked at again?
Not on my first read. I'd want to protect SA as much as possible. It's not much trouble to createa "jobs" user and create everything with that and then give them that account to play with.
Given that there is a perfectly good group mechanism in NT, it seems pretty crazy that an NT group can't own a job. Being able to grant permissions on an objectto several people in a simple manner is what the group structure was for in the first place. NT Groups can own files, why can't the own SQL jobs? How would allowing an NT Group to do so conflict with protecting SA - it seems to me that it would make it less likely for people to grant SA privileges to too many logins, so it wopuld help to protect SA.
Tom
August 10, 2011 at 10:21 am
Koen Verbeeck (8/10/2011)
Ninja's_RGR'us (8/10/2011)
Brandie Tarvin (8/10/2011)
Help me bug Microsoft about a minor issue that is driving me sane.This one is giving me heartburn. I almost ran something in Production that was supposed to be run on Dev yesterday because I didn't catch what instance the query opened up against.
I casted my vote (had another thread just like yours yesterday).
In the meantime you can install this. This allows you to change the background color based on the env. you are in.
I believe you can already change the color of the connection at the bottom of the query window with out-of-the-box SSMS.
Anyway, +1 for connect item.
The connection coloring in SSMS is very flaky. I don't use SSMS Toolspack because the one time I downloaded it the install failed. I do need to try it again though.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 10, 2011 at 12:08 pm
Brandie Tarvin (8/10/2011)
Help me bug Microsoft about a minor issue that is driving me sane.This one is giving me heartburn. I almost ran something in Production that was supposed to be run on Dev yesterday because I didn't catch what instance the query opened up against.
Voted
August 10, 2011 at 12:42 pm
george sibbald (8/10/2011)
@Remidarn them for closing it. worth another comment asking for it to be looked at again?
I just looked at it. It's open again.
August 10, 2011 at 12:46 pm
Thanks for those who have voted so far and to those who are about to vote. @=)
The color scheme is flaky. I noticed that when I set it in the Connect screen, it worked only for 1 instance of SSMS and I had to set it in other instances when I opened them (that was after closing the original instance and re-opening). Also, it doesn't stop you from opening in the wrong server. If you're having an off day and forget to look down, you can still get screwed up.
Haven't tried the toolkit. I need to be careful what I install at work because there's a process, procedure, etc. needed for extra software. Stuff needs to be approved by corporate, make sure it doesn't violate privacy policies, isn't nasty software, complies with company standards, and doesn't break other existing tools...
August 10, 2011 at 1:01 pm
Brandie Tarvin (8/10/2011)
Thanks for those who have voted so far and to those who are about to vote. @=)The color scheme is flaky. I noticed that when I set it in the Connect screen, it worked only for 1 instance of SSMS and I had to set it in other instances when I opened them (that was after closing the original instance and re-opening). Also, it doesn't stop you from opening in the wrong server. If you're having an off day and forget to look down, you can still get screwed up.
Haven't tried the toolkit. I need to be careful what I install at work because there's a process, procedure, etc. needed for extra software. Stuff needs to be approved by corporate, make sure it doesn't violate privacy policies, isn't nasty software, complies with company standards, and doesn't break other existing tools...
for those about to vote.....we..salute..you....
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
August 10, 2011 at 1:07 pm
Brandie Tarvin (8/10/2011)
george sibbald (8/10/2011)
@Remidarn them for closing it. worth another comment asking for it to be looked at again?
I just looked at it. It's open again.
Except for the part it was never closed.
This one is closed. And even after adding my vote it remains closed.
@george sibbald
perhaps you would care to vote for this connect item?
https://connect.microsoft.com/SQLServer/feedback/details/156852/sql2005-sqlagent-msdb-security-roles
August 10, 2011 at 5:05 pm
Brandie Tarvin (8/10/2011)
Help me bug Microsoft about a minor issue that is driving me sane.This one is giving me heartburn. I almost ran something in Production that was supposed to be run on Dev yesterday because I didn't catch what instance the query opened up against.
Cast my vote as the ninth (9th) For. Come on people lets support Brandie
August 10, 2011 at 8:49 pm
+1. Gggrrrrr. I've used godaddy for years, and hated them for years. Just had no time to get a divorce.
I've moved my asp.net hosting to discountasp. Community voted high. For my WordPress site/blog, I went wi MediaTemple. VERY satisfied, however they don't do .net hosting. mt wa the only company that called me after i paid with a skilled human to proactively help me migrate, etc. What? Never had that before.
Also, I went mt to get 100 sites/mysql db's on the same plan. And the ease of sub selling. Not that I intend to be a website maker as a business - no thank you. But a local UG has an uber-lame site that is probably driving people away. So I wanted to make a better site and give the chapt leader a place to blog too. Now, I can eat the cost easily, and do the same for other UG's in need without going broke.
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
August 11, 2011 at 12:04 am
bitbucket-25253 (8/10/2011)
Cast my vote as the ninth (9th) For. Come on people lets support Brandie
12th
Viewing 15 posts - 28,906 through 28,920 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply