(Serdar Yegulalp) SQL Server 2000’s two key programs — the actual SQL Server and the SQL Server Agent — typically run as services in the Local System user context. When SQL Server users access operating system features, usually through SQL Server’s SA login, access is performed in the context of t

When you run an application that creates Microsoft COM objects by using the sp_OACreate function within Transact-SQL code, Microsoft SQL Server 2000 or Microsoft SQL Server 7.0 may stop responding (hang). Additionally, the following error message may be logged in the SQL Server error log: Error:

(Adam Machanic) Imagine for a moment that you’re a SQL Server 2000 production DBA (unless, of course, you are). You arrive at the office one morning, get a hot drink and check your e-mail. There are two new co-worker requests in your inbox: Bob in purchasing needs read-only access to all of the sale

(Eric Bruno) Most software applications require a persistence layer, such as a relational database, to store user data for later retrieval. As a Java developer, you have many choices for your application’s persistence layer. You can use entity beans with either container-managed persistence (CMP

Twenty-four new webcasts are scheduled for October, covering such topics as SQL Server 2005 Reporting Services, SQL Server 2005: Facts and Features, A Primer to Proper SQL Server Development and more.

(Ron Plew and Ryan Stephens) Sams Teach Yourself SQL in 24 Hours, Third Edition presents the key features of SQL (Structured Query Language) in an easy to understand format with updated code examples, notes, diagrams, exercises, and quizzes.

(Steven Warren) SQL Server 2000 contains a powerful set of tools called Data Transformation Services (DTS) that can help you import, export, and/or transform data from various sources to single or multiple locations.

(Arthur Fuller) This SQL Server tip demonstrates that you can deliver "unusual" sort orders, as long as you can describe their rules. The author says the trick isn’t in the code but in the accurate and complete description of the rules.

(Mamta M) This article describes the process to add and retrieve images from a SQL Server table using ADO.NET. You can possibly have an entry form that will allow the user to choose what operation he wants to do: add or view images. Depending on the option chosen you can display the relevant form.

(Terry Voss) ClickOnce Deployment is a setup capability that is built into your Windows Forms project. In Visual Studio 2005, select Project Properties from the Project menu, and click on the Publish tab. From there, after specifying a few things, you can publish to a web site or other location that