HI

I tested the query using sqlserver2005 it works fine .

can you please let me know the issue with you .

hi i think this may help you ,

SELECT t1.*, 'Added' FROM table1 t1

LEFT JOIN table2 t2 ON t1.ID = t2.ID

WHERE t2.ID IS NULL

union

SELECT t1.*,'Changed'

FROM...

thanks for your reply , i have done the same , my problem solved by using global temp tables

Thanks to all for your quick replies .

a part from considering the above cases does XML SCHEMAS in data base

will effect execution .

hello

Still no suggestions ,

atleast is it possible or not

Thanks

Ok fine thanks for your replies

Hello

You mentioned that your table name is some thing different than

dbo. ,actually when you assign your table to particular schema

then your table name will appear with that...

Hello

You can use deny permission(read or write or ..) on a particular object (Table in your case )

which can solve your requirement .

Hi john

thanks for your reply,

now its solved ,but i just confused where actually roles and schemas are

separately used .does this problemcan be achived by any means using Roles.

Thanks

Thanks Samrath ,

thats what exactly i am looking for

Thank you very much

Thanks to all your replies , i will look for all the suggestions,