- From MSDN: http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/8_ ar_ts_1.htm

"Database objects include all tables, views, stored procedures, extended stored procedures, triggers, rules, defaults, and constraints. The sum of the number of all these objects in a database cannot exceed 2,147,483,647."

In other words, "More than enough...."

Best regards, Zac Bedell

> -----Original Message----- > From: Brook Davies [mailto:brook@maracasmedia.com] > Sent: Tuesday, January 30, 2001 2:56 PM > To: CF-Server > Subject: OT: max tables > > > OT: what is the max number of tables SQl 7.0 can handle? > > > At 04:55 PM 29/12/00 -0800, you wrote: > >My subject tag is probably not all that clear. I am passing > the whole form > >collection through a custom tag to a stored procedure. I > pass the form > >collection by > > <CF_st_trials_insert ATTRIBUTECOLLECTION="#form#"> > > > >Well, I don't seem to be having a problem with that. It is > when I call the > >strored procedure and execute it with > > > > <cfprocparam type="in" cfsqltype=cf_sql_varchar > >value="#Attributes.PROT_NO#" dbvarname="@PROT_NO"> > > > > <cfprocparam type="in" cfsqltype=cf_sql_varchar > >value="#Attributes.ELIGIBILITY#" dbvarname="@ELIGIBILITY"> > > // this is just an exerpt from the whole code but > enough to give you an > >example > > > >What happens is that I do perform the insert without any > errors but the > >fields get shifted by one in the table. > > > >For instance when I look at the table the address date is > gone and the > >address2 field is in the address1 field, the city in the > address2, etc. > > > >Has anyone seen this before? I know a couple ways to fix it > but I was > >wondering if this has been discussed before. > > > >Thanks in advance! > > > >Derek Hamilton > > > > > > > ~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. ------------------------------------------------------------------------------ To unsubscribe, send a message to cf-server-request@houseoffusion.com with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com