don't convert dates to strings! the where statement you posted ends up causing a table scan, as it converts every date to a string, which in turn gets compared to...

i posted an old trigger example that sends an email you could use as a model here:

it gathers specific elements from the 1-to-many rows of data that was changed,...

I seem to remember another thread that said they needed to right click the SSMS shortcut and click 'run as administrator' to be able to do some other things, like...

SQL Express usually installs as an instance name, and not a default instance.

your BCP is assuming a default instance, i'd bet you have a named instance instead.

check your servername\instancename, but...

is the Reporting Services you are connecting to the same version as your SSMS client? I have trouble when connecting from higher to lower versions.

i get errors...

you have to fill out the authentication settings of your mail profile; google, yahoo, virtually every external mail server requires the AUTH command to send username and password, so that...

during my copy/paste/modify, i left an invalid trailing comma in the string for the command here:

just remove the comma, and the command is syntactically correct; hopeful it...

based on Lynn's fine advice, this is how i'd look at it:

SELECT *

INTO #tmp

FROM OPENQUERY([DBServer1], 'SELECT

...

without more details, i'm just throwing an example out there;

shouldn't you calculate the cost of all projects, and only filter on the criteria?

maybe something more along the lines of this?

SELECT

...

yes, there's a reason!

i built this a while ago , and i have a bunch of variations of it for specific purtposes.

but i remember...

if you step back from the dual-three letter matching criteria, whit is it you a REALLY trying to do?

identify misspelled drug names? create full text equivalent so that you...

levaif (8/10/2015)

---

It's something which is not clear for me.

So, SQL server is running under Local system account, on an terminal server.

I use my domain account to log into the server,...

levaif (8/10/2015)

---

We have several stored procedures. In these sp's we want to made some IO operations with bcp, osql or other utilities.

Example :

SET @ExecCommand ="SELECT *...

to prevent drop and recreate, but allow alter, I don't believe normal permissions don't go that granular, so you'd have to create a DDL trigger to rollback the commands...

I've done it the opposite way, replace NOT allowed characters.

if a char is not allowed, do you just remove it, or replace it with a space or other char?

here's an...