Hello Grant and Gail,

Yes, they are only running a single log backup. It happens once a day, immediately after the backup of the database occurs.

The ASI database is using the...

v.collazos (2/14/2014)

---

Rod at work (2/14/2014)

---

Mauricio N (2/14/2014)

---

I've used VMWare Player (now Player Plus) and VirtualBox. Both are good, unfortunately it's not so easy to change from one to another (I've...

Mauricio N (2/14/2014)

---

I've used VMWare Player (now Player Plus) and VirtualBox. Both are good, unfortunately it's not so easy to change from one to another (I've tried this week).

With...

Craig, it was your suggestion of running a server side trace that put me onto the possibility that the code had left something out. All I saw was the SELECT...

OK, I think I've found out what the problem was. There wasn't a call to the save routine, in the user control that hosted those 8 data elements. I've put...

Evil Kraig F (1/27/2014)

---

I'd start with running a serverside trace on the 2012 server to determine if the commands are even getting there.

If the commands are reaching the server, then...

Good article, Steve. I don't see how to get around this one. Where I work there aren't a lot of people who even know how to open up Excel, let...

Sean Lange (1/15/2014)

---

Rod at work (1/15/2014)

---

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...

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....