Link Server from SQL2005 to SQL2000

I have the follwoing scenario, where the query returns an error, when we tried to upgrade oru production SQL2000 enviroment to SQL2005.

SQL2000 Env:

Microsoft SQL Server Developer Edition

Microsoft Windows NT 5.2 (3790)

8.00.2175 SP4

SQL2005 Env:

Microsoft SQL Server Developer Edition

Microsoft Windows NT 5.2 (3790)

9.00.3054.00

Notice the removal of the two RTRIMs.

Any help welcome

Gertus

Current Connection was on the SQL2005 machine:

Remote Link Server SQL2000 SP4

Working:

SELECT * FROM Entity -- on SQL2005

WHERE

(EntityRef) + Source NOT IN

(SELECT (ENTITYID) + 'EU' FROM MRIEU.MRIOB.dbo.ENTITY) --this is on sql2000

AND Source = 'EU'

Not-working:

SELECT * FROM Entity-- on SQL2005

WHERE

RTRIM(EntityRef) + Source NOT IN

(SELECT RTRIM(ENTITYID) + 'EU' FROM MRIEU.MRIOB.dbo.ENTITY)

AND Source = 'EU'

Error :: >>

OLE DB provider "SQLNCLI" for linked server "MRIEU" returned message "Cannot create new connection because in manual or distributed transaction mode.".

Msg 7320, Level 16, State 2, Line 1

Cannot execute the query "SELECT TOP 1 1 FROM "MRIOB"."dbo"."ENTITY" "Tbl1005"" against OLE DB provider "SQLNCLI" for linked server "MRIEU".

Did you try searching the MS knowledge base?

http://support.microsoft.com/kb/272358/en-us

|||

Sorry that is not the problem, I am runnign this query in sql storedproc, it this is an error on the link server code internal of Microsoft.

Can any Microsoft person help here please?

Regards

Gert

limit on SQL CE upgrade.exe?

Is there a size limit on the upgrade.exe to convert the SQL 2.0 SDF file to the SQL Mobile 2005/SqL CE 3.0?

I have a 184M SDF that I tried putting through the upgrade but i got an error that it exceed a 128M limit? Is there a way around it? maybe another parameter I need to pass in?

Thanks

Dorothy

This has been identified as Bug in upgrade.exe. MS is currently working on a HOTFIX to fix this issue.

You might want to call MS and get HOTFIX which should fix upgrade.exe issue for upgrade of SDF file > 128 MB.

Regards,

Akshay

|||

The hotfix is now available (by request) via this kb article: http://support.microsoft.com/default.aspx?scid=kb;en-us;935769&sd=rss&spid=2852

FIX: Error message when you upgrade a database from SQL Server 2000 Windows CE Edition 2.0 to SQL Server 2005 Mobile Edition: "The database file is larger than the configured maximum database size"

limit on SQL CE upgrade.exe?

Is there a size limit on the upgrade.exe to convert the SQL 2.0 SDF file to the SQL Mobile 2005/SqL CE 3.0?

I have a 184M SDF that I tried putting through the upgrade but i got an error that it exceed a 128M limit? Is there a way around it? maybe another parameter I need to pass in?

Thanks

Dorothy

This has been identified as Bug in upgrade.exe. MS is currently working on a HOTFIX to fix this issue.

You might want to call MS and get HOTFIX which should fix upgrade.exe issue for upgrade of SDF file > 128 MB.

Regards,

Akshay

|||

The hotfix is now available (by request) via this kb article: http://support.microsoft.com/default.aspx?scid=kb;en-us;935769&sd=rss&spid=2852

FIX: Error message when you upgrade a database from SQL Server 2000 Windows CE Edition 2.0 to SQL Server 2005 Mobile Edition: "The database file is larger than the configured maximum database size"

limit on SQL CE upgrade.exe?

Is there a size limit on the upgrade.exe to convert the SQL 2.0 SDF file to the SQL Mobile 2005/SqL CE 3.0?

I have a 184M SDF that I tried putting through the upgrade but i got an error that it exceed a 128M limit? Is there a way around it? maybe another parameter I need to pass in?

Thanks

Dorothy

This has been identified as Bug in upgrade.exe. MS is currently working on a HOTFIX to fix this issue.

You might want to call MS and get HOTFIX which should fix upgrade.exe issue for upgrade of SDF file > 128 MB.

Regards,

Akshay

|||

The hotfix is now available (by request) via this kb article: http://support.microsoft.com/default.aspx?scid=kb;en-us;935769&sd=rss&spid=2852

FIX: Error message when you upgrade a database from SQL Server 2000 Windows CE Edition 2.0 to SQL Server 2005 Mobile Edition: "The database file is larger than the configured maximum database size"