Reconsider the tool to use for your project;

This post started out with "how to include an image in sp_send_dbmail".

certainly possible, but is the right tool for your specific question...

I tend do do commands like this in a script rather than the GUI;

my example script would look something like this:

CREATE ROLE DevelopersReadWrite;

GRANT VIEW...

DataAnalyst011 (12/16/2016)

---

Do you mind if I ask one more question? Obviously your code works and mine didn't. However, do you use the @@ROWCOUNT method because it is faster? I've pretty...

i would handle the upsert like this:

also, i think you granted INSERT to public, but you did not grant UPDATE or SELECT to public, so that is a point of...

a case statement is going to lock you into one datatype, so i would simply use money(= Decimal18,4)

and do the math in a case statement;

wouldn't something like this do the...

since you have CMS set up, I would use a powershell script to poll each CMS server, and insert data into a centralized table.

then you could generate an SSRS report...

the example here:

http://ss64.com/nt/syntax-delolder.html

is so close to your version, i'm not sure there's an issue:

the only thing i see is that the example uses slashes instead of hypens for the...

my example contained the word [ColumnList] as a placeholder for...

Phil Parkin (12/16/2016)

---

Glad you solved it. Not sure whether you know this, but if you add

using System.IO;

into your Using block (towards the top of your code module)

it allows you to...

you said find duplicates in the first post.

INTERSECT finds...

i always put my audit table in the master database, since it is guaranteed to exist, and all logins inherit some access to it.

someone already mentioned the three part insert:...

it depends on what you define as a duplicate; a few columns, or every column, including identities and CreatedDates?

also, is a duplicate in two databases, or must be in ALL...

I know the default is to search for a local windows user related to the server name;

You probably need to change toe location to to browse to find the...

mandavli (12/16/2016)

---

it is UNC path that I am using in the package,

with fail as I mean it's not able to find file, even if I have same proxy accounts...

mandavli (12/16/2016)

---

Thank you. Created the proxy and it worked on the native server (where the catalog exists)

But when I create a job on a different sql server. it fails, I...