我有一个ASP.NET MVC应用程序,它与sql Server 2008 R2 Express版本下的数据库一起使用.需要执行更新数据库中某些记录的常规任务.
@H_403_2@不幸的是,Express Edition缺少sql Agent.
你会推荐什么方法？
你会推荐什么方法？
解决方法
使用ExpressMain,它是sql Server Express用户非常方便的解决方案.
@H_403_2@ExpressMaint
http://www.sqldbatips.com/showarticle.asp?ID=27
http://www.sqldbatips.com/showarticle.asp?ID=29
@H_403_2@Project Description @H_403_2@This project@H_403_2@这两篇文章将帮助您使用它
maintains two utilities for automating
the backup and maintenance of
databases for sql Server
2005/2008/2008R2 Express Edition. They
are based on the sqlmaint application
that came with sql Server 2000 but
updated for sql Server
2005/2008/2008R2. There is a
standalone VB.NET console application
and a sql stored procedure,that
demonstrate how to automate database
backup and maintenance tasks via SMO
(sql Management Objects) or Tsql.
http://www.sqldbatips.com/showarticle.asp?ID=27
http://www.sqldbatips.com/showarticle.asp?ID=29
