Hi All We are currently using RealSecure 6.5 with the event collector database on MSDE. Due to the size restrictions of MSDE it is necessary to periodically "make room" in the database. I know how to purge, clear and shrink the database but I would like to know how to delete specific events on specific sensors from the event collector database. I have been given the following SQL query: Delete from events where (SensorName="XX_Srv" and OrigEventName = "Use_of_user_rights") But I am not sure if this will have a negative effect on the database and the relationships between the tables. Will there be remnants of this event in other tables? Does anyone have any experience of this? Any help would be much appreciated, Thanks
Andy ********************************************************************** This email is privileged, confidential and subject to copyright. Any unauthorised use or disclosure of its content is prohibited. The views expressed in this communication may not necessarily be the views held by Scottish Borders Council ********************************************************************** _______________________________________________ ISSForum mailing list [EMAIL PROTECTED] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo
