Non-production environment flag - how to set in SQL

David Wanless

Hi all,

Does anyone know how to set the ‘Non-production environment’ flag in SQL?

I've been searching and can't find which table it's stored in.

Ciao,

David.

John Auwaerter

Hi David,
If you are referring to the BBIS setting, I believe the following should do it:

exec dbo.USP_INSERT_UPDATE_CRMBBENVIRONMENT @Id='ACC537E6-028D-4C72-9AC8-0E2BE19636AB',@Text=N'Production',@IsActive=0
exec dbo.USP_INSERT_UPDATE_CRMBBENVIRONMENT @Id='1CBC46DA-71B2-40FF-BB11-26B1D9073515',@Text=N'Staging',@IsActive=1

Phil Higgs

HI David We have a global change to set the non-prod Scheduled emails, and merchant accounts. You may need to change one search criteria, where we use Plan accounts. I'll send a link.

Phil Higgs, Plan ANO

David Wanless

Thanks, John and Phil. Yes, that's the table. Thanks very much for your help, and thanks, Phil for the Global Change code. That's enabled me to set some other things as well.

David Wanless

Yash from Blackbaud Pacific was also very helpful in finding this table (CRMBBENVIRONMENT).

Gregory Dellas

Hey Phil, are you able to share the documentation for this global change please. - Sounds like it might be handy for broader use :-)