On Friday the 24th, a virus that preys on a SQL Server vulnerability began to attack networks, taking down many networks. This brief network describes the virus and how to protect yourself from it.   Read more...

Why does changing a table on a SQL Server 7.0 server cause "OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time." to occur when query the table from a SQL Server 2000 server via link to other. In this article by James Travis, he shows you what the problem is and how to fix it.   Read more...

In this article by Brian Knight, he explores how to install Service Pack 1 for SQL Server 2000 and some of the catches. This service pack is one of the largest in SQL Server history. Learn what was fixed here.   Read more...

SQL Server 7 has a number of bugs that occur on multi-processor machines. This article presents a concise listing of these bugs.   Read more...

If you use performance log data and need to conduct time-sensitive analysis, watch out for this little feature in Windows 2000.   Read more...