Jack,

Its working! 🙂

Hi vyas,

Correct me if i am wrong!

what does EXECUTE AS clause has to play a role here?

do you think, the creator's permissions are being impersonated when the user having "EXECUTE"...

Hi,

I have given "db_owner" database role to the current user and run the code. then it is working fine.

But can i know any specific privilege to be given, instead of...

Thank you.

What does SPN stands for and how it is related to Linked Server?

After making the Security changes for linked server , do we need to restart sql server or what?

i dont think so but 🙁

If on windows authentication:

Same explanation holds good. difference it should be the same windows

account or the domain account. LocalAdministrator account wont work.

Should be domain account.And the domain account should be...

Hi muthu,

i thought of posting it in sql 2000 only. it was my bad!

do u know how to do it in 2000?

Please check the authentication mode under security. For all the linked servers, it should be Mixed mode. if the below error is logged in windows application log,

SSPI handshake failed with...

If on sql authentication:

Then the same user id and password are passed to the remote server.

with the same id and pwd one can login to the remote server then your...

AS means Analysis Services?

By using manual drop and create index script!

SQL Server version 2000.

Hi,

I can find the deprecated features in the below url

http://www.microsoft.com/sqlserver/2008/en/us/white-papers.aspx#appdev

Thank you Gila!

Thanks Barry.

New thing i came to know. We can try with stored procedure with OUTPUT parameters. Right?