Browse by Tags

TSQL to get clustered index information in SQL Server 2005

Published 10 March 8 3:0 AM | SSQA.net

Recently within a supportal case with CSS we have been given the following TSQL to get information on indexes, where I have modified a bit to get 'Clustered' index information alone that was helpful to see which tables lack of clustered index...

Filed under: sql server, dmv, tsql, schema, information schema, declare, clustered index

FIX: Error message when you set up a snapshot publication on a database in SQL Server 2005: "Error 137, Must declare the scalar variable <VariableName>"

Published 12 October 7 6:5 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, error, kba, variable, snapshot, publication, 137, scalar, declare