Solved

Record Table Changes in Scripts

Posted on 2008-06-17
4
206 Views
Last Modified: 2010-04-21
Back with SQL Server 2000 Enterprise Manager, I seem to recall a way to "record" a change to a table in a script.  I could make a change to a table on the development server, record the script, test the change on the development server, then run the script on the production server.  Does SSMS offer such a tool?
0
Comment
Question by:jdana
  • 2
  • 2
4 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 21805812
Hello jdana,
yes SSMS has that feature
i


GOD BLESS,

Aneesh R.
0
 

Author Comment

by:jdana
ID: 21805933
Where do I find it in the SSMS IDE?
0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 250 total points
ID: 21806385
right click and do the modification on the table, whenever you modify the table a "generate script " tool bar will come, usually u can find it b/w the "New Query" and  "Object explorer"
0
 

Author Closing Comment

by:jdana
ID: 31468075
Perfect.  Thank you sir.
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question