When you use SQL Profiler in Microsoft SQL Server 2000 to audit connections to SQL Server 2000 by using the Audit Login event class, login names that contain leading zero characters are be visible in the following contexts: • The SQL Profiler graphical user interface • A trace file that is sav
Tag: sql server
Achieve Microsoft SQL Server High Availability with data replication (Sample Chapter)
(Paul Bertucci) Data replication is a powerful feature of SQL Server that can be used in many business situations. Learn how to use data replication as a high availability solution. (pdf)
SQL Server 2005 – SQL Server Integration Services – Part 13
(Marcin Policht) Continuing our discussion about monitoring execution of SQL Server 2005 Integration Services packages, which we initiated in our previous article by reviewing logging functionality, we will now turn our attention to debugging and its considerably more sophisticated capabilities.
Can We Manage SQL Server 2000 With WMI and Visual Basic.NET?
(Jagadish Chaterjee) The previous article mainly concentrated on fetching information available in SQL Server 2000. This article explains how to manage SQL Server 2000 using WMI together with Visual Basic.NET language.
SQL Server Management Studio: Don’t miss these client tool enhancements
(Adam Machanic) We’ve had seven years to get used to SQL Server’s management tools, Query Analyzer and Enterprise Manager. Although these tools have their flaws, we know our way around them. For many long-time SQL Server DBAs, firing up Query Analyzer is like coming home after a long day. Some might
FIX: You may experience concurrency issues when you run the DBCC INDEXDEFRAG statement in SQL Server 2000
When you run the DBCC INDEXDEFRAG statement, null mode page locks may accumulate on defragmented pages. These page locks may consume server resources. Then, the transactions that accumulate the locks try to escalate the page locks to table locks. The transactions escalate the page locks to try to re
Create Local Cubes with Microsoft SQL Server 2000 and Microsoft Office
(Shushmul Maheshwari) As the number of people who are conducting business from outside the corporate workplace increases, the need to access corporate databases using devices such as mobile phones and portable computers also increases.
How to store database backup media
(Greg Robidoux) To date, most backup and recovery tips talk about best practices for database backups, checklists to follow and troubleshooting backup problems. Usually this is where the discussion stops, and not much is written about what to do with all of these backup files for long-term storage.
FIX: You may not be able to capture user dump files in SQL Server 2000 Analysis Services
To determine the cause of some problems in Microsoft SQL Server, you may have to capture user dump files. However, you may not be able to capture these files in SQL Server 2000 Analysis Services.
SQL Tricks: the IN Clause…
(Brian Mains) Recently I had a large amount of data for an in clause in a SQL string. Rather than formatting each item to appropriately meet the SQL parser syntax, I used Microsoft Word instead. Microsoft Word has many functions that can assist a developer or analyst with data queries or data manipu
