I would look at Paul Randals blog on SQLSkills.com if you are looking for something more authoritative.

Also, please show us the code you are running using this function.

I...

Kiara (4/24/2012)

---

Grant Fritchey (4/24/2012)

---

Kiara (4/24/2012)

---

Lynn Pettis (4/24/2012)

---

Nope, too much fun watching now. I can even answer his question on why he keeps getting the same value...

In the Object Explorer, right click on the server, then click on Properties. Go to the Connections page, it will show you how many connections the instance is configured...

hanrahan_tim (4/24/2012)

---

Hello everyone,

I'm seeing some strange behaviour on our DEV box running SQL 2008 R2 64bit.

When I execute this statement:

Select @@MAX_Connections as Max_Connections

it returns: 32767

Several times during the day however...

Geoff A (4/24/2012)

---

if you have a high use server with multiple databases in full backup mode with trans logs getting backed up alot, and you do not rotate the logs...

You could try cutting down the amount of sample data so that deriving the expected results manually would not be such a choir.

We only need enough to properly represent the...

opc.three (4/24/2012)

---

deebabat (4/24/2012)

---

I am trying to insert into a table by selecting from another table but one of the columns in the two tables have different data type. please how...

deebabat (4/24/2012)

---

the question is that i don't know why I am still getting conversion error mesage: Msg 245, Level 16, State 1, Line 2

Conversion failed when converting the varchar value...

inconceivable

david.wright-948385 (4/24/2012)

---

So your premise is that your everyday law abiding Joe...

And the question?

oolawole (4/24/2012)

---

Something like this.

Resp_Id Brand Oc

1002 0 1

1002 ...

Don't know where to start if I don't know where to finish.