Modify data structure

25 Nov 2005 1:41 AM

Souris

I would like to change the data type from date time to timestamp and
nvarchar(14) to nvarchar(20).

Are there any impact to change a live database?

Thanks millions in advance,

25 Nov 2005 2:14 AM

GregO

Hi ,
nvarchar(14) to nvarchar(20) shouldn't be a problem

But

a timestamp is not a date value. It is a binary value which is linked to
the current row. So changing that will clase a problem to your clients.
Before changing
Thisis from BOL

timestamp is a data type that exposes automatically generated binary
numbers, which are guaranteed to be unique within a database. timestamp is
used typically as a mechanism for version-stamping table rows. The storage
size is 8 bytes.

Remarks
The Transact-SQL timestamp data type is not the same as the timestamp data
type defined in the SQL-92 standard. The SQL-92 timestamp data type is
equivalent to the Transact-SQL datetime data type.

--
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com

Show quote

"Souris" <Sou***@discussions.microsoft.com> wrote in message
news:70B6B3CC-1490-4C00-8232-DB0486C5D0AE@microsoft.com...
>I would like to change the data type from date time to timestamp and
> nvarchar(14) to nvarchar(20).
>
> Are there any impact to change a live database?
>
> Thanks millions in advance,