Well the error is " Login failed for user {My login id}"

My colleagues have been able to access that view using stored procedures in different databases, but I need to...

Yes I was looking something similar to this but I wrote small .NET app to achieve this where I have a little more room to manipulate logic.

Thanks to all who tried to help me here.... I guess the situation was a little tricky that is why it was a little hard to explain. We kind a...

Sorry! I thought anyone would be able to grasp the ABC psudocode :-). Anyway I'll elaborate a little further on table x. This table can differ in number of fields...

Thanks for you suggestions... Since it doesn't show any error I cant say if there is any blocking or not... but last time I let it ran whole night for...

Thanks for this bit of info as I wasn't able to locate this issue after numerous searches. I have let the package run for about 3-4 hours and then cancelled...

Well, it is pretty simple package created through wizard. I am importing the data from another database at different location to our server. It simply copies the data into each...

Anyone here knows what it could be?

Just to elaborate a little more I only want to track an update to the record, not insert or delete

1) There is only one update proc where the data is...

I believe that is what I am looking for. It seems they dont have a real solution yet for these situations.

Firstly, Thanks to everyone for their suggestions. I am still unable to get the procname which initiated the trigger. Since I have limited knowledge about the built in SQL functions...