Solved

Record Table Changes in Scripts

Posted on 2008-06-17
4
216 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

734 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