Link to home
Start Free TrialLog in
Avatar of mohet01
mohet01Flag for India

asked on

Insert query

Hello
1) is there a limit in the number that can be inserted in a ms sql table?
How do I know, if there is a limit?
Because there is a scenario where I have 170000 entries in a table, I would like what are the factors that decides the limit?
2) if there is a limit, what happens when you add an additional entry, does this raise any windows error on windows event/app/system logs ?


Sham
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

I suggest you check out:
http://msdn.microsoft.com/en-us/library/ms143432.aspx

What do you mean by "number that can be inserted"?  Maximum number of rows, or the max size of the actual 'number' or something else?
If I read your question right, you are asking about the number of rows.  From the link I provided:

Rows per table  Limited by available storage
depends on the space available on the disk.
Now, if you want to insert such a large volume of data, i suggest use the BULK INSERT /bcp statements (also change the mode to 'bulk logged' otherwise each insert statement will make the log files to grow
Avatar of mohet01

ASKER

maximum nuber of rows that can be inserted in a SQL 2005 table?

>maximum nuber of rows that can be inserted in a SQL 2005 table?

depends on the free space and edition, the express edition have a database size limit of 4gb
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mohet01

ASKER

Done