Paul,  I don't quite follow what you're asking, but here's some thoughts to help focus in a bit: In the BMC, you can disconnect users from the RE database from the Active Users screen. But it sounds like you don't have the db attached in the BMC yet, so what exactly do you need to disconnect? If you've got the SQL ...

I would caution against the use of "SELECT *", especially with that many joined tables. It's very useful in development so you can see all the columns available, but to anyone who wants to develop a production solution using these queries, please limit your query to just the columns you will need. Your database server admins will thank ...

Hey Matt, I would caution against custom indexes, if for no other reason than they may complicate schema changes made by upgrades to RE in the future. For example, the RE installer may receive an unexpected error from SQL Server about not being able to modify a column with a custom index, and they may not be properly trapping an error condition ...

Hi Marni, You can check out the official word from the US Post Office in this handy PDF. They don't really state a preference, but they do refer to using a second line as the "alternate method", so that implies that they want you to list it after the address on the same line. At our org, we use two lines, since that's what our ...

I think JoAnn's right -- it really sounds like a split gift somewhere. What if you change your Query to use "Gift Amout" under "Gifts", but also add in "Split Amount" under both "Campaigns" and "Funds". You might find a one gift where the receipt amount doesn't match the split amount.

Hey Chris, Glad it's working. I'm happy to share our Disaster Recovery (DR) plan, but I need to put up a little disclaimer: your data and its protection are entirely up to you, and any advice you receive from anyone about backups/recovery should be thoroughly tested and researched further. Just because it works for them doesn't mean ...

Download and install the Management Studio for SQL Server Express and you'll get a GUI to manage SQL Express (which used to be called MSDE). From the Management Studio, you can attach the database easily. The attach wizard will give you an opportunity to change the name of the db as well as the file paths for the MDF and LDF files.

Don, Is the 12 month period based on just month and year, or month and day and year? For example: if a $500 gift comes in on 10/15/2009 and another $500 gift comes in on 10/30/2010, would those be considered as $500 in Oct 2009 and $500 in Oct 2010? If so, then that's $1000 within your 12 month reporting window, but if you're factoring ...

 Hi Jeff, You need SQL Server. Or SQL Server Express. Let's back up a little: the Raiser's Edge database, at the file system level, has very little to do with Access or Excel. It's true that the database "lives" inside a few files on the file system, but those files are not designed to be accessed from outside the SQL ...

I'm sure someone will chime in with a way to do this from within RE, but for now, in Excel, you could add a Group By on the gift attribute that stores the event name. You could also build a pivot table off that data set that would calculate the numbers you're after.