By default, only members of sysadmins can access sysxlogins, so are you executing the stored procedure as a sysadmin?

No. The Transfer SQL Server Objects Task is for moving objects + data (if table). You should use an Execute SQL Task to insert/update/delete the data in the...

Yeah, I know. What I was trying to illustrate...

Don't maintenance plan jobs run as the SQL Agent service account like other jobs even if they're owned by another login? I don't use maintenance plans much so I'm...

See my reply in this thread: http://www.sqlservercentral.com/Forums/Topic863044-146-1.aspx#bm863413. In my case, the objective was to trigger execution of an SSIS package from an application.

I've used this method:

Have the Server A job update a table on Server B when it completes, then have the Server B job query the table in it's first step...

Is anyone else confused? Are k2000.rajesh (the op) and k2000rajesh the same person?

If you enable package logging to SQL Server, it will log errors in msdb.dbo.sysdtspackagelog and msdb.dbo.sysdtssteplog. You can query those.

Enable logging by editing the package, opening Package Properties...

If you mean when the file will be deleted by the Cleanup Task in the maintenance plan, I think you can only find that in the plan itself, not in...

If there's a backup statement...

You've fragmented the thread by posting this question in another forum: http://www.sqlservercentral.com/Forums/Topic867314-266-1.aspx. Follow Paul Randal's advice in that thread

Paul Randal has a nice article about logging here: http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx?pr=blog.

Logging can't be "turned off" and it's never been controlled at a table level in SQL Server. Maybe...

You can find lots of scripts by searching this site. Here's one I've used: http://www.sqlservercentral.com/Forums/Topic436343-359-1.aspx. You can also see the object permissions of a role in SSMS by...

Duplicate post. Please direct answers to this post: http://www.sqlservercentral.com/Forums/Topic864318-148-1.aspx#bm864417

#1 DTS packages are stored in sysdtspackages. SSIS packages are stored in sysdtspackages90.

#2 Look at the properties of the Execute Package Task in the parent package. It's possible...