RSS Feeds

Write for Us

Share your SQL Server knowledge with others and raise your profile in the community More...

Latest SQL Server Articles

Working with Windows Communication Foundation (WCF)
WCF unifies a variety of communication technologies. This intro explains the advantages WCF and how to get started using this technology.

Transfer Logins Task and Transfer Database Task in SSIS
The Transfer Logins and Transfer Database tasks can be used in combination to easily and efficient migrate databases and users across different SQL Servers.

Practical Database Change Management (Part 2)
The final article on Change Management examines the more technical aspects of Change Management.

Practical Database Change Management (Part 1)
Changing a database an integral and crucial part in every application's life cycle. Part 1 of this series looks at the steps and procedures prior to implementing the change

Execute SQL and Bulk Insert Tasks in SSIS
Learn how the Execute SQL and Bulk Insert tasks can be combined to create a database and insert data into the database.

Latest SQL Server Training Videos

Installing SQL Server
A full walkthrough on installing SQL Server 2005.

Latest Software Reviews

Spotlight on ApexSQL Diff - Server-based database comparison tool

Spotlight on ApexSQL Data Diff - Server-based database comparison tool

Spotlight on ApexSQL Doc 2008

ApexSQL Enforce

Embarcadero Change Manager

Latest FAQ's

	ALTER TABLE SWITCH statement failed because column '%.ls' has data type %s in source table '%.ls' which is different from its type %s in target table '%.*ls'.
	ALTER TABLE SWITCH statement failed because column '%.ls' has data type %s in source table '%.ls' which is different from its type %s in target table '%.*ls'.
	ALTER TABLE SWITCH statement failed. There is no identical index in source table '%.ls' for the index '%.ls' in target table '%.*ls' .
	'%ls' statement failed because the expression identifying partition number for the %S_MSG '%.*ls' is not of integer type.
	ALTER TABLE SWITCH statement failed. Column '%.ls' in table '%.ls' is computed column but the same column in '%.*ls' is not computed.
	ALTER TABLE SWITCH statement failed. Computed column '%.ls' defined as '%.ls' in table '%.ls' is different from the same column in table '%.ls' defined as '%.*ls'.
	ALTER TABLE SWITCH statement failed. Check constraints or partition function of source table '%.ls' allows values that are not allowed by check constraints or partition function on target table '%.ls'.