Can you please post:

1. the line that is failing in your script.

2. the table and index CREATE statements when you script them out.

Craig Farrell (10/21/2010)

---

Here's the DelimitedString8k function that's been heavily worked on round these parts. Modify to suit your needs. I didn't create it, didn't work on it, and...

gmrose (10/21/2010)

---

Thank you again to Lutz and Wayne. I updated my script per Lutz' suggestions to use table #tmpChecks instead of table variable @tmpChecks. I made some minor...

Craig Farrell (10/21/2010)

---

Ahhh, Cheap fun...

Going up to the SAN on Monday morning just before everyone starts needing to crank out work and hotswapping one drive in every RAID 5 array......

Why don't you try downloading it again? This way, you can be sure.

I suggest you set up a test environment. You can actually do all of this on one server if you want...

Set up a database.

Set up log shipping to another database...

Ray K (10/21/2010)

---

Okay, that's what I figured.

I ended up just creating a simple SELECT statement for the column immediately following the INSERT. I'm just writing a quick 'n dirty,...

It really sounds to me like you downloaded one media and it's been renamed, making you think it's a different edition.

I'm assuming that you want to compare to the previous row, sorted by the date.

So, does this do what you desire?

-- See how you start off by actually creating a...

In the case of eventid 2, there are three entries. So, are you looking for the difference between two rows, sorted by the eventid/timestamp?

Even better... please read the first link...

You can either use a table (table variable, temporary table, permanent table) (results to into it), or not (results to client). But not to a "regular" variable. See the BOL...

If you use the SSMS Transaction Log setup wizard, you will see that you can log ship to multiple secondary destinations. Each can have their own copy/restore schedule. I've log...

Gives those that do know something to laugh at.

ColdCoffee (10/20/2010)

---

Wayne, in ur solution, you are basing your order over ckid column (Sequence = ROW_NUMBER() OVER (ORDER BY ckid) )

What if ckid is not in a proper order...

Do you understand the code that you implemented? If you can't explain to...