Table in SQL Server is growing and should not grow.

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hello everyone,
I have a database in SQL Server 2005 with a table called StationPositions which has four keys: StationId, Row, Position, and Level.

Station 2101 has only 24 positions. However, since Yesterday, this table is being growing. now, this Station have 56 records instead of 24. I do not know why? this table should not be growing at all. I look into the Database for Insert Statement and did not find any for this table.
I look into the C # code for an Insert Statement and did not find any ether.

Do you have any idea why this could be happening?

Thank you

Posted 22-May-13 18:18pm

iscivanomar

Add a Solution

Comments

Nayan Ambaliya 23-May-13 0:27am

Have you thought about the field Level.. It might be possible that for station 2101 and position 1 - there are many levels. And can you clarify what is the 'Row' field for?

--Nayan

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)

Abhinav S · Answer 1 · 2013-05-22T18:26:00

Solution 1

Check if any stored procedures or triggers are inserting into this table.

Posted 22-May-13 18:26pm

Abhinav S

iscivanomar · Answer 2 · 2013-05-22T18:56:00

Hello Nayan,
It should have only one level. This is a sample data. The Level 2 should not exist. The other records have already data and are ok. Let say we have Pallets on the floor in a warehouse. One Station has two Rows and fortheen positions deep.
Look into this web site for an example:

XML

http://palletsincorporated.com/Products/products.htm

<pre lang="css">Lgvcs.StationPositions
2101    1   1   1   16401771    2013-05-21 16:36:58.470 2013-05-02 22:18:46.360 507330  260027
2101    2   1   1   16401772    2013-05-21 16:36:58.470 2013-05-02 22:18:46.360 508430  260027
2101    1   1   2   NULL    NULL    NULL    507330  260027
2101    2   1   2   NULL    NULL    NULL    508430  260027
2101    1   2   1   16340611    2013-05-18 04:31:11.593 2013-05-18 04:04:25.673 507330  261427
2101    2   2   1   16340612    2013-05-18 04:31:11.610 2013-05-18 04:04:25.687 508430  261427
2101    1   2   2   NULL    NULL    NULL    507330  261427
2101    2   2   2   NULL    NULL    NULL    508430  261427
2101    1   3   1   16340649    2013-05-18 04:33:17.703 2013-05-18 03:50:26.673 507330  262827
2101    2   3   1   16340650    2013-05-18 04:33:17.720 2013-05-18 03:50:26.687 508430  262827
2101    1   3   2   NULL    NULL    NULL    507330  262827
2101    2   3   2   NULL    NULL    NULL    508430  262827
2101    1   4   1   16340695    2013-05-18 04:38:28.000 2013-05-18 02:49:14.733 507330  264227
2101    2   4   1   16340696    2013-05-18 04:38:28.000 2013-05-18 02:49:14.733 508430  264227</pre>

iscivanomar · Answer 3 · 2013-05-22T18:58:00

Solution 3

Hello Abhinav,
I checked the whole database for Insert Statements but none of them are for StationPositions table, which is the afected.

Posted 22-May-13 18:58pm