you already have a thread going with this question

http://www.sqlservercentral.com/Forums/Topic1052867-148-1.aspx

I find the easiest way to check for files is to use a script task and the File.Exist method

http://msdn.microsoft.com/en-us/library/system.io.file.exists.aspx

If your ActivityDteTime is a varchar then that should work, otherwise if it is a datetime then you will need to use DATEADD

you will need to set the second server up as a linked server to the first server before that query will work

http://msdn.microsoft.com/en-us/library/ms190479.aspx

would it not be better to use DATEADD to add 6hrs rather than DATEPART ?

Thats good news, thanks for reporting back the solution for others..

from memory you quote the entire list, not each email address;

exec msdb.dbo.sp_send_dbmail

@profile_name=[Public Profile],

@recipients='email1@workplace.co.uk;email2@workplace.co.uk;email3@workplace.co.uk',

@subject = 'Total Open Calls',

@query = "query",

@attach_query_result_as_file = 1,

@query_attachment_filename ='QueryResults.txt'

Sqlsavy (1/21/2011)

---

How can I justify my answer for installing Anlysis Services and Integration Services on Virtual Machine for Production Server?

The scenario is I don't have any details of Cube growth...

what were wrong with the answers we gave you yesterday?

http://www.sqlservercentral.com/Forums/Topic1050708-146-1.aspx

id the data truncated at the source or the destination?

to test this put a data-watcher on the dataflow directly after the source, and check if the '[' is...

try a LEFT JOIN from your budget table, and add a where clause for customer is null

eg..

Select *

from budget left join customer on budget.customerid = customer.customerid

where customer.customerid is...

Along with what everyone else has said, I suspect that since you are pulling the data from a remote db server the network will have a bigger impact in...

I have run quite a few on VMS, as long as they have the resources then i don't see a problem.. not sure what MS recomends though

chaingang.174 (1/20/2011)

---

^ Guys .. First of all .. As a Developer I m familiar with all the datatypes available in sqlserver and have also used it in my projects But...

seems like a waste of time for a professional developer...