Check sysjobs and sysjobhistory in msdb. Is there a job with that name listed?

http://msdn.microsoft.com/en-us/library/aa260415%28v=SQL.80%29.aspx

http://msdn.microsoft.com/en-us/library/aa260416%28v=SQL.80%29.aspx

It does not work, and cannot be made to work. This is by design from Microsoft.

You can use a third party solution like SQL Prompt from Red Gate software.

Disclosure: I...

Microsoft Operations Framework

http://technet.microsoft.com/en-us/library/cc506049.aspx

It stays connected for me. It might drop overnight, but it seems if I'm opening stuff within a few hours of each other, it remains connected.

I see people go both ways on this. Ultimately since you can't usually guarantee that xx piece of technology caused the corruption, you bring the system back online. I've seen...

What does that mean? That's a...

I agree with Sean, nvarchar won't really hurt and if you have EE, you can compress the data, so it won't double the space if not needed.

However, even uncompressed, I...

This (http://www.sqlservercentral.com/Forums/Topic993883-146-6.aspx#bm1008735) seems to indicate this is by design. I would shrink the file, looking to deallocate the LOB extents.

The Rockies are still in 2nd in the West, but the worst record in the NL after the 11-2 start. Not sure they'll be in things this fall if they...

Hmmm, not sure about image. Have to look it up, but I'd guess sp_spaceused is broke.

Did you delete a lot of the image data?

Glad you enjoyed it, Gus (and everyone else). Sorry I didn't get down there to see you, but I needed the downtime. Would have canceled anyway since my wife was...

Ah, sorry. The explanation editor box is small for me and I didn't see that part of the explanation. It's been fixed.

My apologies.

No, ghost cleanup has already run for you. It's possible the deletes happened on pages/extents that are mixed with live records, and so you can't easily remove those without the...

On a server you can query sys.servers to see remote servers registered. That doesn't tell you where ServerA is being used, but it can tell you if you are on...

http://msdn.microsoft.com/en-us/library/aa933139%28SQL.80%29.aspx