as Database mail uses SMTP the default is port 25, but your exchange admins can change it so you are best speaking to them

can you post the DDL statements for all objects involved, tables procedures triggers etc

would seem like you need to use ranking functions http://msdn.microsoft.com/en-us/library/ms189798.aspx

The SSMS tool kit will do that for you, it assigns each server its own colour so will take some configuring to set the colours of each server.

you could use the FORMAT command in an expression on the field

FORMAT(Fields!DateField.Value, "dd-MMM-yy")

Thanks Phil, I will add a comment once I have done my morning checks.

Its a possibility but its extracted from SalesForce using ApexDataLoader and I have yet to find a way to change it from comma delimited to something else, but will keep...

Howard, the flat file source does have " as the text qualifier its just that one column which it wont remove the " from. Also thanks for the...

deebabat (4/20/2012)

---

MarkusB (4/20/2012)

---

deebabat (4/19/2012)

---

BEGIN CATCH

insert into tblDownload_Import

(Description) values ('error: ' + ERROR_Number() + ' msg: ' + ...

do you or the agent account have the correct Windows Server access rights to query WMI data

anthony.green (4/20/2012)

---

SkyBox (4/20/2012)

---

anthony.green (4/20/2012)

---

SkyBox (4/19/2012)

---

One of our systems (AX 2009) doesn't allow "included columns" on indexes, so with that in mind, I want be sure that those indexes aren't covering...

SkyBox (4/20/2012)

---

anthony.green (4/20/2012)

---

SkyBox (4/19/2012)

---

One of our systems (AX 2009) doesn't allow "included columns" on indexes, so with that in mind, I want be sure that those indexes aren't covering too...

from what I remember 0x80041003 is an insufficient permissions error, cant remember if its insufficient at the agent level to run the alert or to your account creating the alert.

one...

Thats...

one way would be to wrap the size in a case statement then group by the case statement again

select

.......,

case when size >=1 <=10 then 1

else when size >=11 <=20 then...