Most of the cost is with a scan on CustomerInvoiceLine, which when looking at the plan is bringing back 13898 rows, but the inner join to Manufacturer is filtering that...

When you migrated, did you rebuild all indexes and ensured all statistics where up to date?

Also could you please read through the 4th link in my signature on posting performance...

Yes using an nested IIF expression on the field combined with MIN & MAX

Something hopefully a bit like

=IIF(Fields!SomeField.Value = MIN(Fields!SomeField.Value), "Red", IIF(Fields!SomeField.Value = MAX(Fields!SomeField.Value), "Green","White"))

You will be better off posting data in a consumable format in order to get help quickly, please see the second link in my signature for help on this

I have...

What browser are you using?

Also what security has been setup on the URL?

This should get you to a pretty good starting point

SELECT

U.UserName AS SubscriptionOwner,

C.Path AS ReportPath,

CONVERT(XML,S.ExtensionSettings) AS SubscriptionSettings,

S.EventType AS SubscriptionType,

CONVERT(XML,S.Parameters) AS ReportParameters,

S.DeliveryExtension AS DeliveryMethod,

Sc.Name AS ScheduleName,

Rs.ScheduleID

FROM

Subscriptions S

INNER JOIN

Users U

ON

S.OwnerID = U.UserID

INNER JOIN

Catalog...

The user account is given a token which in effect is sort of a hash of the details required to login.

The account goes to SQL and says hello here is...

one of the two columns or both being converting to decimal have none transformable charcters, check the data and update/delete the offending rows.

you will need to check the port in the SQL config manager and then open the port, be aware that if you dont set it to a static port it...

SQL Browser service started?

Firewall blocking the dynamic port of the named instance?

what is the version of the source and destination server?

also can you re-take a backup and try restoring, 3241 is usually a misformed backup so wont restore

SELECT RIGHT('00'+CONVERT(varchar,1),3)

how do you identify the latest record, do you have a timestamp or identity column on the table?

http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%281230%29-tempdb-should-always-have-one-data-file-per-processor-core.aspx

Run the upgrade advisor for 2008, also test all packages work in their 2005 format, otherwise upgrade them in BIDS 2008, test and redeploy.

The upgrade advisor will tell you if...