//Ravi (11/12/2013)

---

Keith, Thanks. That did the Trick. Here is the correct Code:

END TRY

BEGIN CATCH

...

Nadrek (11/8/2013)

---

It is not generalizable to restore every single t-log backup in the directory you store backups - this script as presented only works if a human has already selected...

bradphilp (11/8/2013)

---

The reasons we don't like cursors are due to the unpredictability of locks, not to mention not set programming. Anything you can do with a cursor, you can do...

Larry Aue (11/8/2013)

---

Use the INSENSITIVE keyword in your declare statement and the cursor is essentially just like using a temp table, since insensitive cursors don't keep track of changes that...

analytical

This code is a bit confusing to follow, but as a previous poster indicated your statement

WITH cteSource ( NAME, ID, GR, SC, Ethnicity, Gate, SpecialED, LF,...

has...

Chestnuts

Perry Whittle (11/3/2013)

---

Firstly, don't use administrative shares for file\folder access, create a new share at the appropriate folder level and ensure you set the following for the account the SQL...

Jeff Moden (11/4/2013)

---

The biggest advantage is that you...

I'm not sure exactly what the actual cause of the problem was. I presumed that it had to do with the way the VM environment allocated memory.

In...

I guess better stated is Out-of-Date statistics.

Kurt

Greetings all;

Just an update. I was experiencing issues with the entire application stack so I was able to take advantage of rebooting the SQL Server. It...

clayman (11/1/2013)

---

Kurt W. Zimmerman (11/1/2013)

---

clayman (11/1/2013)

---

Kurt W. Zimmerman (11/1/2013)

---

If I'm going to move data from one server to another via Import/Export I will script out the source database...

clayman (11/1/2013)

---

Kurt W. Zimmerman (11/1/2013)

---

If I'm going to move data from one server to another via Import/Export I will script out the source database first and place it on...

If I'm going to move data from one server to another via Import/Export I will script out the source database first and place it on the destination box. Then...