Category: DataBase

DataBase, Repackaging, Server

INFO: Registry Entries and Keywords for SQL Server Connection Strings

When you create a system DSN in the ODBC Data Source Administrator in Control Panel, and you use the Microsoft SQL Server ODBC driver, the DSN settings are saved in a registry key under the following with the same name of your DSN: < B>HKEY_LOCAL_MACHINESoftwareODBCOdbc.ini</B> If you create a user DSN, the settings are saved in a registry key under the following: < B>HKEY_CURRENT_USERSoftwareODBCOdbc.ini</B> <BR/><BR/> The Microsoft SQL Server ODBC Driver setup also writes parameters to the Odbc.ini registry entry. There are several parameters in the Microsoft SQL Server ODBC Driver setup that have a default value. When you first […]

Read more
DataBase, Server

Managing SQL server instances registration through Studio GUI and Manual Steps

  Managing Registered SQL Server instances:             “%appdata%MicrosoftMicrosoft SQL Server100ToolsShellRegSrvr.xml" OR "C:Users<Username>AppDataRoamingMicrosoftMicrosoft SQL Server100ToolsShellRegSrvr.xml"   Sample content of a   <?xml version="1.0"?> <model xmlns="http://schemas.serviceml.org/smlif/2007/02">   <identity>     <name>urn:uuid:</name>     <baseURI>http://documentcollection/</baseURI>   </identity>   <xs:bufferSchema xmlns:xs="http://www.w3.org/2001/XMLSchema">     <definitions xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08">       <document>         <docinfo>           <aliases>             <alias>/system/schema/RegisteredServers</alias>           </aliases>           <sfc:version DomainVersion="1" />         </docinfo>         <data>           <xs:schema targetNamespace="http://schemas.microsoft.com/sqlserver/RegisteredServers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">             <xs:element name="RegisteredServer">               <xs:complexType>                 <xs:sequence>                   <xs:any namespace="http://schemas.microsoft.com/sqlserver/RegisteredServers/2007/08" processContents="skip" minOccurs="0" maxOccurs="unbounded" />                 </xs:sequence>               </xs:complexType>             </xs:element>             <RegisteredServers:bufferData xmlns:RegisteredServers="http://schemas.microsoft.com/sqlserver/RegisteredServers/2007/08">               <instances xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08">                 <document>                   <docinfo>                     <aliases> […]

Read more
DataBase

How to determine the version and edition of SQL Server and its components

This article describes how to determine your current Microsoft SQL Server version number and the corresponding product or service pack level. It also describes how to determine the specific edition of SQL Server that you are using. Note If you just want to find the latest builds for SQL Server, you can refer to the following article. Or, you can check the tables that correspond to your product in the "More Information" section of this article. 957826 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;957826) Where to find information about the latest SQL Server builds How to determine the version of SQL Server Client tools SQL Server […]

Read more