*fingers crossed*

You can find those with

update ...

set myfield=left(myfield,1)+'xyz'+right(myfield,len(myfield)-4)

where myfield like '_abc%'

Are you working with sql authentication or integrated security (windows authentication)?

Are the servers up & running?

Could it be the new security settings for MSDTC in Windows 2003?

http://www.sqlservercentral.com/articles/Administering/debuggingmsdtcissues/1257/

See you then!

There certainly must be a script around for this.

Job history is maintained in the msdb database. sysjobhistory system table

Is the other side also windows 2003?

Is there a firewall in between?

This post mentions also another utility dtcping

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=455113&SiteID=1

just for future reference

dtstester: http://support.microsoft.com/kb/293799

Any chance that the other connecting machine isn't a windows 2003 machine?

In that case you need to set some security options for MSDTC.

Might find the kb back on monday.

there is a primary key on both sides?

The service pack setup is the same for client-tools and server.

Client version:

Open query analyzer

Menu Help -> About

You can find the various build versions of sql 2000 at

http://www.aspfaq.com/sql2000builds.asp

could be a mismatch in servicepack level between your client-machine and the server.

from the books online:

AUTO_SHRINK

When set to ON, the database files are candidates for periodic shrinking. Both data file and log files can be shrunk automatically by SQL Server. When...

be aware that a field in a table can have a different collation than the default collation for a database.

1) find the query/command causing the trouble

2) check all the fields and their...

move the "AND weeklyuserscores.weeknum = 2" to the left join clause, otherwise it will be filtered out.

SELECT

    users.username

    ,weeklyuserscores.score IS NULL AS Score

    ,weeklyuserscores.absolutevaluescore IS NULL AS AbsoluteValueScore

    FROM users

    JOIN groupmembers

    ON users.ID...

Hello,

What kind of technology do you use ADO,DAO?

Anytime my passthrough gave an error Access notified me, unless on error resume setting is on. (in order to process the error in...