Viewing 15 posts - 10,591 through 10,605 (of 19,560 total)
annasql (4/5/2011)
"And again the relation to the service account that is a domain account, you will NOT see it listed anywhere in those groups. YOU WILL ONLY see the SID...
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
April 5, 2011 at 1:47 pm
SQLDCH (4/5/2011)
CirquedeSQLeil (4/5/2011)
Can anybody else lend a hand here?Aye, we're doing our best =)
Round the mulberry bush we go. 😛
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
April 5, 2011 at 1:34 pm
If you are interested, I have written a script that produces the FK Hierarchy in the given database.
You can find it here.
http://jasonbrimhall.info/2010/02/01/key-discovery-iii/
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
April 5, 2011 at 1:29 pm
Can anybody else lend a hand here?
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
April 5, 2011 at 1:23 pm
annasql (4/5/2011)
For @SQLDCH answer about the group,...
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
April 5, 2011 at 1:20 pm
annasql (4/5/2011)
And Is it a manual process after installation to add the service account in my case is a windows domain account to the windows local group called:SQLServerSQLAgentUser$Mycomputername$MSSQLSERVER
@SQLDCH already...
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
April 5, 2011 at 1:03 pm
Lynn Pettis (4/5/2011)
Grant Fritchey (4/5/2011)
Lynn Pettis (4/5/2011)
Grant Fritchey (4/5/2011)
Brandie Tarvin (4/5/2011)
Grant Fritchey (4/5/2011)
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
April 5, 2011 at 1:01 pm
GilaMonster (4/5/2011)
CirquedeSQLeil (4/5/2011)
John Mitchell-245523 (4/5/2011)
CirquedeSQLeil (4/5/2011)
a non-clustered index cannot be defragged without the presence of a clustered index.
Jason, are you sure about this? My understanding is that you can...
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
April 5, 2011 at 1:00 pm
GilaMonster (4/5/2011)
ambo.php (4/5/2011)
i try to check itbut while run check and maintenace
and click start jop
it say : excuting jop step '0 unknown'
Why are you running a maintenance plan? The error...
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
April 5, 2011 at 12:59 pm
it looks like an incomplete maint plan was created. Did you verify the job steps inside the job?
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
April 5, 2011 at 12:33 pm
It seems that you are now doing something different. Could you give more details please?
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
April 5, 2011 at 12:19 pm
annasql (4/5/2011)
No one seems to answer this question.But this is really important for security.
Maybe this question should all start with:
Does the sql server agent account have to be a sysadmin?
Thanks
Yes
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
April 5, 2011 at 12:14 pm
Philip Millwood-419646 (4/5/2011)
Wow guys, I can't thank you enough. The 2nd link from Steve is exactly what I was hoping for.
Awesome - glad we could help.
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
April 5, 2011 at 11:49 am
Stefan Krzywicki (4/5/2011)
GSquared (4/5/2011)
jcrawf02 (4/5/2011)
'scuse me while I clean up the dust around here...
Do your chores and we'll let you have icecream after supper and might even increase your allowance....
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
April 5, 2011 at 11:24 am
As Gus said, it looks like custom errors being thrown from a trigger on the table.
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
April 5, 2011 at 11:20 am
Viewing 15 posts - 10,591 through 10,605 (of 19,560 total)