Probably the easiest way is to pull up the properties of the Job and check there. If you want to grab it via T-SQL, I've been using the code...

Thankfully my boss has been involved from nearly the start and knows what's been...

Greg, thanks for the suggestion, thankfully the method of "upgrading" here is to deploy a new server, clean-loaded with the new OS. I think what's potentially going on is...

Jeffrey Williams 3188 (11/26/2013)

---

If you don't specify one of the options to fix corruption - CHKDSK runs in read only mode. As far as I know, this would not...

/rant mode on

Frickin' bloody pain in the tuckus idiotic mindless rules drones! Gotta go in early tomorrow because it's entirely possible a SQL server and a couple Oracle servers...

Gotta love situations like this...

Please install this program to make it easier for us to make your server (OS) more secure that requires this OS feature you've never needed before...

So reading yet another "how do I shrink / truncate my log files without running log backups" topic, I had (what seemed to be) an incredible idea!

Why not ask MS...

My understanding (and I thought I'd posted a similar question, but can't find it) is that you will not be able to restore the Copy Only backup, then the last...

Ed Wagner (11/8/2013)

---

jasona.work (11/8/2013)

---

So, put up gutter guard over the week to keep the back gutters on the house from filling with leaves, still need to get some to finish...

I think at this point, I'd like to start getting the hang of SSIS.

I'm one of those people who learn best by "playing" with something, which means I'd mostly have...

So, put up gutter guard over the week to keep the back gutters on the house from filling with leaves, still need to get some to finish off the gutters.

Might...

bala2 (11/7/2013)

---

In 2000 server we have list of all packages deployed in the MSDB database and we dont any Filesystem packages.

Can we do in below way for migrating the those...

It is possible to migrate DTS packages to SQL2008R2, but I would also agree with Andrew. Long-term, you and your users will be better off migrating the DTS packages...

Noetic,

That's what I was afraid would happen. I'll have to talk this over with my boss, see how he wants to tackle it. It was like this when...

Steve, John, just noticed your replies.

Steve, the good news is, the service accounts for SQL Server / Agent are controlled at the domain level, and do not expire.

As for the...