Noticed something odd the other day .. say you run a script like
create table table1 (field1 nchar(50))
in QA.
Now go into EM and refresh tables list, right-click Design on table1 and note the Length property of field1.
Go back to QA and run
exec sp_help table1
and note the Length property (field) of field1.
I assume this discrepancy is due to EM reporting specified field size and QA reporting the bytes used.
Just something to be aware of. codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
You're not a complete programmer unless you know how to guess.
I hope I never consider myself an 'expert'.
<insert witticism here>
create table table1 (field1 nchar(50))
in QA.
Now go into EM and refresh tables list, right-click Design on table1 and note the Length property of field1.
Go back to QA and run
exec sp_help table1
and note the Length property (field) of field1.
I assume this discrepancy is due to EM reporting specified field size and QA reporting the bytes used.
Just something to be aware of. codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
You're not a complete programmer unless you know how to guess.
I hope I never consider myself an 'expert'.
<insert witticism here>