Scribd
Upload
17 views3 pages

SQL Server Version Features & Collation Settings

Uploaded by

bikram12
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
17 views3 pages

SQL Server Version Features & Collation Settings

Uploaded by

bikram12
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Features

SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012

Resource Database File stream


Query Purpose

select @@version Version,build number,Edition


SELECT SERVERPROPERTY('COLLATION') To find collation seeting for the instance
SELECT Name, Description FROM fn_helpcollations() To find list of all sql server collation settings
SQL Server 2005 SQL Server 2008

Servers and tools are combined


Collation setting custamization for components
Add current user option
Data directories
file stream

You might also like