you will need to build it into a variable then pass in that variable

declare @attach nvarchar(max)

set @attach = 'C:\fjnrfrgrjnjnfg'+CONVERT(NVARCHAR,GETDATE(),112)+'.xls'

sp_send_dbmail ......, @file_attachments = @attach

I take it the number of tasks and weeks can change?

If so your looking at a dynamic cross tab solution, there are 2 links in my signature by Jeff on...

You can do mirroring in Standard edition, just not Async mirroring. Standard edition mirroring is Single Threaded Syncronous

You can restore Alpha from ServerA to AlphaDML on ServerB the database...

Your using coding language as DT-WSTR is a SSIS data type not a T-SQL data type which is what sp_send_dbmail is expecting.

You need to look at something which is in...

1 - Can you not change the name of the alpha database you do your DML on to something different, eg AlphaDML and then you can logship as normal with...

Mark Fitzgerald-331224 (5/30/2012)

---

anthony.green (5/30/2012)

---

The...

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...