Have you tried this:

SELECT

dbo.organisations.organisation_shortname as org_shortname,

sum(dbo.qry_positions_with_costs.media_cost_per_pos) as tot_media_cost,

sum(dbo.qry_positions_with_costs.prod_cost_per_pos) as tot_prod_cost

from

dbo.organisations, dbo.qry_positions_with_costs

-SQLBill

quote:

---

The confusing thing is that there was still plenty of disk space left on the drive at least 5 gig. The file...

Well, your posts are definitely of help. I never even thought about the option you suggested.

It would be nice if we could just use the category id, forum id and...

Frank,

I agree about moving or merging threads. But let us say I see a post about datetime datatype and I know of a great thread that covers the same subject....

OOOPPPSSS, it was the August 29th QOD that has several different threads going.

-SQLBill

These are some of the causes for your error...as you can see it depends on what you were doing at the time:

174512-If a stored procedure or trigger is created that...

What were you doing when you got the error?

Have you gone to http://www.microsoft.com and entered the error (EXCEPTION_ACCESS_VIOLATION) into the search?

-SQLBill

What is happening when you get that error? Are you doing a large transaction? I've only seen that error when my TEMPDB isn't set to grow fast enough for the...

What is the size of the transaction log space? When you backup the database it looks at the total size of the database space. This includes the data files, log...

Which edition (Standard, Developer, Enterprise, Personal) did you install?

Reason I ask, is that ONLY Developer, Personal, or MSDE can run on XP.

If you are using one of those editions, then...

I'm not sure I follow all your comments, but if I understood you correctly you are backing up the TEMPDB. I would never waste time doing that. TEMPDB is just...

I've never tried using the native SQL Server backup commands to go directly to tape. My largest database is approximately 280GB and I use SQL Server to back it up...

Allen_Cui provided you the simple way to clear the Tempdb log. But you really need to find out WHY it was full.

1. Did you run out of disk space?

2. Go...

What do you mean by:

It should not be caused by Auto Close

That IS the message seen when Auto Close is set to ON for a database.

If Auto Close is set...

Your databases are probably set for SIMPLE Recovery Mode. You can only do log backups if the mode is FULL. (Go to Enterprise Manager, drill down to the databases, right...