@setiv,

I agree with what Hugo said. Just wanted to add one small info which can partially help your cause.

sp_helpextendedproc is one sp which lists all the extended sps...

Not too sure whether this one helps. But anyways thought of posting.

The SQL Service account shd be a part of Windows Adminstrative group for proxies to work. Is your Domain...

Jonathan Kehayias , the noted SQL Server MVP, whose article's link on the topic discussed has been posted above.

Both ALTER DATABASE and Detach/Attach demand a downtime.

If you are using ALTER make sure to take your database offline before moving/copying mdf/ldf. Same thing for Detach/Attach. Detach and then copy...

Can you post the table structure and insert qry and what kind of indexes you have.

With these details we will be in a better position to comment

@mahesh:

Read the links provided.

@Bhuvanesh:

Rights need not be in sync. Rights good enough to execute the query on the remote server would do.

Example:

Select * from server2.dbname.dbo.table1

If I am executing...

If its working on SQL but not on windows authentication then Please check the following.

> Have you added the windows account to the other SQL Server?

...

I have faced a similar issue when SQL Service was started with a different account.

Is SQL Service running under same Local admin account. If nt start under it and...

If your sa pwd's r different then map it explicitly as i mentioned earlier.

As I said earlier, in general, I dont like the idea of SA on linked servers

as it...

Your understanding is correct but If you read my post carefully sa password's shd be same only when you select the option

...

Security wise Windows authentication is the best bet.If thats not an option then You can have the 'login under security context' and also

specify the login and password on the Local...

login's current security mode means the following:

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...

No risks involved. Just that creating a cluster on a huge table can be quite a expensive(CPU/IO). Enusre you have enough space on the disk.

Creating a cluster on the table...

Are you using windows authentication?

Then can you check for SPN/Delegation settings are done correctly?

I dont exactly get what you are trying. But if it is smthng like Scripting the output of sp_help_revlogin for specific logins and then storing it in a specifc place...