Greetings.

I would like to set up a script that will update the column sizes for certain
table/column combinations that the login has access to.

It can be done via EM, however it automagically takes care of dependent
"stuff" like making other related objects resized also.

I'm not sure if there is an sp or something somewhere I could use to figure
out t-sql wise what dependencies need to be updated also for any given object.


Bottom line is .. is there some t-sql I can write (I would like to automate
this actually, just passing in a table/column and size, and get everything
that needed it automatically updated with the new size) that will do the
trick?

If nothing else is possible, I'd just like to give a sp/script to a user and
say "pass in the table, column, and size and this will take care of all the
objects that need to be resized".

I don't know of an automagic way to do what you are asking...but an
option to find out what EM is doing is running SQL Server profiler. Run
a trace and then do what you need via EM to capture the commands it is
issuing.

HTH,

BZ