SQL Server: How to change SQL Server Authentication Mode

To change the SQL Server Authentication mode please follow the below steps

1. Logon to SQL Server and Right Click on the instance name (see in the below image) and select Properties.

2. You will see the Server Properties for the selected instance, Here you select Security page from the left side pane. Once you select the Security page you will get the option to change the Server Authentication mode.

By Harsh Shah (Sr. Consultant)

SQL Server: How to check the current authentication mode by code in SQL Server

EXEC xp_loginconfig ‘login mode’

Result:

SQL SERVER: How to identify the SQL Server Version No?

To know the version of the SQL Server on your machine type follwoing statement in the SQL Server Management Studio

SELECT @@VERSION

Following is the result:

Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)   Mar 23 2007 16:28:52   Copyright (c) 1988-2005 Microsoft Corporation  Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

SQL SERVER: Editions and Components of SQL Server 2008

The below link provides the detail information about the various editions of SQL Server 2008.

http://msdn2.microsoft.com/en-us/library/ms144275(SQL.100).aspx

Happy Learning

SQL Server: Download SQL Server 2008 November CTP

You can download the SQL SERVER 2008 November CTP from the below link. However, I would suggest you to go through the Hardware Requirements page first before you proceed with the SQL SERVER 2008 installation. You can find the

Hardware Requirements:
http://msdn2.microsoft.com/en-us/library/ms143506(SQL.100).aspx

Download Nov CTP
http://msdn2.microsoft.com/hi-in/sqlserver/bb851668(en-us).aspx

Happy Learning

SQL Server:SET STATISTICS TIME ON

SET STATISTICS TIME ON

Displays the number of milliseconds required to parse, compile and execute SQL statements.

EXAMPLE

USE Adventureworks

SET STATISTICS TIME ON

SELECT * FROM Production.Product

SET STATISTICS TIME OFF

Results: (You can view the results in the Message Pane i.e. next to Results Pane)

SQL Server parse and compile time:

CPU time = 0 ms, elapsed time = 50 ms.

(504 row(s) affected)

SQL Server Execution Times:

CPU time = 0 ms, elapsed time = 668 ms

Hello Everybody

Thanks for visiting my blog….

I have created this blog to share my ideas, experience and resources on SQL Server. Over a period of time I will be posting articles on SQL Server 2005, SQL Server 2008, Interview Questions, Microsoft SQL Server 2005 Business Intelligence (SSIS,SSAS,SSRS, Office PerformancePoint Server) and many other resources related to SQL Server.

Thank You and have a great year ahead…

Harsh Shah
(Sr. Consultant - Database and Business Intelligence)