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 |
|
swatib
Posting Yak Master
173 Posts |
 Posted - 2006-04-11 : 01:34:09
|
Hello AllWhen ever we generate sql script for the table and run it on the other server then its primary key, default values etc gets destroyed. Why this is happened?How should I take complete table script so that I don't have to modify it again on the other server after running its script?ThanksNjoy Life  |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-04-11 : 01:45:05
|
| when you are creating the table script from the EM, just make sure that from the option tab you have selected scripts for triggers, scripts for indexes, and scripts for the constraint..this will make sure that all the table related objects are there in the script..If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
 |
|
|
swatib
Posting Yak Master
173 Posts |
Posted - 2006-04-11 : 02:25:30
|
| Many Thanks !!!!!! will definitely remember this............Njoy Life |
|
|
|
|
|
|
Generate SQL script