SQL Server Archives - Page 330 of 333 - SQL Authority with Pinal Dave

SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column value of the table

April 23, 2007

SQL Function, SQL Identity, SQL Index, SQL Scripts, SQL Server, SQL System 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…

SQL SERVER – Understanding new Index Type of SQL Server 2005 Included Column Index along with Clustered Index and Non-clustered Index

April 23, 2007

Pinal Dave

SQL Performance

SQL Constraint and Keys, SQL Index, SQL Scripts, SQL Server

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

April 22, 2007

Pinal Dave

SQL

Computer Network, SQL Error Messages, SQL Server, SQL Server Security, SQL Utility

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.