Print Page | Close Window

Automatic SQL Server DB Operation

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=29556
Printed Date: 28 November 2022 at 2:51pm
Software Version: Web Wiz Forums 12.05 - http://www.webwizforums.com


Topic: Automatic SQL Server DB Operation
Posted By: AlexW
Subject: Automatic SQL Server DB Operation
Date Posted: 21 July 2011 at 5:24pm
Hi,
I want to purge data automatically from my SQL DB hosted on WebWiz.  Think the best way would be to create a stored proceedure, can I set a task from the 'myLittleAdmin' section that manages the database to run this SP say every 30 days?
 
Would there be a better way of going about this?
 
Cheers,
Alex
 
 



Replies:
Posted By: WebWiz-Bruce
Date Posted: 21 July 2011 at 6:39pm
myLittleAdmin is simply a database editor allowing you to create, edit, and delete tables and stored procedures in a database, it's not able to automatically run anything.

I would suggest the best way would be to manually call a stored procedure or clean out the database once a month and then shrink the database to free up the empty space to allow it to be reused.


-------------
http://www.facebook.com/WebWiz" rel="nofollow - Find Web Wiz on Facebook
http://twitter.com/WebWizUK" rel="nofollow - Follow Web Wiz on Twitter



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.05 - http://www.webwizforums.com
Copyright ©2001-2022 Web Wiz Ltd. - https://www.webwiz.net