Toad World® Forums

Unable to change datatype on SQL Server 2008

Has anyone come across this.

I have a table on a SQL Server 2008 database with a column of varchar(50).

In Toad 5.5.0.1073 in an Object Browser (I think that is what it is called)
window I right click on the table and select Alter Table.

The alter table screen opens up and I select the column and change varchar(50)
to nvarchar(50).

Click on Ok

The window flashes, moves to the ‘Generating script’ window

Leaves me with a – No changes detected in the SQL Script window.

I have tried this on the same table/column on a SQL Server 2005 database and it
works ok.

Is this not possible in 2008?

Cheers

Jon L.

Important Notice The information in this email is confidential and may be
legally privileged. If you have reason to believe you are not the intended
recipient, any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it is prohibited and may be unlawful and you are
requested to contact the sender urgently and dispose of this e-mail. We make
every effort to keep our network free from viruses. You should, however, check
this e-mail, and any attachments to it, for viruses, as we will not be liable
for direct, special, indirect or consequential damages as a result of any virus
being passed on, or arising from alteration of the contents of this message by a
third party. Company registration details, including registered office
information, for Expro’s principal UK companies can be found via the following
link: www.exprogroup.com/UKregisteredoffices

Hi Jon,

This works fine for me on TSS 5.5 as well as on 5.6 on my test table. Please
provide create script for your table so we can take a look.

regards,

Alexander Maximov

Thanks for the response but I have upgraded to 5.6 now and it works.

Great!

regards,

Alexander Maximov