lol..yeah I've heard bad things about current logic

googles ' DelimitedSplitN4K'....oh cool. Thanks Jeff!

thanks sir - kinda figured that !

HI Jeffery

I feel pretty dumb for not trying the disable. I did remove the DB's from the user on the primary and noticed that then they were removed from secondary....

Position just opened if anyone is interested. Working remote is a possibility.

Thanks Jeffery - Appreciate your help! Gotta be a group membership.

Sorry bad response.

are you trying to say these other groups he is a member of - also have not been granted access to these 'other' databases he is able to...

Good thought. Yes, but none of the groups he is in have access to the same DB's as he does. (bangs head on wall)

• This reply was modified 2 years, 6 months ago by  krypto69.

Awesome. Really appreciate.

Great stuff! I hadn't thought of a few of these.

• This reply was modified 2 years, 9 months ago by  krypto69.

this worked

ALTER TABLE dbo.claim

ADD CONSTRAINT PK_CLAIM_ID PRIMARY KEY CLUSTERED (claim_id);

GO

ALTER TABLE [dbo].[PEC_Claim_Supp]

ADD CONSTRAINT [FK_claim_PEC_Claim_Supp] FOREIGN KEY([claim_id])

REFERENCES [dbo].[claim] ([claim_id])

GO

Thank you SO much Brian. Really appreciate  your help.

Oh I see....now. Thanks! Yeah I like it also.

Okay gotcha..

This is my work in progress....I was hoping to create the below in the step before the job starts. But it isn't working...

Declare @time as int
SELECT...

• This reply was modified 4 years, 2 months ago by  krypto69.

I don't think you guys should publish a 'stay tuned' article. Wait till it's done, then put the whole thing up. What good are the six queries if they are...

Thanks guys. Appreciate the advise.

Thanks everyone. It wasn't ghost records. 

I tried restoring the DB in a non H/A sever- it released the space.

So I tried again in PROD -...