Part of your problem could be the two corelated queries in the select statement.

Try this code and let us know if it work and still returns what you expect:

select

...

What is the base type of the blob in the source database?

Database Mail uses SMTP, not MAPI.

Here's one for you. My oldest daughter was about 2 years old. She caught chicken pox while at day care. Guess what, neither my wife nor I...

Also, fyi for others reading this, the values reported in sys.sysfiles are in 8K pages, so multiplying those values by 8 should match what you see in windows explorer.

😎

Adam Bean (3/14/2008)

---

sys.sysfiles is reporting:

- data - 750904kb

- log - 30152kb

file size on disk is reporting:

- data - 6gb

- log - 241mb

The above two match up and should be correct,...

Pardom me on this one, but the screen print (at least for me) is a little fuzzy (and it could just be my old tired eyes). Could you list...

Be sure to report back your findings. I'm sure I am not the only one interested.

😎

Okay, could you please explain what has you baffled? I've looked at your screen shot, but not sure what I should be looking at.

😎

I'd be curious about this as well. I'll give you my swag, the transaction log backup will work, but the commited transaction may not get deleted. Sort of...

Basing this off our config.

We are not in a cluster environment, so this may be different for you.

Open Component Services, expand Component Services, expand Computers, right click My Computers and...

Meeting has been delayed. Question, what version of Windows Server are you running? We are using Server 2003 R2 Enterprise Edtion.

😎

This is scream day, meetings just keep getting in the way.....

Any way, on the way to another one, but in fixing this issue for our PeopleSoft systems, I made no...

To get you started (I have to go to a meeting now), search the Microsoft Knowledge Base with yoor error message. There are a couple of KB articles that...

This is a DTC error, not really a SQL error. Since you are only doing a select query in Q2, it should work if you remove the BEGIN TRANSACTION...