| Author |
timeout when changing data type
|
|
|
| Hi,
I got a timeout error when attempting to change the data type on our
transactional db. I understand that archive on this db is long over due but
I wonder if I can get around it for now and update the data type first?
Thanks.
--
bic
| |
| Tracy McKibben 2006-11-07, 7:12 pm |
| bic wrote:
> Hi,
>
> I got a timeout error when attempting to change the data type on our
> transactional db. I understand that archive on this db is long over due but
> I wonder if I can get around it for now and update the data type first?
> Thanks.
Don't use Enterprise Manager to make this change - use the ALTER TABLE
command...
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
| |
|
| It worked. Thanks Tracy.
--
bic
"Tracy McKibben" wrote:
> bic wrote:
>
> Don't use Enterprise Manager to make this change - use the ALTER TABLE
> command...
>
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>
|
|
|
|