how many rows a table without a primary key can strore (microsoft sql server management studio 2008)?

Question

0.00/5 (No votes)

See more:

i have a table which does not have a primary key. it stores only 200 records, but i want to store more than that? how can i do that? can any one help me with this?

Posted 24-Mar-14 3:34am

Ahmed Tamseer

Updated 24-Mar-14 3:54am

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raul Iloc · Answer 1 · 2014-03-24T03:46:00

Solution 3

The numbers of rows is not limited to 200, maybe you saw in SQL Management the option: "Edit Top 200 Rows".

Here is the Maximum Capacity Specifications for SQL Server[^]

So as you can read on the link above the number of rows per table is "Limited by available storage"!

Posted 24-Mar-14 3:46am

Raul Iloc

Updated 24-Mar-14 3:49am

v3

ZurdoDev · Answer 2 · 2014-03-24T03:42:00

Solution 2

The only reason I can think of if you could not add more records is because of a unique index or something along those lines. You can certainly store many, many more records than 200 so it sounds like you have something else going on.

Posted 24-Mar-14 3:42am

ZurdoDev

Mehdi Gholam · Answer 3 · 2014-03-24T03:41:00

Solution 1

You are not limited (number wise) if you don't have a primary key for a table.

Do a :

SQL

select count(*) from [yourtablename]

to see how many records are in your table.

Posted 24-Mar-14 3:41am

Mehdi Gholam