First, the QA’s overall usability has been enhanced. It’s easier to use, partly because more information is now readily available. For example, you no longer need to query for the current connection’s ...

In the past, the question of how to perform auditing under SQL Server has had a simple answer: Do it yourself. But now, SQL Server 2000 has eased the burden of auditing by introducing an extensive and ...

在 MicrosoftSQL Server 2000 中，分布式查询允许SQL Server用户访问基于SQL Server的服务器以外的数据(位于其他运行SQL Server的服务器或是具有OLE DB接口的其他数据源中)。OLE DB提供了统一的方式来访问异类数据源中的列表数据。 在本文中，分布式查询是指任何引用了一个 ...

1.打开NorthWind数据库，右键Products表，选择“全文索引表”，“在表上定义全文索引”，为其创建全文目录。在“全文索引向导”中，选择你需要全文查询条件的列(可以是文本或图像)，我们选择Productname和QuantityPerUnit列。然后下一步，输入一个新的目录proCatalog ...

With best-in-class ease of use on the Windows platform, Microsoft SQL Server 2000 SP2 combines strong administration abilities with leading-edge XML support. Though it's still Windows-centric, ...

The Microsoft SQL Query Analyzer is part of the client tools that come with Microsoft SQL Server 2000 Enterprise Edition. It's designed to analyze the SQL queries that you or a program makes that ...

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...