make a change, here's how.
0. Open SQL Enterprise Manager and navigate to the desired database and
table.
1. Right-click and choose "Design Table".
2. Make the changes you want.
3. Click the "Save Change Script" button on the toolbar (image below).
4. Once the script dialog box opens, choose the option, "Automatically
generate change script on every save". (image below).
If you mean that you want to know how to do it without using Enterprise
Manager, so you can do it on multiple tables at once, see my previous
message. It is almost exactly like the script Microsoft generates, except
that I added the DBCC CHECKIDENT call just to be safe.
_____________________
Eric A. Laney
_____________________
Last night I stayed up late playing poker with Tarot cards. I got a full
house and four people died. - Steven Wright
"Robert Everland III" <[EMAIL PROTECTED]>
04/29/2004 03:01 PM
Please respond to sql
To: SQL <[EMAIL PROTECTED]>
cc:
Subject: Re: Alter column to add identity
Would you give me an idea as what to look for to enable that, it would be
great to be able to do that on the fly instead of manually. Then I could
create a DTS package.
bob
>Well, now you also know what that one click is doing behind the scenes!
>:-)
>
>Seriously, looking at Microsoft's generated scripts is a great way to
>learn how to do things. When you make your click to enable identity,
>there should be an option to show the generated script. That's true for
a
>lot of things in Enterprise Manager and can be very enlightening.
>_____________________
>Eric A. Laney
>_____________________
>Last night I stayed up late playing poker with Tarot cards. I got a full
>house and four people died. - Steven Wright
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
