nulls are indexed. create a unique index on a nullable column and then try to insert 2 rows with null for that column. In that case null = null.

I...

check Denormalisation on the web. There a whole set of info needed to take that decision

create a parameter-table with a column "lastkeyvalue". Read that value for update and than its all up to you. Others cannot reach it until you release it.

That is if you...

This is how I resync users.

-- login sync

-- print db_name()

use userdb -- User-db

go

print 'print @@servername + '' / '' + db_name()'

print 'go'

go

declare @username varchar(128)

declare @Musername varchar(128)

declare @IsNtName bit

declare @sql_stmt...

erata : "decoment" should be "document"

/ "relaton" should be "relation" 😉

assuming a unit has only one "parent"-unit, you could have an entity "company" an other entity "Units" with a relation to "company" and a third entity "UnitRelations" where you decoment...

In QueryAnalyzer you could you "show execution plan" or "display estimated execution plan".

SQL2000 ? Make the user DDL-admin in stead of DB_owner. Look at BOL.

Thanks to implicit conversions. Rule 4 never thrust a default-behaviour. And it strikes when you don't expect it.

try it with substring(text,1,case when len(text) > your_max_length then your_max_length else len(text) end.

If you don't like bulk-insert, you can minimize logging with simple-recovery-setting (sql2k) or truncate-log-on-checkpoint (sql7) when using small transactions. This means you have to chop up your input in chuncks...

Take a look at sqlserver books online (BOL).

db_datawriter can update all tables in the databasen, except is that user has been denied write rights. look at BOL.

I know it's primitive, but it works.

set nocount on

go

create table Ttest (id char(29) not null, info varchar(20) not null)

go

insert into Ttest values('10069905,7/31/2002,2020705358','380214 196145 0000')

go

insert into Ttest values('10069905,7/31/2002,2020705358','380214 197183 0000')

go

insert into...

If nothing found in the KB then I'd go for the working solution. Upgrade to sp2 move the 6.5 dbs and afterwards upgrade to sp3.

I've installed sql2ksp3 with success, but DTS gave me headaches. All worked but those connecting to DB2 UDB V7.2 (rtm version). Contacted pss and it took a couple of days...