Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Script all indexes as CREATE INDEX statements Expand / Collapse
Author
Message
Posted Tuesday, May 22, 2012 9:07 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 6:33 AM
Points: 65, Visits: 202
That was really helpfull.

I was trying to execute on SQL Server 2008 R2 and bumped into an issue with the Collation parameters with the "keycolumns ".

To work around, I added COLLATE DATABASE_DEFAULT for keycolumns in the sections that generates the CREATE INDEX scripts.

Post #1304657
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse