Viewing 15 posts - 6,316 through 6,330 (of 19,560 total)
Here is another thread with the same issue.
They granted execute to sp_enum_dtspackages and sp_get_dtspackage in msdb.
http://www.sqlservercentral.com/Forums/Topic340016-359-1.aspx#bm519123
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 27, 2012 at 2:55 pm
Do you want to see the historical values for the data?
Do you want to see the DML that was performed?
Do you want to see who it was that made 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
April 27, 2012 at 2:38 pm
Sean Lange (4/27/2012)
SQLRNNR (4/27/2012)
Sean Lange (4/27/2012)
i am putting it in if condition,does that is the problem?
I know exactly where the problem is...that big blob...
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 27, 2012 at 2:36 pm
Stewart "Arturius" Campbell (4/27/2012)
This is a really good question, thanks Koen.I'm happy to learn that ms have eventually upped the ssis security.
+1
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 27, 2012 at 2:27 pm
Sean Lange (4/27/2012)
i am putting it in if condition,does that is the problem?
I know exactly where the problem is...that big blob right between 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
April 27, 2012 at 2:24 pm
Lynn Pettis (4/27/2012)
L' Eomot Inversé (4/27/2012)
GilaMonster (4/27/2012)
Lynn Pettis (4/27/2012)
Gail, without really digging into this, isn't this just an expensive NOP?
Yup.
On the plus side, SQL's smart enough not to log 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
April 27, 2012 at 2:23 pm
EL Jerry (4/27/2012)
Lynn Pettis (4/26/2012)
Freedom!Wallace?
Gromit
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 27, 2012 at 2:16 pm
EL Jerry (4/27/2012)
Lynn Pettis (4/26/2012)
Freedom!Wallace?
Gromit
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 27, 2012 at 2:08 pm
If you can connect via ssms, then the issue is not server side. It is with the jdbc connection string you are using.
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 26, 2012 at 11:18 am
very handy.
Thanks
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 26, 2012 at 10:44 am
The size is not too terribly large. You can leave it as-is. For recommendations on how much data to retain (job history and table size history), you will...
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 26, 2012 at 10:38 am
Here's a starting point
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 26, 2012 at 10:36 am
You may need to enable SQL Express to accept remote connections if not already done.
http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx
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 26, 2012 at 10:33 am
straight forward question - thanks
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 26, 2012 at 10:06 am
I enjoyed the discussion for this question.
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 26, 2012 at 10:04 am
Viewing 15 posts - 6,316 through 6,330 (of 19,560 total)