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