Is the first backslash always...

Nadrek (4/11/2012)

---

PaulB-TheOneAndOnly (4/9/2012)

---

The only way to know is to test and see what happens.

Either way the key portion of it all is the reorg storedproc, be sure the process does...

Write a select query first to help you identify the data you need to insert.

Tammy Robinson (4/11/2012)

---

Lynn,

Sorry, maybe I was a little unclear. I have a TABLE with the data already in it. I am not trying to create the table. I was just...

Take a close look at the code in the...

My experience setting up mirroring required a full backup and then a transaction log backup from the principal database.

I have had another DBA say the t-log wasn't needed, but I...

GilaMonster (4/11/2012)

---

Sean Lange (4/11/2012)

---

What is wrong with people today? So many stupid posts with little to no information or clarity. Did I miss the memo about today being "Leave your...

Please note how I set things up. This is what you really need to do when asking a question instead of relying on us to do it.

CREATE TABLE dbo.MyTable...

You should probably read this: http://www.sqlservercentral.com/articles/Administration/64582/.

It is quite interesting what one remembers when walking past a conversation one isn't involved in. Random information sometimes has a way making it to ones long term mamory...

Could also be the UPDATE statement.

If you have a development system, try this:

SELECT 1;

WHILE @@ROWCOUNT > 0

BEGIN

UPDATE TOP(5000) w SET

...

Here is my suggestion. Create an empty table, insert the data there, then using SQL, you can insert the appropriate records into the appropriate tables in a set-base manner.

It does matter.

Going down the same road as with of the other OPs. I think it's...

Not sure but I think this individual, xenophilia, should change their name to xenosqlia.

xenophilia (4/11/2012)

---

Thanks for both approaches. Went with drew.allen's because I think Lynn's doesn't get the sum total for all test cases ('Passed', 'Failed', 'Blocked', 'Not Executed') as TotalPlanned and alas...