Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jaap
Starting Member
19 Posts |
 Posted - 2007-03-21 : 08:17:17
|
| Hello,Once I had a property switched ON in Enterprice Manager.After a change of a table there was a window with the SQL script of the change.For example I added a collumn in EM. By saving the change there came a window withADD Columname etc..I have once switched of this property.Now I'd like to switch it on again but I can't find out where I have to do this.Can someone tell me?Thanks Jaap |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Jaap
Starting Member
19 Posts |
Posted - 2007-03-21 : 10:40:33
|
Hey Brett, quote:
any time you make a change to a table in Enterprise Mangler, it will ask you if you want to save the script...it's not a setting that I know of...
My problem is that he don't asks me anymore to save the script. Once I cheked OFF a field on the window that shows you the script.The problem is I don't get the window so I don't can set the checkfield to ON.But there must be another place to set it ON. (I hope)Jaap |
 |
|
|
Jaap
Starting Member
19 Posts |
Posted - 2007-03-22 : 05:10:39
|
Hello,I found it. I had switched OFF the property 'Automatically generate change script on every save'To switch it ON you'd have to change a diagram and then right mouse-click to go to Save Change Script.When this window is opened there you have the switch to set this property ON.JaapPS.I hope this answer will help somebody else so he don't have to spend a lot off time to find it out as I did.  |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-22 : 14:14:17
|
| This option is also available when you make changes to the table design through SSMS. Just click on the first button on the Table Designer toolbar (Generate Change Script)Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
Generate sql script