First, I'd recommend...

jcrawf02 (7/17/2009)

---

Lynn Pettis (7/17/2009)[hr

So, what's stopping you from getting back out there? I'm sure that you could be used and abused just like the rest of us. It...

First, remember that no all errors can be trapped in in a TRY/CATCH setup.

Code your trigger to use TRY/CATCH. For the errors that can be caught, capture the error...

Just realize that it may not take all 14 GB of RAM. Not saying I wouldn't set the maximum memory available to SQL Server, I would; but the best...

jcrawf02 (7/17/2009)

---

Lynn Pettis (7/17/2009)

---

I try to work 3 or 4 tournaments a year. Depending on the tournament, that can be anywhere from 2 days to 7 days long. ...

rob (7/17/2009)

---

Oooooooh so all you have to do is OWN a piece of paper stating the CAL's are yours, not actually apply them to the server so that it lets...

jcrawf02 (7/17/2009)

---

Lynn Pettis (7/17/2009)

---

I try to work 3 or 4 tournaments a year. Depending on the tournament, that can be anywhere from 2 days to 7 days long. ...

I have to agree with Brandie, obviously SQL Server doesn't need all of the available memory or it would take it, potentially starving the OS if it needed all of...

Short of a backup file, I know of no way to recover a database that has been dropped.

Why don't you have a backup of a production database? Setting up...

I was also looking at your code, what version of SQL Server are using? I'm guessing that it is SQL Server 2000, not SQL Server 2005. If it...

Blazix Marler (7/17/2009)

---

thanks for the info on the datestamps.

But query is taking lot of time to run , can it be tuned to run more faster.The query is

select s.domainid,d.domain,s.urlid,u.url,s.applicationargumentid,a.application_argument

from...

rob (7/17/2009)

---

So what your saying is that you cant add extra User CAL's to an existing server that I must Install the server software to start with, with more licences...

You still haven't answered Brandie's question. Are you having performance issues or are you just wondering why the extra 1.5 GB of RAM isn't getting used?

jcrawf02 (7/17/2009)

---

Lynn Pettis (7/16/2009)

---

Well, I have been enjoying my time off work, but I haven't been doing much soccer officiating so far. Tournament started on Monday and today was...

Maxer (7/17/2009)

---

From what I have read and how I am reading it each developer working / connecting to SQL Server needs a dev license.

After that it gets a BIT fuzzy.

Say...