It does provide the db_id and the object_id and you can use that information to get that information. YOu would need to execute the query in the user database.

Other...

How are you handling the Multi-value parameter in the stored procedure? Here is a quote from BOL (bolding by me):

Writing Queries that Map to Multivalued Report Parameters

You can define...

There is not a KEEP function in SQL Server. You would need to do something like this:

create table #t (n int)

insert into #t (n) values (100)

insert into #t (n)...

Please see the links in my signature to see how to post to get better answers. I don't have enough information to help.

What is your data source definition?

What is...

This doesn't get you IP Address, but it will get you the rest:

SELECT

I.*

FROM

sys.traces T CROSS Apply

...

There is no mechanism in SQL Server to create a Login Group. As Jonathan said, if you want to allow a group of users access to your SQL Server...

The inserted and deleted tables are only available within the scope of the trigger and once you do dynamic SQL or call a stored procedure you have created a new...

Please see the links in my signature to see how to post to get better answers.

We don't have enough information to give you proper advice. SSIS is designed for...

Seth is right. You want the process that takes the data from tableA and inserts it into tableB to do the truncation. Why? Because the default trigger...

One way is to process them in SSIS using the FUZZY Lookup component. I don't think it works all that well, but it does get some. Depending on...

Check out this article[/url]and part 1 which is linked in the article

You should just use a temp table and truncate it.

Are you sure what you are doing requires a loop?

Try setting the the flat file source object to unicode. Found this here, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1200198&SiteID=1

You cannot reference tb1 in the derived table. So you should remove this line from the derived table:

WHERE tb1.[Change Notification Number] = cn2.[Change Notification Number]

If you explain what the query...

I'd strip it in .NET.

You can do it easy enough in SQL too. Replace(Replace(@DonationID, '{', ''), '}', '')