declare @server as varchar(50)

SELECT @server = RTrim(ServerName) FROM master.dbo.ServerList1 WITH (nolock) WHERE ServerName = @server

print @server

Insert Into dbo.Server_Details_Table

select A.*

FROM

OPENROWSET ('SQLNCLI10', 'Server=''+ @server +'';trusted_connection=yes',

'set fmtonly off...

I Already tried with set fmt off,but still same error.

Is there any issue with global temp tables(the sp from sql 200 isntance)

i tried to execute in sql 2008 instane. is...

USE [master]

GO

/****** Object: StoredProcedure [dbo].[SP_SQL_DB_Sizeinfo1] Script Date: 10/18/2010 03:56:18 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[SP_SQL_DB_Sizeinfo1]

AS

--SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

SET NOCOUNT ON

--SET ANSI_WARNINGS OFF

--SET...