The file may be in use. It may be in use by another connection of the same linked server.

You may want to check if the account that accesses your Access...

Run Performance Logs. Then analyze them once in a while

Try to execute the job yourself.

Did you install MySQL driver?

A person who creates 1 NF does not know a word Partitioning

Some applications do not supporn named instances. Also named instances require port 1434 open unless you configure clients to uncheck "Dynamically Determine Port" and most network administrators don't like opening UDP...

It is not what I mean.

You have 35000 characters as a value. You application reads this value into say, Visual Basic variable of the type String. This now can hold...

it does require a password

Don't forget that a lot of front end string variables have a length of 32K. So whatever is in the database as a varchar(max) more then 32K will be corrupted...

I read the article and Andy's today's article of the day. I too installed SP2 last week on 2 servers and I have a version 3042. I will be installing...

I installed SP2 on the server, created a maintenance plan and could not open job steps for this plan. Everything was done on the server. For some reason when I...

Kids,

Vivien brings up a good point!!!

In SQL Server 2000 we had cases when the package was created when somebody was connected as SA, the owner was a domain login, all...

Ken,

did you figure it out?

Thanks Andy.

A want to add: they should have posted the path too. It is:

YourDrive:\Program Files\Microsoft SQL Server\90\DTS\Tasks

also, I thought that SP2 adds a feature that Maintenance Plans work without DTS...

I had these cases several times when installing SPs on somebody else's servers. This somebody has a preference to have different permissions to admins account to different drives. For example,...