Tuesday, April 24, 2012 6:32 AM
Hi every body.
Whenever i want to modify a field of a table (delete or update), SQL server with showing a message doesn't allow me do it.
meanwhile i am aware of this matter that maybe the master table would have some details . but my case is something different ,
because for example when i decide to correct or modify the DataType of a field again it doesn't let me do that.
So is there any way in tools option or any other suggestion to solve it?
Tuesday, April 24, 2012 6:43 AM
Yes, there is an option in SSMS, see http://msdn.microsoft.com/en-us/library/ms188490(SQL.105).aspx => "Prevent saving changes that require table re-creation"
In menu Tools => Option , Tab Designer.
BTW, if you have a question, please start you thread as a "question", not as a "discusion".
- Edited by Olaf HelperMicrosoft Community Contributor Tuesday, April 24, 2012 6:43 AM
Tuesday, April 24, 2012 7:04 AM
Hi Olaf.would you please help me in my following quesiton.sorry for the font type!!
I intend to develope a registeration site for a university and for creating it's database there is a table known as persons ,that one of it's field is BirthDate.i also want that the design of my form to be somehow which it's birthdate part to be made of 3 seprated and independed Day,Month & Year ComboBox. my main problem is that i don't know whether the DataType of BirthDate field should be
Date or char(10)or even Int?
Thank you for your help and either your point about question and discusion.
- Edited by great ehsan Tuesday, April 24, 2012 7:09 AM