I have another instance that is of 32 bit Standurd edition and on that I have a linked server configured that uses the same user credentials to connect to the...
Thank you for your reply... but this doesnot seem to be a permission/access issue... as I get the view structure.. but not the data.. it says (0 rows found).