on the notifications Tab, if you select "When the job completes", that will send the email you are after, and the message will have whether it was successful or with...

this tells you the issue is not with SQL database mail but with the mail server.

that the...

if it is plain text, i'd just use bulk insert instead of building an SSIS package;

for me, that would be faster than anything else.

both ways are available via the extended proc xp_logininfo , but the limitation is the group/user has to be added to SQL first before you can enumerate them.

if you...

from a real command window, bcp has access to all shares that the caller(you) have access to;'

but if you call bcp from xp_cmdshell, it is almost certainly using a different...

it depends on the shape of the data you want to report;

Can All 50 queries results be placed in a temp table, or do you need each resultset? just...

you'll wnat to set your session variable for dateformat to handle this for you:

SET DATEFORMAT DMY

select

cast ('14/02/2014' as date)

i think you just need to switch to a binary collation, otherwise accented letters like àâáãäå are all the same as 'a', right?

Select * From [Table] Where [Column] Like '%[^0-9a-zA-Z...

if SSMS scripting option below is selected, then dynamic SQL is generated to handle the if not exists, and that is what you are seeing.

you pasted just a piece of...

well, it's not going to be easy, but this will get you started;

because you are not using the right data types (a string containing '9:00 - 9:30a' instead of two...

to grant a user the ability to see the metadata stuff for any object in a database, without granting access to the data within those objects, you can grant VIEW...

SQL server is probably not the target platform you want to use for this; is this supposed to send / retrieve information from the web service and return it to...

on the same server, i believe it's no problem; every query eventually gets resolved to all objects to thee part naming conventions...database.schema.object;

I have a system I babysit that we recently...

please edit your post and remove that varbinary string. it does not help, and just muchs up teh post to make it...

there is a YEAR function that returns an integer, that can do what you are asking:

there is also a DATEPART function that can do the same, but you can pull...