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 |
|
BendJoe
Posting Yak Master
128 Posts |
 Posted - 2008-11-10 : 15:04:17
|
| How can I get the script of a table which I modified. I am not able to script table as Alter to. How can I get the script? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-10 : 15:14:57
|
| If you have modified,then you should alter permission. You can use script as table with right click? |
 |
|
|
BendJoe
Posting Yak Master
128 Posts |
Posted - 2008-11-10 : 16:33:01
|
| I modified the table using right click modify. The I added one column in the end. After this I wanted to get the script for alter table for my other machine. But right click-> Script Table as-> alter to and right click -> Script Table as-> execute to are grayed out. How can I get the script. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-10 : 17:12:57
|
| You need to have necessary permission from other machine. |
|
|
|
BendJoe
Posting Yak Master
128 Posts |
Posted - 2008-11-11 : 05:20:44
|
| I chose properties for the database and in the permissions section checked almost everything. Still cant get the alter scripts. What else is needed to be done? |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-11-11 : 05:48:39
|
| You can get script BEFORE you saved your changes. Once you click on save, it will not be available. |
|
|
|
BendJoe
Posting Yak Master
128 Posts |
Posted - 2008-11-11 : 07:01:01
|
quote:
Originally posted by lionofdezert
You can get script BEFORE you saved your changes. Once you click on save, it will not be available.
You mean I cant get script after adding a column to the table? |
|
|
|
|
|
|
Alter Table