RBarryYoung (10/5/2009)

---

Woo-hoo! Back in 6th place. 🙂

Now all I need to do is to keep this up for three years... And for at least four people to...

Matt Whitfield (10/5/2009)

---

Jack Corbett (10/5/2009)

---

Anyone else notice less responsiveness from OP's lately? Seems like the threads I respond to have other people post, but the OP doesn't even answer...

Mark Marinovic (10/5/2009)

---

Personally, I have NEVER done a restore through the GUI, either in SSMS or through EM :blush:

I have a script that I use over and over again in...

Yep, I...

Grant Fritchey (10/5/2009)

---

It's also a lot faster to learn the TSQL. Once you know how to type out the RESTORE statement, you'll find that it's quicker than trying to click...

Please show us what the expected results will be. A word description is okay, but some of us are more visual than others.

I wouldn't say dynamic sql is a last resort. There may be justifiable reasons for using it. If you are, be sure to test all input to protect...

No idea. I just copied your code to SSMS and it ran just fine returning the expected results.

I started programming in Junior High. Not even on a "real" computer, an HP 9810 (a glorified programmable calculator) that my grandfather purchased for his medical lab. First...

I had to fix the code (formatting, nothing else) when I tested the code in SSMS.

Also, please read the last article I have referenced in my signature block below regarding Managing Transaction Logs.

Not sure about the lost part, but I'm definately confused as to what he is trying to accomplish. I...

First, I'm trying to figure out why you are trying to nest dynamic queries. Second, if this is the type of code you have inherited, I'd be real concerned...

Francis Yee-483501 (10/3/2009)

---

Thank you for your patience, and I'm back .....

The following example has two sp_executesql(s) which I got the result of the first one passing to the second one....

Cool. It was released in 1962 and ran initially on the PDP-1. Was used by the FE's when setting up the PDP-1 as a final test before turning...