Hunnie (8/3/2012)

---

Hi,

I'll preface by saying that I am not very knowledgable about IIS/SQL Server/MS Server.

However, I have been tasked to help one of our clients move their site...

kranthi.india123 (8/3/2012)

---

Hey Hi friends,

please Help me on How to design the Sports database for online games or live games????

give me some idea about online sports games.(footbal or cricket ,golf,tennis,basketball..etc).....please...

Just to add to the solutions, if at all possible split that into two columns. It appears you have two pieces of information in a single column. This type of...

I use KeePass....

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