Database

IF @@SERVERNAME <> 'Server1'
  BEGIN
      EXEC SP_ADDLINKEDSERVER
        'Server1'

      EXEC SP_ADDLINKEDSRVLOGIN
        'Server1',
        'False',
        NULL,
        'userX',
        'passwordX'
  END

go

DECLARE @mode VARCHAR(1);
DECLARE @orderNum INT;

SET @orderNum = 1338464;
SET @mode = 'R' -- set to 'R' for Report or 'U' for update
BEGIN TRANSACTION

DECLARE @sourceName VARCHAR(8);
DECLARE @okay CHAR(1);
DECLARE @user VARCHAR(20);

SET @sourceName = 'liveDB';
SET @user = SYSTEM_USER;

CREATE synonym sourcesummary FOR [Server1].[liveDB].[dbo].[order_summary];
SET @okay = 'Y'

IF @okay = 'Y'
   AND @@SERVERNAME = 'Server1'
  BEGIN
      SELECT 'Cannot execute on live server - retry on the sever hosting the db that is to be copied to' [error]

      SET @okay = 'N'
  END

IF @okay = 'Y'
   AND NOT EXISTS (SELECT order_num
                   FROM   sourcesummary
                   WHERE  order_num = @orderNum)
  BEGIN
      SELECT 'Unable to find order' [error],@sourceName [source db],@orderNum [order number];

      SET @okay = 'N';
  END

IF @okay = 'Y'
  BEGIN
      IF EXISTS (SELECT order_num
                 FROM   order_summary
                 WHERE  ordr_num = @orderNum)
        BEGIN
            PRINT 'deleting order_summary:';

            DELETE order_summary
            WHERE  order_num = @orderNum;
        END

      BEGIN

	  PRINT 'copying order_summary:';
          INSERT INTO order_summary
          SELECT [order_num],[order_date], etc, etc, etc...
          FROM   sourcesummary
          WHERE  sourcesummary.order_num = @orderNum;
      END

	  PRINT 'retreiving copied order_summary:';
      SELECT 'copied' [order_summary],*
      FROM   order_summary
      WHERE  order_num = @orderNum;
  END

DROP synonym sourcesummary;

IF @mode = 'U'
  BEGIN
      COMMIT TRANSACTION

      SELECT 'Changes have been applied to the database' [notice]
  END
ELSE
  BEGIN
      ROLLBACK TRANSACTION

      SELECT 'All changes have been rolled back' [notice]
  END 

Msg 15028, Level 16, State 1, Procedure sp_MSaddserver_internal, Line 89
The server 'Server1' already exists.
deleting order_summary:

(1 row(s) affected)
copying order_summary:

(1 row(s) affected)
retreiving copied order_summary:

(0 row(s) affected)

(1 row(s) affected)

my query is
<pre lang="SQL">create proc sp_emprecord
as begin
select * from employe
end
      begin try
      execute sp_emprecord
      end try

      begin catch
      select
      error_message() as errormessage,
      error_number() as erronumber,
      error_state() as errorstate,
      error_procedure() as errorprocedure,
      error_line() as errorline;
      end catch</pre>

SELECT AED.ObjectName,
       AED.ObjectCanonical,
       AEM.EventMessage,
       AED.OrganizationalUnit                               AS DirectoryOrganizationalUnit,
       AET.UserName,
       AET.SeverityID,
       AET.TimeDetected,
       AET.ValueOld,
       AET.ValueNew,
       ECS.SubsystemID,
       ISNULL(ECS.CustomEventClassName, ECS.EventClassName) AS EventClassName,
       ISNULL(TSR.ServerName, TWP.MachineName)              AS ServerName,
       EAN.ActionName,
       ISNULL(TDN.DomainName, TWP.WorkgroupName)            AS DomainName,
       AET.ResultID,
       AET.EventID,
       ECS.ValueTypeID,
       AET.MissingOld,
       AET.MissingNew,
       AET.TimeZoneOffset
FROM   Audit.Event AS AET
       INNER JOIN [Event].Class AS ECS
         ON AET.EventClassID = ECS.EventClassID
       INNER JOIN Audit.EventMessage AS AEM
         ON AET.EventID = AEM.EventID
       INNER JOIN [Event].[Action] AS EAN
         ON AET.ActionID = EAN.ActionID
       LEFT OUTER JOIN Topology.[Server] AS TSR
         ON AET.AgentID = TSR.ServerID
       LEFT OUTER JOIN Topology.Domain AS TDN
         ON TSR.DomainID = TDN.DomainID
       LEFT OUTER JOIN Topology.Workgroup AS TWP
         ON AET.AgentID = TWP.MachineID
       LEFT OUTER JOIN Audit.EventDirectory AS AED
         ON AET.EventID = AED.EventID
WHERE  AET.TimeDetected >= '2012-06-07T04:00:00'
       AND EXISTS(SELECT AET.EventID
                  FROM   [Event].Class AS _EC
                  WHERE  EXISTS(SELECT *
                                FROM   Query.EventClass AS _ECQ
                                WHERE  _ECQ.QueryID = '2E84F194-03D0-4218-A346-76C50B98E36A'
                                       AND _ECQ.ProcessID = 0
                                       AND StorageClassID = 0
                                       AND _ECQ.EventClassID = _EC.EventClassID)
                         AND _EC.EventClassID = AET.EventClassID)
       AND NOT EXISTS(SELECT *
                      FROM   (SELECT _QA.SID AS UserSID
                              FROM   Query.[Account] AS _QA
                              WHERE  _QA.QueryID = '2E84F194-03D0-4218-A346-76C50B98E36A'
                                     AND _QA.ProcessID = 0) AS _SA
                      WHERE  _SA.UserSID = AET.UserSID) 
                    
                      
                      
ORDER  BY TimeDetected DESC, 
          UserName DESC  

SELECT            AED.ObjectName, 
                  AED.ObjectCanonical, 
                  AED.OrganizationalUnit                               AS DirectoryOrganizationalUnit, 
                  AEM.EventMessage, 
                  AET.TimeDetected, 
                  ECS.SubsystemID, 
                  AET.UserName, 
                  ISNULL(ECS.CustomEventClassName, ECS.EventClassName) AS EventClassName, 
                  ISNULL(TSR.ServerName, TWP.MachineName)              AS ServerName, 
                  EAN.ActionName, 
                  ISNULL(TDN.DomainName, TWP.WorkgroupName)            AS DomainName, 
                  AET.ResultID, 
                  AET.EventID, 
                  ECS.ValueTypeID, 
                  AET.MissingOld, 
                  AET.MissingNew, 
                  AET.TimeZoneOffset 
FROM   Audit.Event AS AET 
       INNER JOIN [Event].Class AS ECS 
         ON AET.EventClassID = ECS.EventClassID 
       INNER JOIN Audit.EventMessage AS AEM 
         ON AET.EventID = AEM.EventID 
       INNER JOIN [Event].[Action] AS EAN 
         ON AET.ActionID = EAN.ActionID 
       LEFT OUTER JOIN Topology.[Server] AS TSR 
         ON AET.AgentID = TSR.ServerID 
       LEFT OUTER JOIN Topology.Domain AS TDN 
         ON TSR.DomainID = TDN.DomainID 
       LEFT OUTER JOIN Topology.Workgroup AS TWP 
         ON AET.AgentID = TWP.MachineID 
       LEFT OUTER JOIN Audit.EventDirectory AS AED 
         ON AET.EventID = AED.EventID 
WHERE  AET.TimeDetected >= '2012-06-07T04:00:00' 
       AND EXISTS(SELECT AET.EventID 
                  FROM   [Event].Class AS _EC 
                  WHERE  EXISTS(SELECT * 
                                FROM   Query.EventClass AS _ECQ 
                                WHERE  _ECQ.QueryID = 'C37D85D6-B725-4E98-A338-B8917CA5784F' 
                                       AND _ECQ.ProcessID = 0 
                                       AND StorageClassID = 0 
                                       AND _ECQ.EventClassID = _EC.EventClassID) 
                         AND _EC.EventClassID = AET.EventClassID) 
                    
                      
                      
ORDER  BY TimeDetected DESC, 
          UserName DESC