Your first code block actually has the proper start. You just need to move the SET of the variable of the table above the SET for the strSQL command.

I...

First, don't use wordpad as a text editor.

Second, exactly how did you save the files? Are you sure you saved tham as full fledge text files?

You have to complete the variable substitution where you are building the SQL command, not in the call the sp_executesql.

jcrawf02 (6/10/2009)

---

Too...

Brian Ferguson (6/10/2009)

---

Code as indicated does not work for me either.

By adding a c:\mssql folder (did not have one on my system) AND changing the the data file folder to...

lmu92 (6/10/2009)

---

Need some advice on how to respond in the future...

While venting:

Do you think that I've overreacted on that post http://www.sqlservercentral.com/Forums/FindPost732338.aspx

I mean, posting sample data in Excel is fine for...

I have to side with Gus on this one. Any tool has the possibility of being misused. What we are running into is the fact that there is...

Okay, venting...

We have our White House Window Washer, our PhD Candidate, our True-Relational Zealot. Do we call this one, The One Who Can't, or Won't, Read?

I have a suggestion, please make Books Online your friend.

Let me help you with this one, just click here.

jcrawf02 (6/10/2009)

---

mazzz (6/10/2009)

---

Back to reality now, at work after a month-long holiday... It was a shock to the system (although possibly the biggest shock was that I remembered my network...

What's the problem?

SwedishOrr (6/10/2009)

---

Lynn,

Thank you but I will work on Darryl's suggestions. The code in question was posted already. Adding that line in takes the overall process from 4 hours...

Please do the following:

1) Read the first article I reference below in my signature block regarding asking for assistance.

2) Post the DDL for the tables involved in your query.

3) Post...

Truth be told, I wouldn't. I am unaware of any tools or products that would read a MS SQL Server t-log backup and restore it to a MySQL database....

And, now for the "I really should have read that error message before posting Award!"