Fix Default Constraint Naming

Question

Post reply

Fix Default Constraint Naming

Ligtorn

Ten Centuries

Points: 1107
More actions
October 6, 2010 at 12:21 am

#227589

Comments posted to this topic are about the item Fix Default Constraint Naming

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Douglas Osborne-456728 SSCommitted Points: 1569 More actions · Answer 1

Michael,

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,

Doug

Ligtorn Ten Centuries Points: 1107 More actions · Answer 2

Don'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 all

Actually 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. http://sql.soendergaard.info

Douglas Osborne-456728 SSCommitted Points: 1569 More actions · Answer 3

Awesome - now these are the kind of articles we need.

Doug

Ligtorn Ten Centuries Points: 1107 More actions · Answer 4

BTW 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 line

KoldCoffee SSCoach Points: 18971 More actions · Answer 5

I 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?

Ligtorn Ten Centuries Points: 1107 More actions · Answer 6

It 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 long

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 7

akljfhnlaflkj

SSC Guru

Points: 76202

May 18, 2016 at 7:03 am

#1879841

Thanks for the script.