Thanks guys! VERY MUCH !

Jeff you are always on point. Thanks for the lesson and Drew also.

Happy Holidays and good karma to you all!

Really good points here. Thanks again.

Ratbak I...

Thanks Guys. Gonna do some testing but most likely going with DNS alias (CNAME)

Thanks again.

Hey Lowell - I completely forgot about my logon trigger - it was giving me fits for hours! THANKS!

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 3 years, 7 months ago by krypto69.

Awesome. Really appreciate.

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

• This reply was modified 3 years, 10 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 5 years, 4 months ago by krypto69.