Situation resolved. Completely unrelated to SQL configuration. :hehe:

Installer will be waterboarded.

I have seen it trying to add rows to tables before it added the table 😉

Interesting. Thanks.

I avoid the system tables

So don't add the foreign keys for new tables until after...

Still investigating. Yes, the clients revolt when we have to take them down for...

For the last 9 months? If I haven't got it resolved by now, it's far to late to worry about it.

You can make a snapshot of just the stored procedures?

I'm thinking it must be the file access permits. Unfortunately, the user is disappearing with his laptop.

Database keeps running. Snapshot agent doesn't. Always stays in active jobs and never finishes. Of course, now they've noticed that the data from the existing subscriber isn't merging.

Um, I don't know. Can't seem to get the same result from the stored procedure again.

Curious...

It's telling me it's missing an index: Table InventoryGrouping, Column ClassValuePK, but I already have an index:

CREATE NONCLUSTERED INDEX [IXClassValuePK] ON [dbo].[InventoryGrouping]

(

[ClassValuePK] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE ...

Not sure you've gained anything.

select ... convert(varchar(16), DecryptByKeyAutoCert(cert_id('MyCert'),

But now, isn't the key actually "MyCert"? If somebody were clandestinely querying your database, all they'd need to figure out is...

Well, Lynn, you posted a nice solution that gave a result. I said it was nice. (Scroll up) Seeing it run, I was able to settle on a variation. My...

You have to guess

How's this?

select customer.CustomerPK, Location.LocationPK, CustomerLocation.CustomerLocationPK

FROM Customer

CROSS JOIN Location

left outer join CustomerLocation on CustomerLocation.CustomerPK = Customer.CustomerPK AND CustomerLocation.LocationPK = Location.LocationPK

WHERE CustomerLocation.CustomerLocationPK IS NULL

Nice, Lynn!

select

cust.CustomerPK,

loc.LocationPK

from dbo.Customer cust cross join dbo.Location loc

except

select

custloc.CustomerPK,

...

I never think of union.

This isn't quite it either. I'm looking at 18 customers and 2 locations, so there should be 18*2 customerlocations. Your query finds me 2 rows, but...