Just to be sure, your last posted code was your corrected code and is working correctly, right??

Is everyone who attempts to run activity manager getting this error? If so, you may have a corrupt dll (mscorlib) on the system and you may need to replace...

Here is a consultants answer; It Depends.

You'd have to look at the queries you have written in your stored procedures to determine if one table or two is the best.

Well, now that you have updated the code, what is wrong? Also, for better answers to your questions, please read and follow the guidlines provided in the article I...

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...