Programming_SQL_Server_2005.rar_sql server_sql server 2005

__________________________________________________________________ Companion Content Readme for Programming Microsoft SQL Server 2005 by Andrew J. Brust and Stephen Forte Copyright (c) 2006 by Microsoft Corporation All Rights Reserved ___________________________________________________________________ README CONTENTS - WHAT'S IN THIS COMPANION CONTENT? - COMPANION CONTENT MISCELLANEOUS NOTES - SUPPORT INFORMATION - Microsoft Learning Technical Support Information WHAT'S IN THIS COMPANION CONTENT? ================================= This companion content contains the source code for the sample programs presented in the book. COMPANION CONTENT MISCELLANEOUS NOTES ===================================== Sample Code Folder Organization ------------------------------- These companion materials for Programming Microsoft SQL Server 2005 are provided in a structure such that each chapter has its own folder, named ChapterXX (where XX is the two-digit-formatted chapter number). Chapters 1, 5 and 13 do not have any sample code and therefore no folders are provided for these chapters. Within each chapter folder, you will find a folder called VS containing sample Visual Studio projects, and/or a folder called SSMS containing sample SQL Server Management Studio projects. Typically, a master Visual Studio solution file, named ChapterXX.sln appears in the VS folder and a master Management Studio solution file, named ChapterXX.ssmssln, appears in the SSMS folder. (Where, again, XX is the two-digit-formatted chapter number.) Sometimes, multiple master solution files will appear; in such cases, the chapter text will explain the significance and location of each. The master solution files typically contain all sample projects for a given chapter and thus provide a convenient option for opening all of a given chapter's sample code quickly. They are provided to make examining the sample code simple and to make that task consistent across chapters. However, some chapters direct you to open up sample projects one-at-a-time, using project-specific solution files. In such cases, you may opt not to use the master solution file and instead use the project-specific solution files contained in the projects' own sub-folders. Opening SQL Server Management Studio solutions ---------------------------------------------- By default, SQL Server Management Studio does not display its Solution Explorer window. This leads to an anomaly when opening .ssmssln Management Studio solution files from a Windows Explorer window: when you double-click the file (or select it and press Enter), Management Studio will launch, but its Solution Explorer window will only display briefly and then disappear, leaving no visible queue that you have loaded specific projects or scripts. To fix this, select the View/Solution Explorer option from Management Studio�s main menu, or its Ctrl+Alt+L keyboard shortcut. The Solution Explorer window will display and will continue to be visible in all future Management Studio sessions until and unless you hide it. Double-clicking on an .ssmssln file will now open the corresponding solution and properly display its contents in the Solution Explorer window. Deployment of SQL CLR Assemblies -------------------------------- Before you can deploy the assemblies from the SQL CLR sample code projects supplied for Chapters 3, 9 and 11, you must set those projects' database references. To do so, follow these steps: (1) Open the appropriate project in Visual Studio. (2) Double-click the project's Properties node in the Solution Explorer window to show the project properties sheet. (3) Select the properties sheet's database tab, then click the Browse... button to launch the Add Database Reference dialog box. (4) Select the appropriate database connection or click the Add New Reference... button to define a new one. SUPPORT INFORMATION =================== Microsoft Learning Technical Support ------------------------------------ Every effort has been made to ensure the accuracy of the book and this companion content. As corrections or changes are collected, they will be added to a Microsoft Knowledge Base article. Microsoft Press provides support for books and companion content at the following Web site: http://www.microsoft.com/learning/support/books/ If you have comments, questions, or ideas regarding the book or this companion content, or questions that are not answered by visiting the site above, please send them to Microsoft Press via e-mail to: [email protected] or via postal mail to: Microsoft Press Attn: Programming Microsoft SQL Server 2005 Editor One Microsoft Way Redmond, WA 98052 Please note that Microsoft software product support is not offered through the above addresses.