Yes restarted sql. then restarted the server.

What version is the good version of XPStar.dll?

What version works?

I tried to copy the dll from sql 2008 and 2012 into 2014 but it did not work.

no shit

file version 2014.120.2000.8

product version 12.0.2000.8

size 409k

Date modified 2/21/2014 5:20am

I have 12 SQL 2014 instances in 3 different domains (dev, test, stage).

Each SQL instance has 3 distinct email profiles and each domain has its own mail server.

I tested different...

I'm starting to find more web posts about this issue, looks like I am not the only one.

But it does not fix the problem.

Microsoft SQL Server 2014 - 12.0.2370.0 (X64)

Jun 21 2014 15:21:00

Copyright (c) Microsoft Corporation

Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

I ran the query, the attachement data is truncated at 65k, no attachement size is larger than that.

I run the same query\jobs using sp_send_dbmail in 2008 and there are no...

paramname paramvalue description last_mod_datetime ...

They abuse select by dumping the contents of tables using select * with no where clause. I was hoping that by granting update with out select they can't do table...

Just adding to the brain dump, this worked very well, I found I had some line feeds to.

These steps cleaned it all out.

UPDATE mytable

   SET myfield = REPLACE(myfield, CHAR(9),...

Thank you very much it worked!

This will return all user tables and columns in a db. Its helpful when your searching for spicific for cols.

Select o.name, c.name

From sysobjects o

Join...

hummm

You can run on any database, the where clause is optional.

select o.name as 'Obj Name',

c.name as 'Col Name'

from sysobjects o

join syscolumns...