Can I universally change the existing constituent id? To distinguish existing IDs from IDs we are importing from another system I would like to prefix/append the existing Constituent ID with an integer like "111" (i.e. If the current Constituent ID = 987456 I want to make it 111987456)
There are 6 files I get back daily and all but one of them has a date stamp. I have a fully automated process for sending and receiving the files and storing the results in a SQL DB with the file that does not have the date stamp. I now want to use the results file which has a date stamp and need to write a script to…
I am getting concerned about our BBNC Database size. Its over 50 GB large it gets backed up every night and recovery model is set to simple.
We have a decision to make in terms of new hardware to improve performance of our Raiser's Edge database. We will be keeping the application on a virtual server moving to a new Hyper-V host and have been advised to go with a flash-based SAN. Apart from the high cost of this type of SAN I'm reading that it's not necessarily…
We recently had a snafu where a large number of donor credit cards need to be re-run. These donors have already received acknowledgements for their initial CC gifts, which we thought hit the bank. If we run the cards again for identical amounts within the current calendar year, are the initial acknowledgements still valid?…
Hi - Could anyone whose institution has implemented CRM on a pure VM environment (including VM database server), let me know whether you have had any performance problems up to now? We are in the process of deciding whether to go down the pure VM route, and the main worry is whether we would be likely to experience…
Can anyone share a disaster plan they have for their Foundation/Development office. This is not limited to database backups but includes office procedures, i.e., how do you handle a true disaster to your building? What do you do if your hard files or checks in transition are destroyed? Any help would be greatly…
We need to improve the performance of our Raiser's Edge database which has been poor since migrating to a virtual environment (Hyper-V). I'm looking at the following two options and would appreciate feedback based on your experience as to which would be best in terms of performance primarily. We are also considering a look…
Hello Everyone, We recently purchased Auction Maestro Pro which integrates with our Raiser's Edge database. We have our annual gala on December 13th for 1,100 in Miami and I am looking for someone with AMP expertise to hire on a temporary basis in the office as well as the night of the event. If you know of anyone in the…
Hello, Looking at finding out who added and changed CORRESPONDENCEPROCESS. From this query: select CC.* from dbo.CORRESPONDENCECODE AS CC order by CC.NAME What table would I join to, to get the user name, using the CC.ADDEDBYID or CC.CHANGEBYID? Thx, PAW
It looks like you're new here. Sign in or register to get started.