First things first, install SP3 as it protects against the slammer virus, not saying you have it but at least will rule it out.

When you turn on everything for profiler...

I just read it, pretty darn funny. The URL is here - http://www.ucomics.com/foxtrot/2003/09/14/

Ray Higdon MCSE, MCDBA, CCNA

I'm a little confised by the code on what's being done here, how about this

create trigger tbltrg on table

for insert,update,delete

as

declare @one datetime,@two datetime

set @one = (select date from inserted)

set @two...

No, not out yet. It is currently called Yukon and I think it's to be released Qtr04 2004.

Ray Higdon MCSE, MCDBA, CCNA

I've had this multiple times and running dbcc updateusage has fixed the reported free space amount, I'm interested to hear what did fix the reported amount if that didn't.

Ray Higdon...

http://support.microsoft.com/default.aspx?scid=kb;en-us;314515

http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=7395ec1b-199f-42bc-a31b-2056adf73f94

http://www.sql-server-performance.com/sql_server_log_shipping.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/logshippinginsqlserver2000.asp

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/prodspecs/logship2.asp

HTH

Ray Higdon MCSE, MCDBA, CCNA

You can use a third party tool like Lumigent log explorer to read the logs or use Lumigent Entegra for a more fully auditing tool. If you don't want to...

Yes

Ray Higdon MCSE, MCDBA, CCNA

How many pages do you have? If you have less than one full universal extent (8 pages) I've seen where you can not fill it any more efficiently.

Ray Higdon MCSE,...

You can try DBCC updateusage, or the switch with

exec sp_spaceused tablename, true

to recheck the allocation automatically without running updateusage.

HTH

Ray Higdon MCSE, MCDBA, CCNA

You might consider log shipping if you are using this for a reporting server. I believe it creates less of a load on the publishing server.

HTH

Ray Higdon MCSE, MCDBA, CCNA

To see the size of the DB adjusted run DBCC updateusage. See BOL for script details

HTH

Ray Higdon MCSE, MCDBA, CCNA

You could do that. If you right click the job (not the maintenance plan) and click view job history it will open a new window. From there you can check...

This is a generic error, see if you can find the exact error by looking at the details on the individual job steps. This sometimes has to do with security...

When you say lowest level, do you mean on the dimension? Like the user would have to drill down to get to this level? If so, should be no problem...