My picture album
My code library
Search my site
SQL Server Articles New
NEW!!! Subscribe to my
|Want to keep in touch with the
latest in SQL Server world? Email firstname.lastname@example.org with
'subscribe' in the subject line
Struggling to keep an eye on the latest SQL Server Knowledgebase articles from Microsoft? Don't have time to visit the knowledgebase everyday and look for new articles? Don't worry, this page is just for you! It lists all the interesting, useful and important KB articles from Microsoft website and it gets updated every couple of days. Just bookmark this page and enjoy reading all the latest articles from Microsoft.
Updated: 4th August 2002
HOW TO: Pass a Variable to a Linked Server Query (Q314520)
This article describes how to pass a variable to a linked server query. When you query a linked server, you frequently perform a pass-through query that uses the OPENQUERY, OPENROWSET, or OPENDATASOURCE statement. You can view the examples in SQL...
BUG: SQL Server Virtual Server Setup Fails and You Receive an Error Message (Q324305)
Setup for a Microsoft SQL Server 2000 virtual server may fail and you receive the following error message: Only one usage of each socket address (protocol/network address/port) is normally permitted.
INF: SQL Server and Striped Backups (Q325334)
With striping, you can back up a database to different disks either to increase backup throughput or to distribute space usage across different disks. However, the files may or may not be evenly distributed.
HOW TO: Create Patch Files (Service Packs) for the MSDE 2.0 Sample.msi File (Q314131)
This article describes how to create a patch file for Microsoft SQL Server 2000 Desktop Engine (MSDE 2.0) named Sample.msi. Sample.msi is a sample package that is included with the Development tools of SQL Server Standard, Enterprise, and Developer...
FIX: Registered Remote Servers Disappear from SQL Enterprise Manager in Windows XP When Non-Domain User Password is Changed (Q323280)
In Microsoft Windows XP, if a non-domain user changes the password for their Windows XP logon account, any remote registered servers in SQL Enterprise Manager (SEM) may be removed after the user logs off of Windows XP or restarts the server and then...
MS02-039: Buffer Overruns in SQL Server 2000 Resolution Service Might Enable Code Execution (Q323875)
SQL Server 2000 introduces the ability to host multiple instances of SQL Server on a single physical computer. Each instance operates for all intents and purposes as though it was a separate server. However, the multiple instances cannot all use the...
PRB: An XLOCK Hint in a Serializable Transaction May Be Ignored (Q324417)
If you issue a SELECT query with an XLOCK hint in the context of a serializable transaction, the X KEY lock is not honored by other connections that try to read the same record (or records).
BUG: BULK INSERT Fails with Error Message 7399 (Q324122)
A BULK INSERT operation may fail with error message 7399 if the size of the input file is 65536 bytes or a multiple of 65536 bytes (for example, 3473408 bytes). The error message that you receive is: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error. The statement has been terminated.
FIX: Parameterized Query with Several IN Clauses Fails with Error: 8623 (Q325658)
When SQL Server runs a parameterized query that contains several IN clauses, each with a large number of values, SQL Server may return the following error message after a minute or more of high CPU utilization: Server: Msg 8623, Level 16, State 1 Internal Query Processor Error: The query processor could not produce a query plan. Contact your primary support provider for more information.
Updated: 17th July 2002
FIX: Infinite Loop During Full-Text Catalog Population (Q323038)
SQL Server allows full-text population of documents that are stored in the database through filter DLLs that can interpret the document file format and expose the data through the IFilter interface. If the data that is being indexed includes documents with unusually large property sections (more than 16 KB), the full-text search (FTS) gatherer process may become stuck in an infinite loop.
Updated: 14th July 2002
HOW TO: Troubleshoot SQL Server Error 8645 (Q309256)
This step-by-step article describes how to troubleshoot SQL Server error 8645 (A time out occurred while waiting for memory resources to execute the query. Re-run the query.). You may receive the error 8645 when there is a high server workload or when the servers are experiencing high memory pressure.
FIX: Service Pack Installation May Save Standard Security Password in File (Q263968)
If you use SQL Server Authentication, also known as Standard Security, to install SQL Server 7.0 or SQL Server 2000, the system administrator ( sa ) password may be stored in clear text, or in an encrypted readable format in the SQL Server 7.0 and SQL Server 2000 setup files.
HOW TO: Create a Database, a Table, and Run a Query (SQL Server CE Sample) (Q320785)
This article contains a step-by step sample that creates a database, a table, and that adds records to a SQL Server CE database. The sample also queries the new table and displays the records in the table.
FIX: The Distribution Agent Shuts Down and Error 2627 or Error 2601 Are Generated When You Apply a Command to a Queued Updating Subscriber (Q323545)
The Distribution Agent shuts down and SQL Error 2627 or SQL Error 2601 are generated.
FIX: The Replication Queue Reader Agent Utility Shuts Down After Error 2601 Occurs (Q323550)
When the Replication Queue Reader Agent utility applies a change to the publisher, it shuts down if a duplicate key violation error (Transact-SQL error 2601) occurs.