July 27, 2006 at 5:20 pm
WE have tables with millions of rows and everytime I try to rename the datatype, I always get this message
saying a 'timeout' occured...
Where can I increase this timeout connection. I'm also doing this through EOM, would it be better via QA?
July 27, 2006 at 6:33 pm
You better copy the SQL code generated by EM into QA and run it from there.
QA does not have timeouts. Unless you set it up.
And better do it overnight.
_____________
Code for TallyGenerator
July 28, 2006 at 3:12 am
use in query analayser the alter table statement
for example
alter table mytable alter column mycolumn varchar(100) NOT NULL
Enterprise mangler does some odd things when changing tables due to backwards compatability issues
MVDBA
July 28, 2006 at 9:15 am
THanks Mike,
It worked find via the QA.
Susan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply