Viewing 15 posts - 5,656 through 5,670 (of 19,560 total)
Try this
SELECT name,default_database_name,is_disabled,type_desc
FROM sys.server_principals
WHERE type IN ('u','g','s');
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
September 6, 2012 at 5:23 pm
I thought this was a good summation of the psychology of a DBA. It is tough riding that line between overly egotistical and too humble. The right mix...
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
September 6, 2012 at 3:56 pm
Lynn Pettis (9/6/2012)
Steve Jones - SSC Editor (9/4/2012)
OK, not my day. Not sure how to break the news here that this person is in way, way, over their head.http://www.sqlservercentral.com/Forums/Topic1353224-2799-2.aspx#bm1354093
Okay, you're...
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
September 6, 2012 at 3:05 pm
jrichards54 (9/6/2012)
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
September 6, 2012 at 3:05 pm
I think it is great to bring this to the attention of the community. This behavior cannot be tolerated.
Better than talking about it, I would love to see action....
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
September 6, 2012 at 2:37 pm
Stefan Krzywicki (9/6/2012)
Lynn Pettis (9/6/2012)
jcrawf02 (9/6/2012)
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
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
September 6, 2012 at 2:10 pm
Lynn Pettis (9/6/2012)
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
Why do people think that they will get a different answer to the same problem if they post it in the correct forum?
What is...
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
September 6, 2012 at 12:10 pm
That user is being used in a connection string somewhere. It could also be in use by somebody who knows the pw to that account. Check to see...
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
September 6, 2012 at 12:02 pm
jcrawf02 (9/6/2012)
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
Why do people think that they will get a different answer to the same problem if they post it in the correct forum?
What is 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
September 6, 2012 at 12:00 pm
Lynn Pettis (9/6/2012)
Why do people think that they will get a different answer to the same problem if they post it in the correct forum?
What is the circle of...
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
September 6, 2012 at 11:55 am
Stefan Krzywicki (9/6/2012)
Lynn Pettis (9/6/2012)
Stefan Krzywicki (9/6/2012)
...watermellon meatloaf
Doesn't quite work... :w00t:
Aw, mice! I'll keep practicing. I'm sure I'll get it eventually.
stupid language - always some silly rule:-D
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
September 6, 2012 at 11:33 am
Lynn Pettis (9/6/2012)
Jan Van der Eecken (9/6/2012)
RBarryYoung (9/6/2012)
Stefan Krzywicki (9/5/2012)
Fal (9/3/2012)
Quick poll: how would you pronounce the word "Route"?I'll explain why later, if I'm not too embarrassed. :blink:
Steve.
"Root" is...
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
September 6, 2012 at 11:08 am
Thanks Ron.
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
September 6, 2012 at 10:28 am
crookj (9/5/2012)
wotd - Finally! NFL Starts Tonight! :w00t:
Yeah and that was a terrible result.
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
September 6, 2012 at 9:14 am
Thanks for a good question wayne
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
September 5, 2012 at 2:56 pm
Viewing 15 posts - 5,656 through 5,670 (of 19,560 total)