Do you have any records in the chain table?

Does it have only a column named name?

You coud add prints inside the sp to know the values of variables.

What about

SELECT TOP 1 MIN(nativeid), FirstName, LastName

FROM Common

WHERE PArtnerID = 'ID'

GROUP BY FirstName, LastName

Did you try to fix the table?

Check DBCC CHECKTABLE in BOL. Try several times with REPAIR_REBUILD, because it may not work in the first time.

From BOL

Is the security context in which the query should be run. user is sysname. If user is not specified, the security context defaults to that of the user executing...

You also might consider linked servers.

Also run sp_who2 from QA while waiting the restore screen in EM and check if there is a process blocking it.

Check xp_cmdshell in BOL.

A quick help:

EXEC master.dbo.xp_cmdshell 'DIR C:\*.*'

I have read somewhere that the backups devices shoudn't be more than the quantity of processor you have on your server.

I know that with multiple backup devices, you have multiple...

Did you try creating an alias in the client pc, from the Client Network Utility?

Specify the ip adress in the servername and in the alias the real name of the server.

No. You will have to use EXEC ('sql'). Maybe something like this:

DECLARE @I INT,

 @a AS VARCHAR(100),

 @TableName AS SYSNAME

SELECT  @I = 1

SELECT @TableNAme = CASE

 WHEN @I = 1...

Not with stored procedures. Unfortanely, you will have to create manually the table. The columns doesn't have to have the same name as the recordset that the sp returns, but...

You can't use the Table data type in stored procedures.

But the stored procedures names should be the same. Do you have different versions of the stored procedures?

Cna give you the exact path, but I am sure that there is a script posted here.

Check http://www.sqlservercentral.com/scripts/listscripts.asp?categorynm=Maintenance%20and%20Management%20&categoryid=1

I agree that you don't need to create a table with data from your linked server, but like I thought that the problem was with that query, looked to...