script DB changes

Question

script DB changes

smknox

Hall of Fame

Points: 3275
More actions
December 27, 2006 at 3:10 pm

#170800

really easy question, but i can't find it:
How do I set EM in SQL server 2k to generate a script when table changes are made? I know there is a checkbox somewhere.
Thanks!!
Sam

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

SQLBill SSC Guru Points: 51440 More actions · Answer 1

I don't think there is anything that does it automatically. After you make a change, you can right click on the table, select All Tasks > Generate SQL Script. But if you mean an 'auditting' type of thing, where anytime a table is changed a script is saved to a file...I don't believe SQL Server does that.

-SQLBill

Ray M SSC-Insane Points: 21093 More actions · Answer 2

If you make the change in Enterprise manager, before, or instead of hitting the save icon, click the generate script icon.

Jeff Moden SSC Guru Points: 1004403 More actions · Answer 3

Actually, since RedGate just procurred this site, try RedGate SQL Compare

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

smknox Hall of Fame Points: 3275 More actions · Answer 4

Thanks. But what I am looking for is access to a checkbox that says to script all changes when table edits are made. It was doing this, and for some reason I unchecked the box. The screen to recheck the box is nowhere to be found and I'd like to recheck it.

THanks,

Sam

sushila SSC-Dedicated Points: 35293 More actions · Answer 5

Sam - you might be referring to the "Options" tab where you can check the table scripting options to script indexes, primary keys, check constraints etc. where you get an alter table script along with the create table script...

**ASCII stupid question, get a stupid ANSI !!!**