Re: OT SQL Server (OK 1 More ?)

2001-06-13 Thread Derek Hamilton
That means 4 bytes. This will limit the number but more like around 30,000. I don't remember the exact number, anyone...? Derek - Original Message - From: ibtoad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 9:32 AM Subject: RE: OT SQL Server (OK 1 More

RE: OT SQL Server (OK 1 More ?)

2001-06-13 Thread Garza, Jeff
[EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 9:32 AM To: CF-Talk Subject: RE: OT SQL Server (OK 1 More ?) OK I got it. Now that I have the primary key set with datatype int, the length is limited

RE: OT SQL Server (OK 1 More ?)

2001-06-13 Thread Michael Bruce
that you might run into a problem if you have more than 2.1 billion records on that table. Mike Bruce Fig Leaf Software -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 12:32 PM To: CF-Talk Subject: RE: OT SQL Server (OK 1 More ?) OK I got it. Now

RE: OT SQL Server (OK 1 More ?)

2001-06-13 Thread Howarth, Craig (IBK-NY)
Subject: RE: OT SQL Server (OK 1 More ?) OK I got it. Now that I have the primary key set with datatype int, the length is limited to 4. Is this correct and will this limit the table to records? Thanks, Rich -Original Message- From: Craig Bowes [mailto:[EMAIL PROTECTED