SQL Server "linked" table

I have something going on that I have never seen before.

I created a table by using the following code:
SELECT * INTO NEWTable FROM OLDTable

Now, whenever I update a row in either table, it automatically gets updated in the other. Or, if I insert a new row, it gets inserted into the other.

What is happening?
GenesisTechAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Russ SuterSenior Software DeveloperCommented:
Whatever it is it has nothing to do with the query you created. That query will perform a SELECT INTO one time. After that the two tables are separate entities. The new table will have the same data definition as the old but it will not have the indexes or key constraints that the old table had. There's something else happening.

If you run a simple INSERT statement in SSMS does it come back with a single message:
(1 row(s) affected)
or do you get 2 of those?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GenesisTechAuthor Commented:
Thank you. You helped confirm that I was wrong and gave me a way to test in addition to what I was already doing.

As happens many times it technology, I discovered that I had made a typo leading to the issue.

Thanks again for your time and answer!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.