摘要：Detect SQL timeout from ASP & Issue RollbackTransI developed an application that worked fine in development and single user testing, but when multiple users starting using the application, I ran i... 阅读全文

摘要：DROP DATABASE DEMO;GOCREATE DATABASE DEMO;GOUSE DEMO;GO--the database master key is always encrypted (using triple_DES) with user-supplier password--stored in the sys.symmetric_keys; and at the same t... 阅读全文

摘要：刚才在QA环境创建SQL replication 的时候报错，大致如下：Error 14274: 无法添加、更新或删除从MSX服务器上发起的作业.导致Replication不能够成功，如按如下角本解决：For example:tsql02\d2shp01SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE GO use msdb;gobe... 阅读全文

摘要：Useful LinksMicrosoft Related Resource Linkswww.microsoft.com/sql - SQL Server Home Pagewww.microsoft.com/sql/community - SQL Server Community Pagewww.microsoft.com/sql/community/newsgroups - SQL Serv... 阅读全文