Have you had a look at the new DB-Management GUI available with SP3? It might just allow you to do what you want without as much effort.
Jean Paul -----Original Message----- From: [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: luned� 24 novembre 2003 18.38 To: [EMAIL PROTECTED] Subject: [ISSForum] Database backup & purge SQL script...need help -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, I'm trying to create a MS SQL Job that will backup the RealSecureDB then (if the backup is successful) it will use the iss_PurgeObs and iss_PurgeSD stored procedures to purge all data but the most recent three days. I've got the database backup working however I'm having a hard time trying to figure out how to generate the (current date - 3 days) and then passing it to the iss_Purge procedures using SQL so that only the most recent three days will stay in the database. Does anyone know how I can go about doing this? Thanks, - -Mike -----BEGIN PGP SIGNATURE----- Note: This signature can be verified at https://www.hushtools.com/verify Version: Hush 2.3 wkYEARECAAYFAj/CQGwACgkQQZjEHVM/1kBsvwCeJXAYdasWcMduFfoqxyKv8LBJoC0A n2twI/un6yWsreyibUYV1w+wxxew =SYMq -----END PGP SIGNATURE----- Concerned about your privacy? Follow this link to get FREE encrypted email: https://www.hushmail.com/?l=2 Free, ultra-private instant messaging with Hush Messenger https://www.hushmail.com/services.php?subloc=messenger&l=434 Promote security and make money with the Hushmail Affiliate Program: https://www.hushmail.com/about.php?subloc=affiliate&l=427 _______________________________________________ ISSForum mailing list [EMAIL PROTECTED] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo _______________________________________________ ISSForum mailing list [EMAIL PROTECTED] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo
