The xp_cmdshell option is a server configuration option that enables system administrators to control whether the xp_cmdshell extended stored procedure can be executed on a system.
SQL SERVER – Alternate Fix : ERROR 1222 : Lock request time out period exceeded
ERROR 1222 : Lock request time out period exceeded.
SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column value of the table
Following script will return all the tables which has identity column. It will also return the Seed Values, Increment Values and Current Identity Column value of the table. SELECT IDENT_SEED(TABLE_NAME) AS Seed, IDENT_INCR(TABLE_NAME) AS Increment, IDENT_CURRENT(TABLE_NAME) AS Current_Identity, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE OBJECTPROPERTY(OBJECT_ID(TABLE_NAME), 'TableHasIdentity') = 1 AND TABLE_TYPE = 'BASE…
Read More
SQL SERVER – Understanding new Index Type of SQL Server 2005 Included Column Index along with Clustered Index and Non-clustered Index
Clustered Index Only 1 allowed per table Physically rearranges the data in the table to conform to the index constraints.
SQL SERVER – Fix : Error 1418 – Microsoft SQL Server – The server network address can not be reached
Error: 1418 – Microsoft SQL Server – The server network address can not be reached or does not exist. Check the network address name and reissue the command
The server network endpoint did not respond because the specified server network address cannot be reached or does not exist.
SQL Server Interview Questions and Answers Complete List Download
This is summary blog post for SQL Server Interview Questions and Answers.
SQL Server Interview Questions and Answers – Part 6
Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.