In my example both database are on the same Server.

Abrahim

Here is the real code:

select cp2abc.*

from prd2.dbo.abc as prd2abc, prd1.dbo.abc as prd1abc

where not exists

(select prd1abc.subj_num from prd1.dbo.abc as prd1abc where prd2abc.subj_num = prd1abc.subj_num

and prd2abc.abc_DATE = prd1abc.abc_date)

Abrahim:Whistling:

That did it!!!

Thanks:D

I tried:

select prod.dbo.A.*, dev.dbo.B.*

from prod, dev

where prod.dbo.A.id = dev.dbo.B.id

and prod.dbo.A.id <= 100

but getting error:

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'prod'.

Server: Msg 208, Level 16, State...

I found this script that it finds the table's name.

SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name = 'SC_BL_ADAPT' )

Abrahim

Michaela,

Thanks for the help,

Abrahim

Eugene,

Sorry, I guess I missed your post

Abrahim

Unfortunately Login to the box with jim didn't fix the problem.

I fund this fix on Microsoft site

Jonathan,

Here is my email: abk@stanford.edu

Thanks,

Abrahim

Jonathan,

That would be great!

Do I need to use IIS and Apps server?

Thanks,

Abrahim

Jonathan,

Our users do not like Access or Excel.

Not to forget that they are MAC users.

I'm not an asp programmer.

I was hoping to find a tool that is out box ready...

Thanks Rick ,

I'll give it try.

Regards,

Abrahim

Thank you all for the wonderful feedback!!

I can't wait to see a simple documentation about how to secure the SQL server 2000.

Best regards,

Abrahim

Thanks,

Abrahim

Is there any link to the security and user setup for SQL 2000 out there?

Thanks in advance,

Abrahim