I agree with Michael above. The code is the same. Licensing is an administrative thing.

Jez has a good point. I'd use full pathing when setting up the job, not relative pathing, to test it. If that works, you know where your issue is.

Also, you'd be better not using a drive. Use UNC mapping for the copy.

More fun if there's a motivational picture on the bottle

I've seen similar things happen, when a proc running fine suddenly gets a new plan that's horrible for performance. Even in the middle of the day.

We've never gotten a good...

I'm not sure where I said we should design for just the 10% that are the richest. I think I was making a point that we should design for the...

First, apologies for the image. It was written awhile ago and I didn't think of the image as offensive, but I apologize.

Second,

I do think it is a cultural thing...

ditto. Seems like a strange example. CAn you give a URL for this?

You might want to track down code that's got some performance issue or is being used a lot. Seeing the SQL is an easy way of helping you do this.

If you have to ask for a detailed document, you might not be the person to do this job. It can be complex to migrate a server to a new...

It's likely that the banks have been using Sybase for a long time and keep upgrading. Also as mentioned above, their software may require it.

Sybase is a good product and...

I'm not 100% sure what is wrong, but when you first install SSMS or SQL Server, there are not connections under Registered Servers. You need to add them yourself.

I'd create...

I agree with Christopher's suggestion. I'd create a table of holidays because these can change from year to year for a company. This way you can join in this table...

How else will you do it other than mapping each table? There's not facility for automatically moving tables to an archive.

Set up a task in DTS for each table, use...

It's probably because they have been working on Sybase for years and see no reason to change. Sybase has been a good product, just not as popular as SQL Server...