Truncating MS-SQL server table

anirow

anirow

@anirow-Xw572v • Oct 26, 2024
Any body having any idea on how to set up a sql server database table for automatic truncation i mean it should be automatically truncated every day?
Like 0 Replies 3

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

Sign up Log in

CrazyEngineers powered by Jatra Community Platform

  • slashfear

    slashfear

    @slashfear-tSWzpz • Mar 15, 2011

    Hi anirow,

    Yeap it is possible!! you have to use JOB SCHEDULER which is supported in MSSQL, Just google it and you will find lot of tutorials for helping you how to use job schedular in mssql (I have used it only in sybase 😔 )

    Hope this helps!!

    -Arvind
  • anirow

    anirow

    @anirow-Xw572v • Mar 16, 2011

    Thanks Arvind! this was what i was looking for.
  • slashfear

    slashfear

    @slashfear-tSWzpz • Mar 17, 2011

    No Prob dude!! 😀



    -Arvind