Not sure what's recovered. You'd have to look further up in the log, but this instance has two startup procedures that are being executed. You can mark a stored procedure...

Doh!

It's here: http://twitpic.com/3x4s18

Brandie Tarvin (2/7/2011)

---

Oh, I...

VirtualBox.

First, do you have database files and log files separate? If so, you would typically want to back up to the log file disk, not the data file disk.

If not,...

You can just set a new size for the .mdf files with ALTER Database

USE master;

GO

ALTER DATABASE AdventureWorks2008R2

MODIFY FILE

(NAME = test1dat3,

SIZE =...

Is there a schedule set for the job? If you look in the properties, what does it say?

Is SQL Agent running?

Look at Pivot or search for crosstab queries. That's what you are trying to do.

Note that these aren't very efficient, so as long as this isn't a large set of...

kenny-892481 (2/7/2011)

---

I'm confused Steve. You would want to fire one of your employees if they asked for a raise more than once, but you would want an employee that lied...

Brandie has a great point. What you have written will move everything, but you ought to have error handling.

I might also write a "check" routine that verifies the counts of...

Thanks, everyone, and SQL Saturday #60 was great. I enjoyed Jeff's session, and conversation. Ron (bitbucket) made the hotel deals and helped ensure the event ran very smoothly, and gave...

djackson 22568 (2/7/2011)

---

Applicants should be honest. It is better in the long run. Companies need to wake up, however, and stop treating people like dogs. They will...

If you need more help, search for cross tab query or report. That's what you are doing. You can also look at the PIVOT command.

SPIDs are reused, and I don't think you can track this down. Not sure if anything that you are looking for is in the default trace, but worth a look.

The...