Well, looks like Jeff's twit logged on today, but I haven't heard squat regarding the code I provided. I guess the first pork chop Jeff gets to launch is...

Double posted. Answer here: http://www.sqlservercentral.com/Forums/Topic620701-391-1.aspx

Please don't double post.

I think the shop I am in now is in the middle, but small enough that I still have to do development work or work very closely with the developers.

My...

You may want to see the comments I made in the code, but bottom line, your code is your problem.

ALTER PROCEDURE dbo.spEliminarEjemplarSolicit

...

Wayne West (12/16/2008)

---

Andy Leonard (12/16/2008)

---

Lynn Pettis (12/16/2008)

---

... I must be one of your exceptions. As a DBA and a Developer I view change as inevitable, and therefore I usually...

All I can say is maybe. You may luck out, or when you attach the mdf/ldf files, you may have a corrupt database.

My question is why are you using a cursor? Cursors do not scale well where a set-based solution would be better.

If the restore was done overwriting the existing database and no backup of that database was done before the restore, I think your hosed.

First of all, the code above isn't a view, it is a SELECT INTO statement creating a temporary table joined on another temporary table.

Is it possible to get all the...

Andy,

I must be one of your exceptions. As a DBA and a Developer I view change as inevitable, and therefore I usually embrace change but not for the sake...

Don't have time at the moment to work on this, have a few meetings to attend this morning, but I'd like you to do a search on SSC for...

Unfortunately, EM in SQL Server 2000 doesn't allow you to script the restore command. The best thing I can do at this point is have you read RESTORE in...

Old SQL Newbie (12/16/2008)

---

Same here. I was a nurse...

Ian Massi (12/16/2008)

---

Interesting topic. I'd want to become a lumberjack. I'd sleep all night and I'd work all day... then again I do that now too. At...

Correct me if I am wrong, isn't table partitioning only available in Enterprise Edition? I thought I had read that somewhere, but I haven't had a chance to check....