Maybe your logging table needs to be different.

Instead of inserting a row at the completion of each step in the proc, do the calculations in the code and...

Is this error being thrown from SQL, or C#?

Can you post the code? We can't really see what you see.

Eirikur Eiriksson (12/22/2015)

---

GilaMonster (12/22/2015)

---

Eirikur Eiriksson (12/22/2015)

---

One recent poster kept asking over and over again why he was getting an error whilst trying to do something he'd already been told was...

It's better stress relief than choking developers.

Like today. We had a proc...

We used ballons!

If you love what you are doing, spending hours on hours "geeking out" is fun, not work.

This becomes an issue when there are situations created that force you to...

Jeff Moden (12/17/2015)

---

My personal opinion is that you're not really a DBA unless you have a deep understanding of the various types of backups and restores. I think that...

GilaMonster (12/17/2015)

---

Neither. It's there to show readers that...

KenpoDBA (12/17/2015)

---

Give me an example. Because in every single case I can think of, it's much easier to update a table value than it is to add a new...

KenpoDBA (12/17/2015)

---

I'm gonna go out on a limb here and say there's really no need to look at Ola anymore.

Minion Backup does everything it can do and much more... and...

Good work. But.

I find it hard to believe that people keep trying to reinvent the wheel.

Minion backup, Ola Hallengren, https://ola.hallengren.com/ already do what you are trying to do. ...

Jeff Moden (12/16/2015)

---

Steve Jones - SSC Editor (12/15/2015)

---

No, Cleveland...

This would make a great gift for my...

Steve Jones - SSC Editor (12/9/2015)

---

Tavis Reddick (12/9/2015)

---

Could there be a tendency, over time and in a successful devops team, for individuals to learn new skills from the 'other' side,...

ramadesai108 (12/9/2015)

---

I need to change datatypes of multiple columns within multiple tables. How can I do this? Is there any stored procedure that will allow me to change on sys.types...