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

maximum key length is 900 bytes Expand / Collapse
Author
Message
Posted Thursday, September 30, 2010 7:55 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, January 3, 2013 12:52 PM
Points: 519, Visits: 26
Very nice article. I ran the tables script and got the following error

Warning! The maximum key length is 900 bytes. The index 'IX_Database_Info' has maximum length of 1288 bytes. For some combination of large values, the insert/update operation will fail.

Would this has any impact on code, thanks



Post #995948
Posted Thursday, September 30, 2010 10:15 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, January 3, 2013 12:52 PM
Points: 519, Visits: 26
Please ignore this thread, I notices the comment inside the article now.


Post #996059
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse