摘要：Here are some guidelines for database size, object number and naming limitations contrasted across Access 2000/XP, SQL Server 7.0, SQL Server 2000, and MSDE 2000. The main reason for this chart was to answer the question "how many rows can I get into a table?" -- which doesn't have a direct answer, but is limited by many of the variables listed below (not to mention disk space!). 阅读全文

摘要：This was going to be chapter 13 of a book that we pulled. Since I have no interest at this point in writing another intro level 7.0 book, you can enjoy it out here. Perhaps one of the more compelling hands-off administration abilities of SQL Server is the SQL Mail capability. SQL Mail lets you send, receive and process mail from within SQL Server. The most common use of this is setting up the SQL Agent process to alert you to server conditions. Since many wireless devices (phones, pagers, e 阅读全文

摘要：一场虚惊 昨夜回了办公室，无意中发现“一卡通”系统的主数据库被莫名其妙的“置疑”了！天～～～M$的SQLServer怎么会这么恐怖啊？完全不知道发生了什么事！下午都还好端端的！我故作镇定，删掉这个数据库又重新附加一次——my god！报错！！我又新建一同名数据库，然后停止数据库服务，用原来文件替换新建的数据库文件，再启动数据库——my god！还是“置疑”！！慌忙中，我匆匆查看backup文件... 阅读全文