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

Fix Index Naming Expand / Collapse
Author
Message
Posted Monday, October 11, 2010 12:22 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, March 27, 2014 12:50 PM
Points: 233, Visits: 444
Comments posted to this topic are about the item Fix Index Naming
Post #1001940
Posted Monday, October 11, 2010 3:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 19, 2011 6:39 AM
Points: 10, Visits: 24
I think some of the functions used within the script are missing from the script. Hopefully these can be linked too.
Post #1001989
Posted Monday, October 11, 2010 3:06 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, March 27, 2014 12:50 PM
Points: 233, Visits: 444
Did you download the install script from below. or did you copy the sql code. I tried both install scripts on a server, and none of them failed with missing table value functions

-- -- # IMPORTANT!!!
-- #
-- # Because of the rather lengthy install script, I am only showing the
-- # script for display. It won't install, because of missing table value
-- # functions. The version I have shown is the 2008 version
-- #
-- # You can download a complete install script here.
-- # 2005 version - http://files.soendergaard.info/Install_spFixIndexNaming_V2005.sql
-- # 2008 version - http://files.soendergaard.info/Install_spFixIndexNaming_V2008.sql
Post #1001992
Posted Monday, October 11, 2010 3:10 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 19, 2011 6:39 AM
Points: 10, Visits: 24
Thanks, I had copied the SQL from the webpage and I didn't see those links earlier, thanks
Post #1001994
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse