Viewing 15 posts - 9,346 through 9,360 (of 19,560 total)
Spring Cleaning
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 22, 2011 at 1:11 pm
I am somewhat intrigued to see that so far only 19% of respondents have answered correctly.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 22, 2011 at 9:49 am
Shark Energy (7/22/2011)
cengland0 (7/22/2011)
http://technet.microsoft.com/en-us/library/bb510667.aspx
Administering Policy-Based Management requires membership in the PolicyAdministratorRole role in the msdb database. This role has complete control of all policies...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 22, 2011 at 9:47 am
SanDroid (7/22/2011)
crafdenberg (7/22/2011)
Execute as user is made up? It actually does exist but my guess was that it couldn't be used when executing policies.BOL reference:
Execute As (Transact-SQL)
Uh Oh... maybe I...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 22, 2011 at 9:45 am
cfradenburg (7/22/2011)
Execute as user is made up? It actually does exist but my guess was that it couldn't be used when executing policies.BOL reference:
Yeah - I worded...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 22, 2011 at 9:43 am
sharath.chalamgari (7/22/2011)
i was not thinking about the least previlages and selected the sysadmin role. thanks for the good question.
You're welcome
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 22, 2011 at 9:42 am
cengland0 (7/22/2011)
http://technet.microsoft.com/en-us/library/bb510667.aspx
Administering Policy-Based Management requires membership in the PolicyAdministratorRole role in the msdb database. This role has complete control of all policies on the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 22, 2011 at 9:40 am
stewartc-708166 (7/22/2011)
This was quite a headscratcher.thanks, Jason, learned something today.
Woohoo - goal accomplished then
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 22, 2011 at 9:18 am
Britt Cluff (7/22/2011)
Thanks for the question.
You're welcome
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 22, 2011 at 9:17 am
Thomas Abraham (7/22/2011)
Excellent question. Thanks Jason!
My pleasure
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 22, 2011 at 9:17 am
Kwex (7/22/2011)
Nice question! Got me researching on Alerts, Roles and Policies before I answered and got it right 🙂
Thanks - and good:-)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 22, 2011 at 9:16 am
Brandie Tarvin (7/21/2011)
SQLRNNR (7/21/2011)
SkipperGilligan
Professor
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2011 at 11:33 am
Skipper
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2011 at 10:05 am
Thomas Abraham (7/21/2011)
Ninja's_RGR'us (7/21/2011)
Steve specifically says that the server is a new install in windows mode which would make me assume that SA has never,ever logged in.
He also said the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2011 at 10:03 am
Brandie Tarvin (7/21/2011)
Or do you just keep in...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2011 at 9:40 am
Viewing 15 posts - 9,346 through 9,360 (of 19,560 total)