Think this is what you were after, sorry I misread your comments

http://www.sqlservercentral.com/columnists/rpearl/2819.asp

There have been statements in similar incidents of implicit conversion might be at the root of this.

Try making the data varible, set the variable and use the variable to...

So many factors to compare. Hardware 1for1 on each, hardware configured exactly the same, server exactly the same, same resources running or otherwise in use on each. If if they...

TOP 100 PERCENT has not been removed from use it just changed the way it works.

See this nice little write up here

http://www.sqlskills.com/blogs/kimberly/PermaLink.aspx?guid=79de45cb-2da6-4510-ae43-7e5e42e4c02e

What user account is the job under? This sounds like a permissions issue. Might need to log on with that user account and make sure excel isn't trying to processes...

No there is not. May have been the tool they were using if was a visual tool. EM will do this in the visual designer if you set and order...

How many seperate transactions occurr on this table at one time (not batches individual)? Also would help if we can see the entire trigger to be sure of what is...

Just a word of caution as a reminder,  you should never try to perform direct updates to system objects unless there is no way otherwise.

Check out this KB article it...

You can script deploy them using RSS via RS.exe.

There is a sample installed with samples with a file name PublishSampleReports.rss

Here is an example of what I do to publish Report1.rdl...

Me I stick it to the theaters by going to my local drive-in which shows 2-3 movies for 8 by the car load. I shop the local used bookstore and...

However I would say plan for the long term. If you know you have a potential you will need the larger row size be prepared so you don't have to...

Well I woul still try creating a view while logged into the SQL Server as SA. But I would change the SA password personally since you won't be using in...

Was this intentional? If so from BOL

Merge Replication or Updatable Subscriptions

When replicated data needs to be updated at the Subscribers, you can use snapshot replication or transactional replication with...

The transaction would not be part of this issue. Basically a transaction object issues a BEGIN TRAN on the server with a reference that can be used for ROLLBACK and...

Try creating a view while logged in as SA then see what happens. But beyond that, you are not really going to be using SA for you Crystal Reports report...