best practice is still to use a local drive.

that's the only drives you can consitently depend on exisitng, right?

After creating the backup, you would want to compress the file...

for xml won't let you inject closing html tags any place you want, but what you want to do is make it do the 99% of the work, and then...

not sure why you might limit yourself to 150 chars; database mail, outlook, email clients do not have a limitation like that.

i'm just selecting emails via FOR XML to make...

you've got quite a few things going that are causing malformed html; IE will do it's best to clean that up, but Outlook does not.

i populated your table and reviewed...

is your data double quoted, meaning the value featuring the comma is properly delimited so you can process it?

1,Academy award winners,"Jones, James Earl",moredata

if it's not, you need to go...

if we are talking about checking if an object is no longer valid because columns or tables were renamed , dropped, etc,

i've got this script i posted here on SSC...

i've seen the same on my side, with the default of one retry; an email with to: 'goodemail@somedomain.com;bademaul@somedomain.com' results in goodemail getting two emails.

first thing to do is review who...

i would think youll start with a case expression, and then order by the tagname anyway as the second condition;

how do you get the value "tagor1", for example? uis that...

i leave xp_cmdshell disabled by default , and have processes enable it, perform bcp via xp_cmdshell, and then disable again.

you could perform bcp from a command line SQL job, and...

how about not using #temp, but creating the table in tempdb instead? then it will still exist.

DECLARE @cmd nvarchar(4000) = '

SELECT schema_name(schema_id) As Schemaname,

object_id,

Name as TableName

INTO tempdb.dbo.StagingTable

from msdb.sys.tables...

below is an updated version of it, i posted the original version of it on http://sqlclrexport.codeplex.com/ years ago.

SQLCLRExport.zip

you posted in "working with oracle", so i thought you were using oracle.

if this is SQL server, then you would just stick with dateformats that are universally converted;

you said you...

Ray Herring (4/1/2016)

---

andre.quitta (3/31/2016)

---

when I tried to run the code in Powershell, I got the following error.

[font="Courier New"]Import-Module : The specified module 'ActiveDirectory' was not loaded because no valid module...

pretty sure you have to use oracles TO_DATE function, especially because you are passing a string,and also using UK date formats.

WHERE DateCreated BETWEEN

TO_DATE('01/01/2016 00:00:00','dd/mm/yyyy hh:mi:ss')

AND TO_DATE('31/01/2016 00:00:00','dd/mm/yyyy hh:mi:ss')

the problem...

you'll need to have a separate process save each query to disk on the server, and then the email will not have a query, only attachments.

i currently use a CLR,...