Why are you deploying to one folder and then moving to another? Why aren't you deploying directly to the necessary folder?

I just ran a quick test and re-deploying does NOT change the ItemID. Now if you deleted a report and then re-deployed you would likely get this behavior.

I think the issue is the concatenation for the backup path. When I do the concatenation I get an error, when I move the concatenation out and just use...

You'd have to show us the code in your ASP.NET page. There is something you are doing in .NET that is causing it.

Matthew,

Here's an example of what you could do. In the example I don't pivot the data as I just want to split the string and have multiple rows. ...

I think everyone has experienced poor customer service whether from a technology company or in some other area.

So far I have been fortunate to have gotten solid support from Dell,...

Yes you need the server name.

YOu have the options Guenter provided you can also use URL Access to display the report.

I've never done it, but there is a Hide In List View property on the reports in Report Manager so I'd assume you could set this programatically using PowerShell or...

A hack that can work is to create temp tables in the trigger from the inserted and deleted tables and using them in the stored procedure. This is definitely...

Can you post the table structures and some sample data so we can test against your schema?

Is there anything else going on in the transaction?

There are pluses and minuses to both methods. I think form a pure security standpoint using Windows Users/groups is more secure for login reasons and also easier on users...

Interesting catching up today as I did a rare thing and didn't touch my computer after 10AM on Saturday morning. I think that's the longest I've gone without being...

Paul,

But wouldn't using CONTAINSTABLE(table, *, N'123 AND Apple AND Street AND FL AND 33647', 50) do the same thing as adding a column to Full Text on with the...

Glad I could help.

CROSS JOIN returns a Cartesian product so if you have 10 rows in each table the query will return 100 rows, 1 row for each combination.

CROSS APPLY from BOL:

The APPLY...