Sorry I'm new in SSIS I've looked for log cann't find one how do I locate one.

Thanks for the information you provided.

greyswoo

Initially I was setting up a workstation running sql2005 and

server Windows server 2003 running sql2000 that didn't work sql2005 (using Network account).

2nd Test server sql2005(local system account) Standard edition 32bit,...

Hi all

Well I've just found something strange with Linking server sqlserver2000 and sqlserver2005. I test with sql2000 and sql2005 (Standard edition 32bit) using Local System account and its worked fine....

I've setup linked server for 2 servers that I will be using. I can run a Query from sqlserver2000 querying sqlserver2005 database and the other way around. I then try...

Yes you are right. Your enviroment is exactly the same as my one and I just did what you did. Guess what its work.

I'm still wondering why not on the...

I run the above script and I got the error below what did I do wrong

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

DBCC execution completed. If...

Sqlserver 2000 is Mix mode Sqlserver 2005 is windows authentication.

For linked server I setup the same Remote login

Sqlserver 2000 Standard edition. Sqlserver 2005 32bit

I opened sqlserver2000 and use SQL Server Authentication. I then Logon with the linked server username and password.

Query Analyzer opened fine. I did the...

No I can't I just run the above command and it returning blank screen. What could be the problem?

Hi

I'm also have the same problem linking SQL Server 2000 and SQL server 2005. From 2005 I can query SQL 2000 databases. Where as in SQL 2000 its coming up...

Thanks a lot.

I will first move everything Table and Data then data only.

Thanks a lot