Looking forward to the follow up article.

Is there a way to have the trigger only fire when certain naming convention is used for a new database?

I added

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

and I'm still getting the error. Any thoughts?

What would be causing this error?

SELECT failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes...

I get the following error when I try and run the first part of step 2

Msg 102, Level 15, State 1, Procedure SelectAllServersFragmentedTables, Line 167

Incorrect syntax near '

exec (@cmd)

select @err...

Thank you both, I got it working.

Thanks guys. It works now.

Never mind, I got everything working. Thank you very much for your help.

Didn't know about the STUFF command, that helps. Another question, using that code how can I get this to work using it? I've been trying and I can't...

I was thinking of that but I would always have a UNION at the end of my statement which would blow everything up. How do I get around that?

Dan,

that worked - THANK YOU!!!!