luissantos I did check and came up with 1 ')' short. However for performance I don't think you need

WHEN LEFT(SL.REF,4) LIKE '0%' THEN 'ARTIGO'

WHEN LEFT(SL.REF,4) LIKE '200%' THEN '...

I see your point and you can go into SQL instance and split the memory by not doing dynamic allocation in SQL and setting it under the servers properties to...

There are tools to role back transactions in a databse as long as the transaction log has not been truncated and the data was deleted by a logged transaction (delete...

But unfortunately thanks to Gates and many other folks in the industry the government is on their side. As long as they have the right legal statements and you agree...

We did the route of an intern this past year but due to other things we lost him. But fortunately we got another SQL proficient person back not long after...

Then they really offer what you had before. And thus you get the same possible results, your data being lost is not their problem. And I bet the backup machine...

But do they give you a guarantee in writing about your data. Even if they backup to tape, tapes can fail. Do they guarantee they verify and insure things are...

But be carefull there in that many have rules against running a server and will boot you, but this seems to be only in extreme cases.

So is nimda but I already dealt with that.

Going back to what I posted. Even though Microsoft is sharing they still are the original developing company and until the turn over to a standards committee they are the...

Well, that is when you just have to make one for yourself. The way I broke in was by developing a solution for tying several problem management databases together using...

I know that feeling. But if I ever quite learning I would be bored.

In addition. Even though memory is a big concern it is not the biggest. As stated anything can peg out resources. If the CPU hits 100% because of what is...

The key is how did you test it and are you sure it works outside a procedure.

No I made them utilize stored procedures and to be more specific about the data. Most of the reports are web based and my group controls. But with Crystal they...