you need to enable that event as a logged event :

select * from master.sys.messages where message_id = 2627 and language_id = 1033

is_event_logged = 0.

To change it use sp_altermessage

Cheers,

look in the Errolog it should give you more info

Not sure why you said that. I just created a test login assingned it to the SQLAgentOperatorRole and the login *can* run SA owned jobs.

Which service pack and Edition are...

Clear, Simple and to the point.

Good Job!

Thanks,

It *is* doable:

select a.* from

openquery(SERVERNAME,'SET FMTONLY OFF; EXEC(''dbcc sqlperf(logspace)'')') a

Just make sure that:

1.you have the necessary permissions

2.lazy schemavalidation = true

Cheers!

Can you please don't turn this thread into another Bankers rounding ....

PS: "You" know who "you" are

wow. This thread started in 2003 and still people are re-using it !

the fastest method is to create a table in the DB with a TriggerXEnabled property and have the trigger code run with "if not exists( select * from configtable where...

those upgrades refer to OS upgrades not to DB upgrades

Just one word ... WOW!

select *

from [your table]

where datepart(dw, [yourdatecolumn]) in (1,2,3)

Or disable the FK but then after you do you will probably need to run dbcc checkconstraint on the FK to mark it as trusted

have a look at datepart()

Bill, you got it!

The only thing is that the "columns" fill factor is not applied to the "table column" is applied to the INDEX BTREES that you created.

>>>trunacte statements are not logged ... <<

Beg to Differ .. well slightly

TRUNCATE statement *are* MINIMALLY logged. they are logged; just page deallocations...