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 |
|
jogin malathi
Posting Yak Master
117 Posts |
 Posted - 2007-02-08 : 03:05:28
|
| After creating a table if we want to create relations to table we right click . There i found an option as GENERATE CHANGE SCRIPTthrough this option we can generate the table script and save as text file Now how can i use the saved scriptCan anyone HelpMalathi Rao |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2007-02-08 : 03:10:18
|
| Just copy the text to where you are submitting your query and execute (i.e. SQL Managment studio query window is probably the most common for sql 2005). |
 |
|
|
jogin malathi
Posting Yak Master
117 Posts |
Posted - 2007-02-08 : 03:23:15
|
quote:
Originally posted by Vinnie881
Just copy the text to where you are submitting your query and execute (i.e. SQL Managment studio query window is probably the most common for sql 2005).
after executing it shows asCommand(s) completed successfully.but what is the output of the transactionMalathi Rao |
|
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2007-02-08 : 03:27:08
|
| That means that there was no result set output. If you are just running a script to change a table there is not supposed to be any results.If you want post your script and I'll take a quick look at it. |
|
|
|
jogin malathi
Posting Yak Master
117 Posts |
Posted - 2007-02-08 : 04:00:15
|
 Malathi Rao |
|
|
|
|
|
|
Table script