Hey, has anyone gotten today's SSC newsletter? Mine's usually in the inbox by 7am EST and nothing yet.

Man, that's a tough...

Ninja's_RGR'us (11/21/2011)

---

Gianluca Sartori (11/21/2011)

---

Koen Verbeeck (11/21/2011)

---

I kid you not.

I'm even surprised myself 🙂

We even had an Indian Summer that was...

Eric M Russell (11/17/2011)

---

Dave62 (11/17/2011)

---

Jack Corbett (11/17/2011)

---

It's sad but I've seen code that is ripe for SQL Injection, commented it shouldn't be allowed and that if it was my decision...

Dave62 (11/17/2011)

---

Jack Corbett (11/17/2011)

---

It's sad but I've seen code that is ripe for SQL Injection, commented it shouldn't be allowed and that if it was my decision it wouldn't be,...

Ah, I can always count on SSC for a laugh.

The work from home DBA is what I aspire to be. Hopefully that will happen soon.

I don't have to...

drew.allen (11/17/2011)

---

The best way is to avoid using a cursor in the first place. They perform...

To get back to the original question, Jason and Remi :-P.

I think we need more information about what your job duties are supposed to be before anyone can really say...

vroslan (11/17/2011)

---

Hi Martin,

Thanks for aswer.

In a package properties I set EncryptSensytiveWithPassword and inserted password.

When I try to extract data from sql server to sql server the job running without problems.

I...

It's sad but I've seen code that is ripe for SQL Injection, commented it shouldn't be allowed and that if it was my decision it wouldn't be, yet the code...

Then like I said all I'm aware of is msdb.dbo.restorehistory which does not give you exactly what you want, but it does tell you when you are had a restore...

It looks like you are using maintenance plans to do this process so you should look in the maintenance plan logs for better details a query like this:

SELECT

...

Duplicate post. Please post answers here

Do you have the limit the size of job history log checked? If it is what are the # of rows that you are keeping?

I don't know that you want to join back to the original table, but you should use both inserted and deleted because the functions update and columns_updated consider a column...