(William Pearson) This article focuses on a topic that in many ways is akin to our last, Extend Access with Pass-Through Queries, in that it is based upon the use of “SQL specific” or “direct SQL” within MS Access. While we have also treated the use of SQL specific queries in other articles, our wor

On a computer that is running Microsoft SQL Server 2000 Reporting Services, if you change the user account that you use to run the Report Server service, and then you restart the Report Server service, you may notice a behavior that is similar to the following.

When you use a dynamic snapshot for merge replications, the dynamic Snapshot Agent may fail. Additionally, you may receive an incorrect syntax error message that is similar to the following: SourceTypeId = 5 SourceName = MyMachine ErrorCode = 156 ErrorText = Incorrect syntax near the keywo

(Michelle A. Poolet) The next release of SQL Server, SQL Server 2005, will contain many features and extensions to make you more productive, especially if you’re doing database-driven Web-application development. However, Microsoft has delayed the final release of SQL Server 2005 until the first

(James Travis) Don’t jump the gun before you read. First let’s discuss security at the personal level. Many folks forget that the biggest threat is not outside their company but inside. They walk away from their desk and forgetting to 3 finger salute and lock the desktop. While they are away a

(Don Schlichting) Transact SQL statements are usually executed in sequential order. When a long stored procedure or statement is created, line 1 will run, followed by line 2, followed by line 3. In many cases, we will want to interrupt this normal flow. Special processing may be needed depending

Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) is the compact database for rapidly developing applications that extend enterprise data management capabilities to devices. This article discusses questions and answers for frequently asked questions (FAQs) about SQL Server 2000 Windows

Today’s business critical applications and customer requirements demand high-availability of company data. Database Administrators (DBAs) are challenged to make the database systems available 24×7 and provide fast database response time. Utilizing a standby server provides a high level of data prote

When two computers that are not running in the same domain use Microsoft Distributed Transaction Coordinator (MSDTC) for communication and for distributed transactions, the mutual authentication may fail. When you run a distributed transaction against a linked server in Microsoft SQL Server 2000

(Joseph Sack) This article explains how to create a DTS Package that performs the following tasks: –Deletes existing rows from the Excel Spreadsheet –Populates the spreadsheet with SQL Server data –Emails the attached Excel spreadsheet using ActiveX and CDO (R)