 |
|
Windows Web Hosting 30 Day Free TrialWindows Hosting 30 Day Free Trial, with no obligation, on all our Windows Web and Reseller Hosting Packages.For more information see our Windows Hosting 30 Day Free Trial page. |
Automatic SQL Server DB Operation |
Post Reply 
|
| Author | |
AlexW 
Newbie 
Joined: 15 April 2011 Status: Offline Points: 12 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Automatic SQL Server DB OperationPosted: 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 |
|
 |
|
|
WebWiz-Bruce
Admin Group 
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Points: 8028 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
