SQL 2000 is not supported on Vista, Windows 7, Server 2008 or Server 2008 R2.

Have you identified where the timeouts are occuring from? Is it logging in? Is...

+1 with Andy but going off what he thinks and my interpretation, you are after "precendence constraints"

Thanks Grant, I just tried monitor.red-gate.com on the iPhone and works a charm especially the analysis part with the graphs. Now my question is, does monitor use the same...

Andy Hyslop (5/30/2012)

---

Hi looks like you are trying to work out your Six Sigma phase duration excluding weekends?

Have you considered using a calendar table for this it could save you...

Koen Verbeeck (5/30/2012)

---

I'm alive 😀

Metallica was great, although...

Thanks Mike, I was gutted but not gutted at the same time. Was hoping to pass, but then a fail just gives you that bit more motivation to do...

tilew-948340 (5/29/2012)

---

When I tried to read the SLQserver 2008 R2 DB with the SQL server 2008 and it did not work, I would have bet that it was because a...

The MS Training web...

just out of the test centre bad news this time round only got 624 so quite a way off. have to say there where a couple of questions which...

Sounds to me like you need a calendar table which you need to lookup through to determin if the day is a holiday

If you only want to exclude sat n...

Could you not use the generate scripts function in ssms.

It's somewhere on the database when you right click it, can also get it to script out the data and should...

Just use due date > getdate() and due date <= the first expression in my last post

--To get 23:59:59 of the current day

SELECT CONVERT(DATETIME,LEFT(CONVERT(NVARCHAR,GETDATE(),120),10)+' 23:59:59.997')

--To get 00:00:00 of the next day

SELECT CONVERT(DATETIME,LEFT(CONVERT(NVARCHAR,GETDATE()+1,120),10)+' 00:00:00.000')

--To get 23:59:59 of the next day

SELECT CONVERT(DATETIME,LEFT(CONVERT(NVARCHAR,GETDATE()+1,120),10)+' 23:59:59.997')

That will do what you need,...

DOH, my bad, forgot I was in the 2005 Forum,...

Why do you need to change from DATE to DATETIME?