Robert klimes (1/15/2014)

---

That's good to know that just changing a VARCHAR(10), let's say, to a NVARCHAR(10) might lead to concatenating some of the data. And it's also good to know...

Hi Bob,

That's good to know that just changing a VARCHAR(10), let's say, to a NVARCHAR(10) might lead to concatenating some of the data. And it's also good to know that...

Hi Sean,

At this point I'm considering the possibility of using NVARCHAR. We didn't, back in the day when the database and tables were first created (~1997 or so). I'm not...

Thank you vilyana, pmadhavapeddi22 and Sean for your answers. I tested it using the code that you gave, Sean, on my test database server. Works like a charm. So that's...

Since I'm a developer I have to have Visual Studio. That's essential for my job. Then because I do database development work I've got to have SSMS. We do reports...

Congratulations, Steve, the achieving 5 years with Red Gate, and thus being able to take a sabbatical! I've never worked at a company that offers its employees sabbaticals, so I...

OK, Bill, I've taken your advice....

The job is enabled.

Jeffrey Williams 3188 (1/2/2014)

---

You can also find the next scheduled run from the Job Activity Monitor. Open that - and you will see a column for 'Last Run' and...

Jeffrey Williams 3188 (1/2/2014)

---

Edit the schedule on the job - you should see a section for Duration. In that section, you will have a Start date - for this...

Thank you, that's very helpful! I've just run the sp_help_job SP in msdb...

Bill (DBAOnTheGo) (1/2/2014)

---

I would just right click the job, go to schedules, select the schedule, and hit edit.

See if the schedule type is listed as recurring, see if the Enabled...

Hi Bill,

I think it's been moved. I'm looking at it now in SSMS. The schedule is there, with the name that I gave it ("Beginning of Quarter"). It's in the...

Steve,

At the end of this podcast you mentioned again, that you'd be stopping the video podcast. Or at least cutting back on it. You also said that you'll be starting...

batgirl (12/13/2013)

---

In fact, my husband and I are giving ourselves a trip to the west coast to spend the holidays with his family - it will be his first time...