Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
SELECT * FROM OPENQUERY(MAXPROD,' SELECT DISTINCT INC.TICKETID, INC.SEVERITY, INC.VENDOR, INC.VENDORTKTNO FROM INCIDENT INC LEFT OUTER JOIN ( SELECT DISTINCT TICKETID, MIN(CHANGEDATE) AS CHANGEDATE FROM TKSTATUS WHERE TKSTATUS.CLASS = 'INCIDENT' AND TKSTATUS.STATUS IN ('RESOLVED','CAN','CLOSED') GROUP BY TICKETID) STATUSCHANGEDT ON INC.TICKETID = STATUSCHANGEDT.TICKETID LEFT OUTER JOIN WOCHANGE WC ON INC.TICKETID = WC.ORGID WHERE INC.VENDOR IS NOT NULL AND INC.CREATIONDATE BETWEEN to_date'6/24/2010','mm/dd/yyyy') AND to_date('7/15/2010','mm/dd/yyyy')) Msg 102, Level 15, State 1, Line 13 Incorrect syntax near 'INCIDENT'.
|SQL Transaction logs||8||28|
|Sql Server 2008 R2 Stored Procedure doesn't work with CTE and parameters||4||31|
|what objects could have system generated names in SQL, if names are not given.. (SQL Server)||18||110|
|How to pass a parameter to limit the colums returned in Stored Procedure SQL 2016||2||30|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!