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...

right, so local system does not have domain access to any network shares, for example. it cannot browse to \\machinename\d$\somefolder.

to do that, you...

take a look at this thread:

http://www.sqlservercentral.com/Forums/Topic1707571-3411-1.aspx#bm1707577

typically, the fix is to explicitly assign master as the default database, and then cleanup the default db from there.

the thread mentions issues that contribute,...

just like xp_cmdshell, the service account that SQL is using is the credentials used for accessing objects outside of SQL server.

if your process was accessing local folders , special folders...

Jason i know i inherited a ton of servers, where noone was still around to add users as sys admin, or there was no admin at all.

I've got several scripts(powershell,...

i took this post as an attempt to use a third party security audit solution that either has limited scope, or you might have limited experience with it.

it's...

Sean Lange (8/7/2015)

---

I was fiddling with a version of my own using that same function when Luis posted his. I scrapped mine immediately as I saw the approach he was...

just for reference, this is how i tried to solve it;

i parsed everything with DelimitedSplit8K, and then just fiddled with columns that were larger than the target length.

my sample...