After you apply the hotfix that is described in Q825042 or any other hotfix with SQL Server version 8.00.0840 or later, calls to the xp_logininfo procedure may fail with error 8198 and you may receive an error message that is similar to the following: Error: 8198, Could not obtain information abo

(Robert Marda) Multi server administration allows you to create jobs and maintenance plans once, on a server designated as your master server. All jobs and maintenance plans created on the master server can then be executed on any server enlisted as a target server to your master server. Job statu

(Brian Moran) Technology solutions have become so complex over the past few years that it’s impossible for one person to know and understand every detail of every tool that an end-to-end solution includes. Unfortunately, businesses can’t afford to maintain an army of world-class experts—a master for

This step-by-step article describes how to set up a linked server to a Sybase database server on a computer that is running Microsoft SQL Server. Additionally, this article contains basic troubleshooting steps for problems that may occur when you set up a linked server to a Sybase database server.

(Michael Otey) SQL Server has a great set of management tools—Enterprise Manager, Query Analyzer, and SQL Server Profiler are powerful and easy to use. Although these tools bring valuable benefits, they have some limitations as well. First, the tools manage only SQL Server. Second, the management to

The sp_blocker_pss70 stored procedure, described in this section, captures the following information: –The starting time (according to the computer that is running SQL Server) so that this sampling of blocking can be time-aligned with other performance information, such as a Microsoft Windows N

This article provides information about the maximum number of users and roles that you can create in SQL Server 7.0 and SQL Server 2000 databases. You can create a maximum of 16379 security accounts for a database. The maximum number of roles that you can create for a database is 16367.

(G Vijayakumar) When I started using SQL Server, I was not using the “Show Execution Plan” properly to analyse the query. I always thought that when I compose a query, it is the best it can be; I never even think of performance on my query and I did not give much importance to looking at the “Execut

When you connect to Microsoft SQL Server 2000 or to Microsoft SQL Server 7.0, and you call the SQLStatistics ODBC function, you may notice that the collation is always returned as “A” regardless of the sort order sequence. You may also notice this behavior when you run the sp_statistics system st

(Vinod Kumar) The next version of SQL Server named SQL Server 2005 is completely hyped with the integration of CLR into SQL Server. The introduction of CLR into SQL Server allows developers to write stored procedures, triggers, user defined functions, user defined aggregates and user defined types u