Alberto Vásquez (8/3/2012)

---

Thanks for your answer. I always use the DESIGN mode to make modifications. In DESIGN mode there is a way to create an alter script for a table...

You should be able to view just about anything in there. I would assume you named it something different than msdb? Is this more of a "is it possible" type...

You have a GO which is a batch terminator.

Try this:

begin try

RAISERROR(50001, 11, 127)

PRINT 'This should not print but does!'

end try

begin catch

print 'The above print line did not print because the...

Luis Cazares (8/2/2012)

---

Thank you Sean, I know it might be a lot of work looking at it in depth (when is not really your job).

About the NOLOCKs they were there...

morepainot (8/2/2012)

---

Sean Lange (8/2/2012)

---

morepainot (8/2/2012)

---

Sean Lange (8/2/2012)

---

Well the code certainly looks a lot better. But it doesn't help me identify why you are getting an invalid object name. I can't...

morepainot (8/2/2012)

---

Sean Lange (8/2/2012)

---

Well the code certainly looks a lot better. But it doesn't help me identify why you are getting an invalid object name. I can't see your screen...

Luis Cazares (8/2/2012)

---

Would a SELECT of the original tables using just the required columns help? or it wouldn't make any significant improvement?

Or maybe a view limiting the rows I need...

Well the code certainly looks a lot better. But it doesn't help me identify why you are getting an invalid object name. I can't see your screen from here and...

Because it doesn't exist? 😛

It is tough to figure that out from here. Does the table actually exist?...

So you are intentionally trying to get dirty reads? I don't quite follow that you need nolock because your transaction...

dccbr (8/2/2012)

---

Hi,

What's is better? I prefer the third case because my table scps_cadastro_os has more than 1.000.000 and I made the change IN for EXISTS, so can I use the...

This should answer all those questions and more. http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/%5B/url%5D

As Lynn said you didn't provide much to go on but an extremely vague shadow of an idea. I think that the gist of your question is "How can I...

You posted a bunch of stuff in your first post that somewhat looks like it came from your table. Turn that into something we can use and we can help.

Turn...

vishnurajeshsat (8/2/2012)

---

Dear Sean Lange & SSC Rookie,

Thanks for your reply.I cant able to show my table in this forum. Can you tell me how to add image...