SQL Express - Create maintenance plan to run truncate table

  • Sorry, forgot to update this post... First thing first i was typing sqlcmd -s, it should be upper case -S servername\instancename. I first created a stored procedure to backup the databases, then scheduled a task to run a batch file executing the stored procedure. Thank you all for your help.

    Lava

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply