InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 23:29:28 GMT20http://www.sqlservercentral.com/Forums/Topic998995-2586-1.aspxIt means that if all columns making up the primary key is larger than 900 bytes combined, you would be able to add that to the alias table. In practice it shouldn't have an affect, unless your schema, table and column names are very longFri, 24 Feb 2012 13:32:34 GMTLigtornhttp://www.sqlservercentral.com/Forums/Topic998995-2586-1.aspxI am using AliasRules table. I need clarity regarding this warning:"Warning! The maximum key length is 900 bytes. The index 'PK_AliasRules' has maximum length of 1025 bytes. For some combination of large values, the insert/update operation will fail."How can you tell if your key length will approach 900 bytes? What combination of large values will fail?Tue, 29 Nov 2011 14:04:37 GMTKoldCoffeehttp://www.sqlservercentral.com/Forums/Topic998995-2586-1.aspxBTW for all future readers. I have noticed two errors in the publication. 1. I am showing the source code for spFixColumnCheckNaming instead of spFixColumnDefaultNaming. However they are 99% identical in structure and feature. If you want to look at the right source code, check for install script, that is still correct.2. A copy / paste error have occurred in the result output for example 2. Please ignore the first lineWed, 06 Oct 2010 11:46:14 GMTLigtornhttp://www.sqlservercentral.com/Forums/Topic998995-2586-1.aspxAwesome - now these are the kind of articles we need.DougWed, 06 Oct 2010 11:07:41 GMTDouglas Osborne-456728http://www.sqlservercentral.com/Forums/Topic998995-2586-1.aspxDon't worry about the warning it only matters if you alias rows are larger than 900 bytes. And if you are not using any aliases it doesn't matter at allActually you don't need to tweak spFixColumnDefaultNaming for handling PK, FK, IX and UK. My other stored procedures are scheduled for publication the next couple of days. But if you can't wait. just check my site. [url=http://sql.soendergaard.info]http://sql.soendergaard.info[/url]Wed, 06 Oct 2010 10:47:16 GMTLigtornhttp://www.sqlservercentral.com/Forums/Topic998995-2586-1.aspxMichael,I get Warning! The maximum key length is 900 bytes. The index 'PK_AliasRules' has maximum length of 1025 bytes. For some combination of large values, the insert/update operation will fail.for your script at http://files.soendergaard.info/Install_spFixColumnDefaultNaming_V2005-2008.sql. Running the 2008 studio on a SQl2005 db.It worked perfectly, BTW - awesome piece of code - I'll need to tweak it to do the same for PKs, FKs, IX and UKs ... Great standards technique,DougWed, 06 Oct 2010 07:34:38 GMTDouglas Osborne-456728http://www.sqlservercentral.com/Forums/Topic998995-2586-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Default+Constraints/70507/">Fix Default Constraint Naming</A>[/B]Wed, 06 Oct 2010 00:21:47 GMTLigtorn