Sounds like two way column encryption

This should help

http://www.databasejournal.com/features/mssql/article.php/3922881/Column-Level-Encryption-in-SQL-Server.htm

I think the requirements is to strip out anything between positions 50 and 74 and replace it with a blank space

So

ZY0503400000234567891234567890110000000000088975812345678901234567890123455668550000000

Becomes

ZY05034000002345678912345678901100000000000889758 5668550000000

Something like this

SELECT

LEFT('ZY0503400000234567891234567890110000000000088975812345678901234567890123455668550000000',49)

+' '+

RIGHT('ZY0503400000234567891234567890110000000000088975812345678901234567890123455668550000000',

LEN('ZY0503400000234567891234567890110000000000088975812345678901234567890123455668550000000')-74)

Check out the link to the string splitter in my signature.

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)