Tag: SQL SERVER 2008

SQL Server – Location of Installation Log file

SQL, SQL-Advanced, SQL-General, SQL-Tips and Tricks, Varinder Sandhu

A few times we were trying to locate the installation log file folder if we faced any issue or problem while installation of SQL Server. Basically, we want to know reason of issue or problem. So location of Log file folder as below SQL Server 2008 and 2008 R2 %programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\ SQL Server 2005 %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\ You can find the Summary.txt file in above mentioned location. This file shows the SQL Server components that were detected during

» Read more
, ,

SQL Server – Check the compatibility level of a database

SQL, SQL-Advanced, SQL-Tips and Tricks, Varinder Sandhu

You can check the compatibility of a database simply by running the below sql command. sp_dbcmptlevel 'Database_Name' Read more about sp_dbcmptlevel Values of compatibility levels and their corresponding MS SQL Server versions 60 = SQL Server 6.0 65 = SQL Server 6.5 70 = SQL Server 7.0 80 = SQL Server 2000 90 = SQL Server 2005 100 = SQL Server 2008 The values 60 and 65 are deprecated and will be removed in a SQL 2008 and later. You

» Read more
, ,

SQL SERVER 2008 – Enable xp_cmdshell

SQL, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

—  To allow advanced options to be changed EXEC sp_configure ‘show advanced options’, 1 GO —- To update the currently configured value for advanced options. RECONFIGURE GO —- To enable the feature. EXEC sp_configure ‘xp_cmdshell’, 1 GO —- To update the currently configured value for this feature. RECONFIGURE GO Alternative way 1. Click the Start button. 2. Select All Programs. 3. Navigate to the Microsoft SQL Server 2008 folder. 4. Right Click on Server name then click facets options 5. In the Facets Option choose Surface Area Configuration in dropdown 6. At the bottom of the window, mark True for xp_cmdshell. 7. Click OK.

» Read more
, ,