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

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...

Sean Lange (4/27/2012)

---

SQLRNNR (4/27/2012)

---

Sean Lange (4/27/2012)

---

I particularly liked his last comment.

I know exactly where the problem is...that big blob...

+1

Sean Lange (4/27/2012)

---

I particularly liked his last comment.

I know exactly where the problem is...that big blob right between the...

Lynn Pettis (4/27/2012)

---

L' Eomot Inversé (4/27/2012)

---

GilaMonster (4/27/2012)

---

Yup.

On the plus side, SQL's smart enough not to log the...

Gromit

Gromit

If you can connect via ssms, then the issue is not server side. It is with the jdbc connection string you are using.

very handy.

Thanks

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...

Here's a starting point

http://sqlblog.com/blogs/eric_johnson/archive/2009/11/13/ssis-2008-looping-through-rows-in-a-table.aspx

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

straight forward question - thanks

I enjoyed the discussion for this question.