Thank u very much all of u guys.

U r very helpful

I got fair idea what to do now.

Cheers Antares686

for both databases the compatibility level is 80.

for the table in Tracker database

CREATE TABLE [dbo].[Task] (

 [Taskid] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [Taskname] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [fk_catid] [varchar]...

Yes,i am using sql2000.

when i remove where condition its working fine.

but i get error when i add checksum!!

no i did not misspel anything

Hi

i tried like following

select a.* from

task a

inner join

tracker..task b

on

a.taskid = cast(b.taskid as varbinary(5))

where CHECKSUM(a.*) != CHECKSUM(b.*)

but it is giving me error

Line 13: Incorrect syntax near '*'

(actually these 2 tables...

Thats cool Antares686 

I'll give it a try

Many thanks

Thanks alzdba thats great

ur first query always faster than 2nd one.

in the second one u r getting all data(select *) to memory where as in the first one there was none

Thats great mslava.

I'll give it a try

Thanks Julian

Hi Julian

It worked

By the way i'm wondering how can we check if file exist on network drive??

as u know in the abv example...

Hi Julian

Actually i tried that one too but to no avail.

actually i am running the code from my workstation

(i.e work) but server is on different machine.

Hi Julian

i tried like following

DECLARE @fileexists int

EXEC master..xp_fileexist '\\work\C Drive\abcd.dbf', @fileexists OUTput

IF @fileexists = 1          -- The file exists

   PRINT 'File Exists'       -- Do what you want here

else

 PRINT 'File does...

Thank u all for ur great input.

hi Phill Carter could u tell me what client statistics does?

Thanks

Thanks for the post mssql_rules 

actually i exported one table with 180 columns and some 8000 records to sql server.

when i ran

select *...