....and what does the backup application log say?

....also check the error log in the span during the MP gets executed......give us some more information to analyze the situation.....:hehe:

A summarized answer to your question - They are hierarchical access control system of SQL Server

Logins are required to access the server.

Users are required to access a database.

Schema is the...

That is correct, if the connection is through the application server's DAL, then it will be difficult.

For an overall performance tuning (if your RAM and CPU ratings are OK), run a trace on the server and save the output in a file. Then use this file...

You can check these links for further information -

http://msdn.microsoft.com/en-us/library/ms144275.aspx

http://msdn.microsoft.com/en-us/library/ms144245.aspx

http://msdn.microsoft.com/en-us/library/ms143393.aspx

You can follow the inter-links.....hope this helps

This error usually occurs when the server to which the linked server refers is stopped. Try restarting the SQL 2000 Server instance.

First of all did you use sp_dropserver to remove the server and then add the new server?

Secondly, if you are trying the operation for the local server, there might be...

In the Events Selection tab, check the Show all Columns check box, and then click on Column Filters button. Select the HostName option from the Edit Filter list on the...

you can use sp_dropserver to remove the servers already added.

use the following script to check the servers added -

select *

from sys.servers

Sorry, those are for non-sql linked servers.....

Was your test connection successful?

What do you see in the catalog?

Are you trying to see any object other than tables or views?

You can use a open query as follows -

SELECT *

FROM OPENQUERY(LINK_SERVER_NAME,'SELECT * FROM SCHEMA.TABLE_NAME')

OR

directly as follows -

SELECT *

FROM LINK_SERVER_NAME..SCHEMA_NAME.TABLE_NAME

can you enquire about the hardware config. from the relevant department?

Also, what are the access rights assigned to you?....and are you the DBA?

It is very important before starting any sort...

yes you are surely right, but to utilize the CPU, your code segment has to be there in the primary memory....the hit/miss ratio also increases the CPU usage......for each miss,...

You cannot use -

INSERT INTO #TestTable(FunctionalityID , PageCode , NameE , ControlType , ControlName )

SELECT (execute [spNavigation_GetUnAuthorizedFunctionalities] 55)

You have to use -

INSERT INTO #TestTable(FunctionalityID , PageCode , NameE , ControlType...