If you run a Multidimensional Expressions (MDX) query for a connection to a SQL Server 2000 Analysis Services server computer, and the Cache Policy connection property’s value is set to 7 when the connection is established, the Analysis Services service may shut down.

(Andrew Novick) CRUD: A coating or an incrustation of filth or refuse. That’s the American Heritage dictionary definition but not the database definition. When you are working with databases, CRUD is an acronym for the four essential database operations: Create, Read, Update, and Delete.

(Baya Pavliashvili) Contrary to popular belief, replication is not maintenance-free. As your application and business rules change, so do publications. This article dissects the terms and techniques necessary for maintaining transactional replication and gives you sage advice on fine-tuning your rep

(Kalen Delaney) Recently, I’ve been discussing security in SQL Server 2000. In my February column, “Crossing the Line: Ownership Chains” (InstantDoc ID 40963), I talked about the limitations of ownership chaining and the additional security concerns inherent in cross-database ownership chaining.

(livebet) Almost every enterprise development I have done or seen begins with design and definition of the data-base. Even when the system was developed using pure OO methodologies, coding begins with the database. Recently, whenever I have told my developers to develop the enterprise such that

(Vinod Kumar) This is an interesting subject to discuss. I’ve not been a big supporter of what happens in our error handling in SQL. And there are quite a lot of void spaces that needs to be addressed in the SQL documentation for the same. Here are some of the tips you can use in your application co

(Bruce Szabo) In my last article, A DTS Data Store I discussed a method for collecting DTS packages from a variety of servers and storing them in a single database. This technique allows one to capture all of the packages from a variety of servers and then store and use them from a single source. Us

(Marcin Policht) In the previous article of this series, we looked into authentication mechanisms used to determine validity of credentials specified by a user connecting to a SQL Server 2000. Now, we are going to explore another topic related to authentication, but on a different level – SQL Se

(J. Ambrose Little) This article briefly covers the implementation of two types that can be used to bind list controls, such as the DropDownList, in a strongly-typed manner to a SQL Server data source using stored procedures. I think the main application of this concept, as demonstrated by the

In enhancing existing management tools and designing new ones for SQL Server 2005—formerly code-named Yukon—Microsoft’s SQL Server Tools team followed two guiding principles: “no secrets” and integration. Euan Garden, product unit manager for SQL Server Tools for SQL Server 2005, tells SQL Server Ma