I am just new here in dbforums and it was a pleasure joining.
I have a problem regarding a linked server connected to my MSSQL2005 db. My linked server is sybase and i have added same dev users for both sybase and mssql. There are 4 tables in the linked server added into my synonyms(mssql) but the problem is that i cant select/insert into these tables including executing sprocs involved. I already checked the permissions in these tables and all was correct(eg.select/insert/delete grant to dev role). Please help me what to do next.. tnx..