(Teo Lachev) In Part 1 of this series, you learned that, by default, the Report Server uses Windows-based security to authenticate and authorize incoming requests based on the Windows identity of the interactive user. While Windows-based security works well for intranet applications, it is usual
Tag: sql server
Get All the Stored Procedure Names In One Shot
(Jaya Nehru Kumar) The following query will list all the stored procedure names available in the current database.
How To Configure SQL Mail to Work With GroupWise
(Chris Sheperd) This document walks through how to configure SQL Mail for Microsoft SQL Server to work with Novell GroupWise. For the purpose of this document I will refer to the user account as sqluser and the password as sqlpassword.
What’s In Your Database? Find Out with the Schema API in ADO.NET 2.0
(Alex Homer) Most data access technologies provide a way for you to query the schema of a database, and obtain information about the tables, stored procedures, data types, users, and other content of a database. However, the technique varies depending on the data provider or database driver you are
Rebuilding SQL Server Cluster Nodes
(Muthusamy Anantha Kumar) Active/Passive SQL Server 2000 clustering gives more reliability and fault tolerance to Production SQL Server environments. When a failure occurs, all of the resources fail over from the active node to the passive node and make the passive node active. This article expl
Moving System Databases – A Checklist
(Christoffer Hedgate) Moving a database in SQL Server is normally as simple as detaching it from the server, moving it to it’s new location and then attaching it again. However, that only counts for user databases. Moving system databases requires quite a bit more work. Since I had to do this a
ADO.NET and System.Transactions
(John Papa) The Microsoft .NET Framework versions 1.0 and 1.1 represented major changes in software development. However, one important thing that did not change much was support for distributed transactions. All of that is about to change because the .NET Framework 2.0, which includes a new namespa
Finding and deleting duplicate rows from a table
(Serdar Yegulalp) Large table rows should each have distinct values — but what do you do if they don’t? For instance, if data is imported from another source and not properly screened, you may notice duplicate values among rows instead. Duplicate values also crop up when a table that previously had
FIX: You cannot create new TCP/IP socket based connections after error messages 17882 and 10055 are written to the Microsoft SQL Server 2000 error log
The following issue is fixed in this Microsoft SQL Server 2000 hotfix package: • You experience all the following symptoms on a computer that is running Microsoft SQL Server 2000: • You cannot connect to SQL Server 2000 by using a TCP/IP socket based connection after error messages 17882 and 10055
Using a Subquery in a T-SQL Statement
(Gregory A. Larsen) Sometimes the criteria for determining which set of records will be affected by a SELECT, UPDATE, DELETE and/or INSERT statement cannot be obtained by hard coding the selection criteria. Occasionally there is a need to use the results of a SELECT statement to help determine which