Hey - if you're going to give me a new stapler, expect to find some things stapled.....:D

happycat59 (11/19/2007)

---

You are right wrt log shipping to a passive node not being possible. Log shipping needs to be able to restore the transaction log backups. In its...

I haven't played with Mirroring enough to be of any help to you on tips and tricks, but I can help you a little as to the licensing. Here's...

Jeff Moden (11/19/2007)

Heh... It's IDENTITY_INSERT... not IDENTITY_UPDATE... 😛

Does anyone know if you can update an Identity column in 2k5 with SET IDENTITY_INSERT ON? I'd bet not but one never...

I would love to take advantage of that should that ever come to pass. Of course - I can't even get them not to call me when I'm NOT...

Well - I think Steve kind of strayed "on purpose" today (that was the purpose of that editorial). That being said - I'd much rather talk SQL server on...

Lynn Pettis (11/19/2007)

---

""We the People of the United States, in Order to form a more perfect Union, establish Justice, insure domestic Tranquility, provide for the common defence, promote the general...

Very nice Peter - way to stick with it.

Steve Jones - Editor (11/19/2007)

---

I don't think employers have to promote general welfare. It was a benefit the unions forced and companies started to offer to compete for workers.

With the...

Mick - are you trying to build a row for each day between 2 dates?

If so - you probably want to use something involving what is known here as a...

As to consequence - remember that the net effect of enabling /3GB in those relevant cases essentially gives SQL resources usually requested by the OS. This means that you're...

I can't tell what data type the column "time" is stored at, so I will throw in a CAST for good measure.

Try this kind of syntax:

delete

from tableA

where

datediff(day,cast([time] as datetime),...

..then group by Dept would give you a line per department?

so....

select

Dept ,

SUM(TotalHours) as PayTotal,

...

Agreed...

You...