|
Posted by Jeff Kish on 03/24/06 15:16
Hi.
I have a database I need to supply something (I'm assuming a t-sql script..
maybe something else is better) to update customer tables with.
The operations include mostly changing varchar lengths, though a couple of
columns were renamed.
I'd like to maybe figure out how to get Enterprise Manager or Query Analyzer
to generate the scripts.
I can't just send alter table scripts because I'm involving all sorts of
constraints that have to be disabled/or dropped, the alter made, then have
them enabled/ or re-created.
Basically I'm hoping to get the tools to do the rather large amount of work
for me. I'm targetting sql server 2000.
Can someone make a knowledgeable suggestion?
Regards
Jeff Kish
Navigation:
[Reply to this message]
|