modified above code

SET NOCOUNT ON

IF (OBJECT_ID ('tempdb..#RegResult')) IS NOT NULL

DROP TABLE #RegResult

CREATE TABLE #RegResult (ResultValue NVARCHAR(4))

IF (OBJECT_ID ('tempdb..#ServicesServiceStatus')) IS NOT NULL

DROP TABLE #ServicesServiceStatus

CREATE TABLE #ServicesServiceStatus(RowID INT IDENTITY(1,1),ServerName NVARCHAR(128),ServiceName NVARCHAR(128),ServiceStatus VARCHAR(128),StatusDateTime...

I tried as you said ,but i am getting error msg "server already exists"...

[Jim].[dba].[Murphy] (3/3/2011)

---

Since this is a sql2005 forum, I'll assume that you are attempting to use sql2000's Enterprise Manager to connect to a SQL 2005 instance of SQL server. This can...