June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Download SQL Server 2005 Report Packs – SQL Server Sample Reports – Report Templates

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, SQL Download, SQL Reports, SSRS
Note:   Download SQL Server 2005 Report Packs by Microsoft SQL Server 2005 Reporting Services is a comprehensive, server-based reporting solution designed to help you author, manage, and deliver both paper-based, ad hoc, and interactive Web-based reports. Each report pack consists of a set of predefined reports, a sample database, a…
Read More

SQL SERVER – Maximum Columns per Primary Key – Fix : Error : Msg 1904, Level 16, The index on table has column names in index key list. The maximum limit for index or statistics key column list is 16

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Index, SQL Scripts
My present article covers two fundamental questions. 1) What is the maximum number of columns included in Primary Key Index/Constraint? 2) What is fix/solution for the following error: Msg 1904, Level 16, State 1, Line 1 The index ” on table ‘dbo.Table_2’ has 17 column names in index key list.…
Read More