SELECT     TOP 1 *

FROM         MSDB.DBO.backupmediafamily

ORDER BY media_set_id DESC

that will give you the last backup that was carried out, i'm sure you can change it a bit to work out just...

Just tell them what the schedule is, if they're not happy with that then tough, you could do a screengrab if they preferred

Sorry,...

Sorry but you can't get this sort of thing retrospecively out of SQL.

You could always implement some auditing for blocking events or failing that kick off a profiler trace overnight.

See my post above for the expanation

Never tried it, i'm someone from quest will be on to sing it's virtues though

The best tool in the world for this sort...

Anything less than 50 is generally a system SPID, you can't kill em and that's that

We used to get them on one of our SANs, basically it took a snapshot of the data every evening and issues a freeze whilst it's working followed by a...

I couldn't agree more

It's called a 'feature'

Are you using SQL 2000 or v7? and have you set up the constraints properly?

Cant argue with that logic

We'd need a little more information before we could help much, can you post a little detail about what you're trying to do?

I'm assuming everyone else gets a page cannot be displayed error too?

I don't know of any way of getting SQL to script it in the right order, it's a real pain in the backside when it starts loosing dependancy information like...

wouldn't it be quicker/better to do a union between the 2?

select au_lname, au_fname FROM dbo.authors where contains(au_fname, '"Mich*"') 

UNION

select au_lname, au_fname FROM dbo.authors where au_fname_soundex = 'M240'

Assuming that it's actually going...