SQL Server :: Auto Delete Of Data From Database After A Fixed Time Interval?

Jan 11, 2011

I am using sql server 2005. In my project i wanna auto delete the data from the database after a fixed interval of time say (30 days); Is there any automatic process to delete the data from the database without the user intervention..

View 19 Replies


Similar Messages:

WCF / ASMX :: Fetching Data After Every Fixed Interval?

Oct 18, 2010

I have a webservice which needs to query the Database every hour to get the latest copy of the data. What would be the best way to have the websevice call a method every hour. I am condering using the imers.Interval to call a method every hour.

View 3 Replies

SQL Server :: How To Add A Fixed Value To Auto-increment Primary Key

Jan 1, 2011

If its posible I want to create a table with a primary key with auto-increment and a fixed value to differentiate the table from others tables

ex:

table 1 | table 2
ID | ID
----------|-----------
a1 |b1
a2 |b2
a3 |b3

View 6 Replies

SQL Server :: XML With PrimaryKey Values To Delete Rows In Database Table At A Time?

Oct 25, 2010

I'm having a gridview in my aspx page with checkbox, User can select one or more than one record(s) at a time and clicks on delete button, Then i'm constructing an object of my DTO and adding all the checked row's Primary Key (DataKeyNames - GUID's in case) to a serializable class and generating an XML and sending it as parameter to the Stored Procedure.

My Doubt is, can i bulk delete all the rows from database table those are present in my XML document??

If it works, I can do bulk update with XML only, i already did bulk insertion by generating an XML..

My Another Question is, Will it affect the performance? Each time when i construct an DTO object and adding it to the Generic List??

WHich one is better, I mean ObjectDataSource or SQLDataSource or my XML method?

My XML will be like this

<root>
<Customer>
<CustomerID>GUID1</CustomerID>
<CustomerID>GUID2</CustomerID>
<CustomerID>GUID3</CustomerID>.....

View 4 Replies

Web Forms :: How To Auto Delete And Auto Create Table Data

Jun 6, 2010

I have a simple online web system where it possible for the visitors to "play around" with the system. They can like create categories and products and so forth. Everything they create are stored into a database.

What I want is to be able to reset this database with my default values (table data) every n hours.

So for example if we have a bunch of users that have played with the system and created new things. Then I want to be able to make some kode that deletes all data in the tables in this database and fill it with default data. The default data can come from a backup file, or another database with same tables structure or whatever.

I want this task to be done every day at 12 pm or every n hour.

Is this possible (by forexample scheduled webservice tasks or just something as long as it is simple).

View 8 Replies

C# - How To Calculate The Total Data Download And Upload In A Particular Interval Of Time

Jun 25, 2010

I want to calculate the total data download and upload in a particular interval of time, and store it to a database so that it can be viewed later on. Thus, this particular user logged in at this time and downloaded and uploaded this much data.

I want to do this in C#.

View 2 Replies

Auto Refresh Webpage After Defined Interval?

Aug 20, 2010

In one of my website, i required to implement automatic refresh of webpage after 15 minute.

For this to achive i have write following line of code <meta http-equiv="refresh" content="60;url=" />

But i am facing one problem that after this duration of 15minute page will refresh as a new page load.

At my page i have used combo box having city list, there is a case when i select an item from this list at index 3. After that i just make page idle and after 15 minute page is refresh with the script i write for auto post back (mentioned above). But the problem is that due to this page is reload as a new page and code inside (!PostBack) execute which refill combobox and reset at index 1. My basic requirement is that whenever user reaches that page and makes it idle for longer time, session should not expire and hence i am writing above script so that session would be live.

View 3 Replies

Web Forms :: How To Open A Popup Window Automatically At Some Time Interval Of Time

Sep 3, 2010

in my application i need to generate/open a popup window automatically at some interval of time, when the user is working at some page in the application, like a alert message

the popup window contains some information which should take from the database,

and the information should be updated automatically when the popup window opens,

i am developing my application with c#.

View 3 Replies

Forms Data Controls :: Fill The Gridview Column With A Time Interval Values?

May 26, 2010

I need to create a scheduler for a hospital appointment screen.. i am taking a time interval value and doctor schedules from MyDb. I want to fill the gridview based on the doctor's schedule timings and interval....

for Ex;

if Doctor A .

Time schedule is 09:00 Am - 09:40 AM && 10:00 Am - 11:00 AM

time interval is 20 minutes

i need to show the grid like this ....

09:00 AM

09:20 AM

10:00 AM

10:20 Am

10:40 AM

11:00 AM

View 6 Replies

Web Forms :: Update Database Data After Particular Interval?

Dec 30, 2010

we have to upgrade a database application.

In the previous application the transaction is updated 2 days later into the database.

Now we have to update that instantly when the transaction happens.

How this is possible. I want to know why the database update too late

View 4 Replies

MP3 Uploading With Time Interval Selection?

Sep 9, 2010

I am writing a music related web site. What I am trying to do is have the user upload a song (MP3, MP4, Wav). I then want to be able to slice the song to a max lengh of 30 seconds. The user would be able to select a starting point and I would cut the song down to 30 seconds from that point.

View 1 Replies

Web Forms :: How To Refresh A Page Automatically In A Time Interval

Jul 26, 2010

I have a forum area on my website and i would like to make forum main page in such a way that it should refresh itself every 2 minutes. How i can accomplish this ?

View 8 Replies

Web Forms :: How To Rotate Images After A Specific Time Interval

Apr 13, 2010

i need to rotate images after a specific time interval and images coming from Database.

my main problem is that i am not allowed to use ajax or ajax toolkit for performing this function. and i don't know how to do that without ajax?

the way by which i rotate the image with out ajax

View 2 Replies

Social Networking :: How To Drop Google Markers One By One After Specific Interval Of Time

Apr 30, 2013

I have written the following code to display multiple markers in google map and i succeeded in it.Now i want to have a drop animation applied to markers and want to drop marker after a specific interval of time.I know i want to call setTimeout method ,but don't know where to call this method to achieve the result

<script type="text/javascript">
window.onload=function(){
if(markers.length>0){
var mapOptions={
center:new google.maps.LatLng(markers[0].lat,markers[0].lng),

[Code] ....

View 1 Replies

Web Forms :: Repeat Task (Birthday Email) Every N Interval (specific Time)

Jan 24, 2016

How to Automatically send  birthday emails daily at specific time using in global.asax in asp.net without using windows services.

Firstly  check and fetch all records of Students who have a Birthday today ....

View 1 Replies

Web Forms :: Execute Method Or Event Automatically After Certain Period Or Time Interval?

Jul 29, 2012

I have Website Application , in which i have method ..i want to execute this after every 10 days  automaticlally ..what is the concept of doing this , provice some code etc. if possible ..

my method includes some server side processing..

View 1 Replies

Auto Generate Number In Asp.net Which Is Auto Add In Sql Server Table With Other Data?

Mar 25, 2011

I have project in asp.net with sql server backend.i want to auto generate a number for particular column.with the auto generated number i want to insert some other data in the same row same table. on button click event.details

railway PNR no.:- want to autogenerat
passenger details:- want to inserted simultaneously

View 2 Replies

SQL Server :: DataBase Error When Attach An Auto-named Database For File?

Oct 6, 2010

I m trying to save files like pdf, word, excel etc... into sql express, but m getting this error in my web page:An attempt to attach an auto-named database for file C:Usersmalek.safaDocuments est vbSavingFileInDBSavingFileInDBApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
m not getting errors inside my code, just this one appearing on the web page.

View 2 Replies

SQL Server :: Insert Large Amount Of Data In Sql Server 2005 Database With Every Time Duplicate Check?

Feb 6, 2011

I want to generate 30,000 cards and each card must be duplicate check with database. In my card, there are 2 things. Serial No and CardID. If any card already exists then I generate another card id but with the same serial no.

So how faster way I can generate 30,000 card with duplicate check? Which one I have made application, it takes about 25 minutes to insert.

View 33 Replies

Forms Data Controls :: How To Delete An Auto Generated Column From A Gridview

Feb 1, 2011

I am currently working on a module in which I am creating an auto generated column gridview, and I have set the Auto generate edit button field to true. What happens now when I click the edit button The primary key field is turned in to edit mode which I want to restrict from being updated.

To restrict the same I have hard coded a template field which holds that column, But as I have set the AutoGenerateColumns Property to true the gridview automatically creates a duplicate field for holding the primary key column. For which I want to delete that particular column.

My Designer Code is:-

[Code]....

in page load I am binding the grid view.

Even I have tried to hide that column doesn't make any difference for me.

View 10 Replies

SQL Server :: Set Auto Expired For Records In Database?

Jan 13, 2011

I have a table which stores records about a promotion programs. For each record, there are different status such as Begin, Successful, Unsucessful, Expired and there are PromotionDate and PromotionExpiredDate. I am just wondering how I can set each promotion to auto expired (auto change the status of each promotion status to Expired) when the current date is bigger than the PromotionExpiredDate.

View 4 Replies

Web Forms :: Caching After Fixed Time Automatically Using Any Tool

Jan 15, 2013

Is there any tool or way by which we can cache our pages after fixed time automatically  instead of user to click link and then cache on server.

View 1 Replies

SQL Server :: How To Auto Increment Alphanumeric Primary Key In Database Table

Sep 30, 2010

auto increment alphanumeric primary key(eg :ABC001) in sql server 2005 database table.

View 2 Replies

Run A Webpage At Particular Interval In Host Server?

Mar 15, 2011

I have one question that is i have to run one program in host server at a particular interval (lets say in each & every 1 hour).

But the thing is that in host server we can't run scheduler , so i want to know is there any approach by which we can achieve this task.

View 6 Replies

Forms Data Controls :: How To Remove Auto Generated Columns Of Gridview At Run Time

Mar 2, 2011

i am using asp.net 4.0

i want to remove Auto Genrated Columns of Gridview at Run Time and change the header text of these columns.

[Code]....

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved