Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

table changes saving issue

I opened a table design view in SQL srever 2005, I added a column to the table, and then clicked the X button, and been promted by a dialog box for saving the changes, and I clciked Yes. Then a confirm dialog asked me if I save on other three tables too. I only added a column in one table, why does it ask me if I save on four tables? Is there any internal setting stuff causing it? Please the attached file.

Thanks.
multisave.JPG
0
minglelinch
Asked:
minglelinch
  • 4
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
Could be due to some foreign key references, you should use the ALTER table statement instrad of the table designer, the table designer will lock the table and has to  perform few other tasks behind the scenes to add a column
0
 
minglelinchAuthor Commented:
Ok. Thank you.

I already use the table designer and added cloumns and clicked OK to continue saving on multiple tables. Will it cause any defects?
0
 
Christopher KileCommented:
No, it shouldn't cause any defects.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
minglelinchAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for minglelinch's comment #a38374007

for the following reason:

Thanks for the solution.
0
 
Christopher KileCommented:
minglelinch, you can't assign the solution to yourself if you got the solution from aneeshattingal, which your closing comment indicates you did.  Please cancel your deletion and give him the points.
0
 
minglelinchAuthor Commented:
Sorry, my mistake. I should choose the first answer as the solution. Please correct it for me.

"Could be due to some foreign key references, you should use the ALTER table statement instrad of the table designer, the table designer will lock the table and has to  perform few other tasks behind the scenes to add a column"
0
 
minglelinchAuthor Commented:
Thanks.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now