sjsubscribe (8/7/2009)

---

GSquared, you still don't make sense. There is no place in our society for religious tests, no matter how well its masked. As the author asked if it's baloney....

talltop (8/7/2009)

---

Whooaaa! really? Well maybe it is just me but if I had someone on my DBA maintenance team/rotation that did not know what the different db recovery models were...

talltop (8/7/2009)

---

Lynn Pettis (8/7/2009)

---

Hate to tell you, but discussion threads...

Hate to tell you, but discussion threads here on SSC...

thummalalavanya (8/7/2009)

---

Hi Friends,

I want to use Cte in my sql server 2005.What is Cte .why...

I will admit that I shrink the log file at times. Whenever I restore production to one of our training or development servers after changing the database to the...

Best thing you could do then is do the install for them. That way you know you are installing only the client tools.

What does the following query return?

select

mt1.AcctNo,

mt1.Mdate,

count(*) as RecCnt

from

dbo.MyTable01 mt1

inner join...

We now have a couple of dedicated servers for MOSS 2007. When I installed SQL Server on hose servers I used Latin1_General_CI_AS_KS_WS.

We also have a WSS setup on a...

hugh.hemington (8/6/2009)

---

So with four or more ways to do it, I found..... none of them! 🙂

Yeah, my head is still in row-wise manipulation but I'm trying. I've...

Do you have access to teh AdventureWorks sample database? Can you use one or more of the tables there to formulate a similar problem?

As far as I am aware,...

Okay, now we are actually getting somewhere. How about providing us with the actual problem you are trying to resolve? Rather than asking piecemeal questions, put the whole...

hugh.hemington (8/5/2009)

---

The "Create Some Data" part of the "tutorial" is complete gibberish since it avoids showing how to assign static values to ANYTHING! (Kee-rist, who comes up with this...

emily (8/6/2009)

---

Lynn Pettis (8/6/2009)

---

A little confused as to what you are asking. Are you wanting the to return the last day of a month based on the current or...