This white paper describes how to use the connection pooling objects included with the Microsoft XML for Analysis Provider to develop scalable client and Web applications for Microsoft SQL Server 2000 Analysis Services. (11 printed pages)
Learn the key basics of writing quality Transact-SQL code.
Attaching and detaching databases isn't rocket science, but if you have a lot of databases to attach it's pretty boring. Andy has written some VB code that uses SQL-DMO to speed up the process. But DMO isn't the only way - can you write a TSQL script to do the same thing? Fame and fortune await!