regarding DTS, do you use your client's EM to edit the package ? (and have no local default instance of sqlserver at your client)

or do you use remote desktop to the...

I can see the "Executed as user: NT AUTHORITY\SYSTEM".

So I guess your sqlagent is being serverd by "Local System".

You may want to change that to an account that has authority...

I guess if you try to select a convert(varchar(...), yourcol) you'll find out.

select convert(varchar(...), yourcol) as varcol

, yourcol

from yourtable

where convert(varchar(...), yourcol) <> yourcol

just my 2ct...

- use aliasses ! IMO it makes it way easyer to read and may even reduce your chances for mistake. If you...

sorry for the late response.

I'm at SQLPass 2006 for the moment and I didn't  check my SSC...

- wich account is jobowner ?

- how did you setup authentication for the linked server ?

   is there a mapping for the jobowner ?

... One other issue that might be a factor is that at the moment all our databases are set to a compatibility of 80 rather than 90. This is the...

..domain admin ? No reason at all !

It doesn't even have to be local admin on the box ! The one installing sqlserver needs to be member of the...

topic "Moving System Databases" in BOL describes it clearly.

When I find some time I'll have to test this procedure myself. (this will be after 3 weeks because I'll have...

- So you moved the systemdb's and the RTM still worked ?

- what are your startup parameters for sqlserver ?

- check the original locations to see if sp1 put new...

that's one of the things they did not alter for sql2005.

You still have to mention the filegroup for each index and there is no setable default (other then the normal...

A default instance for sql2000 uses the reserved name MSSQLSERVER;

If you stated MSSQLSERVER for your named instance, you may be in troubles !

Be specific and mention the names you've used.

maybe this will help out ....

I don't have the ref where I got it

CREATE TABLE #tables_usage (

    name varchar(50) NULL,

    rows varchar(15)...

here's a very good article ...

http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm

use yourdb

exec sp_helpfile