Category: FAQ
The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.
Cannot assign a default value to a local variable.
A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
Percent values must be between 0 and 100.
How to disable database mirroring for a particular database?
What are the specific tasks assigned to System Administrator (SA)role in SQL Server? How can I disable or rename SA account in SQL Server 2005?
What is the best way to test the upgrade process from SQL Server 7.0 or 2000 to SQL Server 2005, before I perform the actual upgrade?
Why can't I install multiple instances of SQL Server Integration Services components on the same physical server?