In Microsoft SQL Server 2000, you may experience the following symptoms when you try to perform a write operation that is not logged: 1. The write operation fails, and the following error message is logged in the SQL Server error log: SQL Server Assertion: File: , line=3723 Failed Asse
Tag: sql server
Making Stored Procedures Readable
(Andrew Novick) Stored procedures can grow to be quite lengthy. I’ve created procedures that are 500 to 1000 lines or more. There are a couple of reasons for this, including the limited coding structure provided by T-SQL. In particular, the limited error handling in SQL Server 2000 forces constan
Stored procedure: Search character columns for a given string
(Brian Walker) This tip continues the system stored procedure series with a routine to find occurrences of a string in the character columns of selected tables. (R)
Minimizing the need to restore a backup
(Douglas Reilly) The second installment of this series discussed the cost of maintaining systems with various levels of downtime, ways data can be lost, and what constitutes a backup. In this installment, I discuss how to configure your hardware to minimize the need to restore a backup.
Unsupported tuning options for some editions of SQL Server 2005 CTP 16 and of SQL Server 2000
Microsoft SQL Server 2005 Books Online incorrectly lists the editions of SQL Server that are supported by the Database Engine Tuning Advisor graphical user interface (GUI) and the dta utility.
Writing Database Objects in CLR
(Sahil Malik) My previous article covered the basics of CLR integration in SQL Server 2005. It compared CLR inside SQL Server 2005 with TSQL and extended stored procedures, and discussed the judicious use of CLR in lieu of other available choices. This article takes the discussion further, discussin
When To Use SQLCLR, And When Not To
(Roger Jennings) It would be surprising if there were any .NET developers or SQL Server DBAs who aren’t aware by now that SQL Server 2005 and its Express edition support an in-process implementation of the .NET 2.0 CLR. Early Microsoft whitepapers and marketing materials promoted the capability to e
The Ntbackup.exe operation may break the differential backup chain of a SQL Server database and may invalidate the differential backups when you perform a snapshot backup of the database
The Ntbackup.exe utility uses the Virtual Device Interface (VDI) to perform a snapshot backup of a Microsoft SQL Server 2000 database. When you use this utility, the operation may break the differential backup chain of the SQL Server database and invalidate the differential backups.
FIX: You may receive a ‘Server: Msg 7358, Level 16, State 1, Line 1’ error message after you run a linked server query in SQL Server 2000 Service Pack 4
When you run a linked server query to Microsoft SQL Server 2000 Analysis Services, and the query uses the OLAP provider, you may receive the following error message: Server: Msg 7358, Level 16, State 1, Line 1 Could not execute query. The OLE DB provider ‘MSOLAP’ did not provide an appropriate
When to avoid using Enterprise Manager
(Serdar Yegulalp) One of SQL Server Enterprise Manager’s many conveniences allows users to open a table in a grid layout and directly edit the values. This is particularly handy if you need to make a quick-and-dirty change to something in a relatively small table. (R)