WOW! You're right, that is not going to be easy or quick. Someone else set up this new test database, and now I wish he hadn't done that....

OK, I've found the problem. Apparently the username is case sensitive. I didn't expect that. I know that the password is case sensitive, but I didn't realize...

It is hard to tell, as the stored procedure where it is failing is the first one that it hits.

The weird thing is that, if I connect to...

K. Brian Kelley (8/14/2008)

---

Grantor is simply who granted the permissions to the grantee. You can change this by revoking the permissions and regranting it.

Do the SIDs match up for...

Thank you. We don't have VSTE for anybody, let alone DBA's, so I guess I'll go with the PowerShell method.

"VSTE for DBAs". What is VSTE?

I'll review your PowerShell videos, thanks.

Gail,

The recovery mode is Bulk-Logged

No log backups are running, that I can see.

No replication.

We don't have a point-in-time recovery requirements for these databases.

Running the SELECT you specified, for...

This topic is very interesting to me, in fact I've already posted a message about it on this site's forums. My biggest concern is, should we be putting our...

OK, I see by this article[/url] that Microsoft has a working relationship with Novell for virtualization software and Microsoft's software. ...

I'm...

George, I'm getting a 9.00.3068.00 when I run the @@version.

George, it is a rather large .LOG file (~ 9 MB in size), and I see several errors in it, even at the beginning. However, I will assume that...

Lynn Pettis (7/3/2008)

---

Though I didn't respond to your original post, I assure you, not a problem. Sometimes asking for help is all it takes. In asking for help,...

OK, this is very weird, but I just re-ran my query again, summing all of the Amounts and GrossReceiptsTax added together, against the fund, and it came out exactly to...

You're right, I did forget to mention the data types. In the MoneyPools table both the AnnualAllocation and the RemainingValue columns are of type money.

In the Vouchers table the...