When the “Log Shipping Alert Job – Restore” job runs in Microsoft SQL Server 2000, you may receive an error message that resembles the following: Msg 14421, Sev 16: The log shipping destination SecondaryServerName is out of sync by NumberOfMinutes minutes

(Brett Burch) This is something that might be obvious, but I thought I would mention this because it wasn’t obvious to me. As I have mentioned earlier, I prefer stored procedures, but recently found myself in a scenario where I had to use inline SQL. I will avoid the “why” discussion and get to the

(Jayaram Krishnaswamy) There are certain situations in which you might have to access data that is stored in various locations. In this case, you might want to use a linked server on SQL 2005 to access data from a Microsoft Access database. This article explains how to set that up.

(Tim Chapman) In a recent article, I demonstrated how to catch errors in SQL Server 2000. The most significant aspect of error handling in SQL Server 2000 is the @@ERROR variable. You must query the value of this variable after every statement execution to ensure no error has occurred that would req

When you try to insert rows into a Microsoft SQL Server 2000 database, one or more of the following problems may occur: • The transaction takes longer than expected to finish. • Other transactions that insert rows do not take longer than expected to finish. • Error messages that have error co

(William Pearson) As administrators of enterprise reporting systems can attest, management of the business intelligence solution does not end when we deploy / publish the reports to the Report Server. Within Reporting Services, many properties and options can be set and maintained at the Report Serv

When you try to print a snapshot of an archived report in Microsoft SQL Server 2000, the latest report in the archive is printed instead of the snapshot of the archived report. This problem occurs when you click Print on the report.

(Chris Le Roy) Microsoft Access databases have certainly become more prevalent over the last 2 years as large corporations break the imposed ban on using the tool. Many of our large corporate clients and government clients have stymied development in Microsoft Access for varying reasons which can in

SQL Server Data Mining has a powerful associative prediction model allowing for easy creation of predictions based on, for example, shopping cart contents. These predictions can easily be implemented using the PredictAssociation function on a model* like the one below.

(Bob Beauchemin and Dan Sullivan) Whether you access data from the client, middle tier, or server, when you’re using SQL Server and the .NET Framework, you use the SqlClient data provider. Your data access code is similar regardless of its location, but the .NET Framework 2.0 version of SqlClient co