Wayne, I think you need to remove the "\"...

I recently went to install the ODBC connector and create a linked server to MySQL as described here http://www.sqlservercentral.com/Forums/FindPost1332192.aspx. I ran into and solved 2 problems, so I figured...

Thanks again for your help.

I did get this working from my workstation, connected to both SQL Server and MySQL. That at least gets me to the point of being...

Thanks Lowell, I'll take a look at this.

Unfortunately, my first pass at trying to execute a query in SSMS against the MySQL linked server (after creating the linked server) resulted...

RobertYoung (7/16/2012)

---

rmechaber (7/16/2012)

---

You state:

My understanding of disk sectors has always been...

You state:

My understanding of disk sectors has always been that the...

Brandie, here's a link I found that suggests it is possible to fail a job step with RAISERROR:

http://www.bidn.com/blogs/Daniel/ssas/2313/force-a-sql-agent-job-step-to-fail

I just tested this by creating a dummy Agent job with 2 steps....

Would it work to have your job step wrap the execution of the remote SP in some local code; the wrapper would check for a return code indicating successful execution...

Square that. 🙂

Errrr.... double that!

Rich

Got it wrong for the best possible reason: I learned something.

Like many others, I thought a FULL backup was required to re-initiate the log chain, probably because that's what most...

Someone -- Grant Fritchey maybe? -- once said something that has stuck with me: you don't need a backup strategy or plan....

You need a restore plan!!

I get failed backups...

Thanks for the question Hugo, and more thanks for your inevitably thorough follow-up explanations and replies to objections.

I got it wrong in the "best way possible" which for...

Thanks Eugene, that didn't work either: I got this error:

Msg 7416, Level 16,...

ralph.bacon (5/24/2012)

---

rmechaber (5/23/2012)

---

...I found this write-up useful in explaining the benefits -- and issues -- related to XACT_ABORT and TRY..CATCH: http://www.simple-talk.com/sql/t-sql-programming/defensive-error-handling/[/url].

For example, there's a nice demonstration of how XACT_STATE()...

Might be slightly off-topic, but I found this write-up useful in explaining the benefits -- and issues -- related to XACT_ABORT and TRY..CATCH: http://www.simple-talk.com/sql/t-sql-programming/defensive-error-handling/[/url].

For example, there's a nice demonstration...