Viewing 15 posts - 11,206 through 11,220 (of 39,963 total)
Keith Tate (4/23/2014)
April 23, 2014 at 9:46 am
Gary Varga (4/23/2014)
My reading of the editorial was that the material would be good for self-learning NOT so others can resurrect the MCM certification.
Yes
April 23, 2014 at 9:45 am
andrew gothard (4/23/2014)
jasona.work (4/23/2014)
April 23, 2014 at 9:44 am
Gary Varga (4/23/2014)
...I can see the benefits to the community and thus to Microsoft but as what cost?
...
What's the cost? What do you see as a downside?
A little lawyer...
April 23, 2014 at 9:43 am
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Yes and no. As a DBA, I've tried to be proactive and look for ways to prevent issues....
April 23, 2014 at 9:04 am
marcia.j.wilson (4/22/2014)
Hope you enjoy your sabbatical, but you'll certainly be missed.
Thank you. I'll be back - http://www.youtube.com/watch?v=WgPePk3kGZk
April 22, 2014 at 2:43 pm
sp_addserver should populate the fields correctly for applications to work with the instance. I'm not surprised it isn't documented, but you can certainly submit a doc bug to have that...
April 22, 2014 at 1:52 pm
Both are fine. Include some scenarios/examples, so that someone not sure how to do this understands what they are doing here.
April 22, 2014 at 1:47 pm
Take it. I prefer that you get one done before doing another, but since this and the server one are very similar, do them both.
You can use the same style/template/language...
April 22, 2014 at 10:33 am
You may want to look at fn_my_permissions: http://msdn.microsoft.com/en-us/library/foo30f97f00-03d8-443a-9de9-9ec420b7699b.aspx
You can also check for roles with IS_Member() - http://msdn.microsoft.com/en-us/library/foo77cb68a0-19b7-4fe1-ab17-e5587699631b.aspx
There's also an analogous server role function.
If you just want a larger view of...
April 22, 2014 at 9:46 am
Does Andy's idea work?
It's not quite clear what you mean. Do you want to show the email if the device is not null or show the email only and NULL...
April 22, 2014 at 9:42 am
There isn't a good way to do this. SQL doesn't really track access of resources by user and aggregate it. It can track some things by resource accessed, but not...
April 22, 2014 at 9:39 am
Viewing 15 posts - 11,206 through 11,220 (of 39,963 total)