SQL Server中我想在建库后触发backup database应该怎么做?
SQL SERVER 2000\u7684backup database\u5907\u4efd\u7591\u60d1SQL Server\u7684\u5907\u4efd\u662f\u4e0d\u4f1a\u5bf9\u6570\u636e\u8fdb\u884c\u538b\u7f29\u7684\uff0c\u6240\u4ee5\u5907\u4efd\u7684\u5927\u5c0f\u4e0e\u6570\u636e\u6587\u4ef6\u7684\u5927\u5c0f\u662f\u57fa\u672c\u76f8\u5f53\u7684\u3002
\u770b\u60c5\u5f62\u4f60\u7684\u6570\u636e\u5e93\u7684\u65e5\u5fd7\u6062\u590d\u6a21\u5f0f\u4e3a\u7b80\u5355\uff0c\u4e0d\u7136\u5982\u679c\u6709\u65e5\u5fd7\u7684\u8bdd\uff0c\u5907\u4efd\u8fd8\u8981\u6bd4\u6570\u636e\u6587\u4ef6\u5927\u3002
sql\u4e0a\u9762\u7684\u83dc\u5355\u91cc
\u5de5\u5177--\u9009\u9879--\u5012\u6570\u7b2c\u4e8c\u4e2a--designers--\u770b\u53f3\u8fb9-- \u7ec4\u7ec7\u4fdd\u5b58\u8981\u6c42\u91cd\u65b0\u521b\u5efa\u8868\u7684\u66f4\u6539\uff0c\u52fe\u53bb\u6389
OK
create trigger backup_database
on all server
for create_database
改成
create trigger backup_database
on all server
after create_database
触发器会在创建数据库后运行
扩展阅读:xbox series x ... sql server 2008r2 ... sql server 2019 ... sql server能不能删 ... sql server在线编译器 ... microsoftedge浏览器 ... microsoft sql server ... sql server中begin end ... win server ...