That's definitely curious. From BOL, bit data type described:

bit

Integer data type 1, 0, or NULL.

Remarks

Columns of type bit cannot have indexes on them.

Microsoft® SQL Server™ optimizes the storage used...

One fact that will affect your approach is that bit fields cannot be indexed. See BOL, bit data type, for more information.

Steve Armistead,

Database Administration

Panther Systems Northwest, Inc.

Vancouver, WA

David,

I think you can resolve this without removing RI on the subscriber - enable trace 8207 on the server, which will make the delete/insert into a true update instead, which...

Okay, it appears that the update works in the publisher - is it failing in the subscriber? Does the table in the subscribing database have any constraints on it, like...

I'm not having any particular problem, yet. I say "yet" because I forsee the potential for problems if I need to restore a publisher & subscriber. It's my understanding that...

Try this:

SELECT USER_NAME(O.uid) as [owner],

O.name as [tablename],

I.name as [indexname],

FILEGROUP_NAME(I.groupid) as [filegroup]

FROM sysobjects O,sysindexes I

WHERE I.indid>0

AND I.indid<255

AND I.status&2048!=2048

AND I.status&4096!=4096

AND I.id=O.id

AND type in ('U','V')

AND (INDEXPROPERTY(I.id,I.name,'IsStatistics')...

I quickly ran your examples with identical results - interesting to say the least. Unfortunately I don't have the time to investigate further.

Steve Armistead,

Database Administration

Panther Systems Northwest, Inc.

Vancouver, WA

Thanks for your help, all.

I don't have an identity column available, so modified Steve's snippet and ended up with this test query. It requires a temporary table, but is relatively...

You can also look at running the following:

dbcc useroptions

in the database of interest.

HTH,

Steve Armistead,

Database Administration

Panther Systems Northwest, Inc.

Vancouver, WA

remove the final comma after END

You need to check the length of the city_state field before you take the leftmost chars. There is probably one record (or more) with a city_state length of 3 or...

One solution that minimally changes your approach:

SELECT suppliers.supplierid, users.supplierid,

suppliers.suppliercode

FROM suppliers LEFT OUTER JOIN

users ON suppliers.supplierid = users.supplierid

where users.supplierid is null -- disregard any supplier with existing users

Steve Armistead,

Database Administration

Panther...

This will reset it to 1:

DBCC CHECKIDENT (tablename, reseed, 1)

Steve Armistead,

Database Administration

Panther Systems Northwest, Inc.

Vancouver, WA

Thank you for the reply. I've restored both databases to new names on the same server, and need to get replication working between these new dbs the same as on...

If the 'auto close' option is selected for some or all of the db's on the server, you'll see a long delay in getting the list of databases. You need...