lol i was testing a different forum post and got stopped by this trigger!

that's hilarious for me.

i went ahead and dropped it on my server now 🙂

Encryption was introduced in 2005, but the methods are still teh same, even for 2012;

I relaly liked this article enough to bookmark it: and keep it and it's code in...

Scott D. Jacobson (8/9/2012)

---

I think Lowell's right here. There are an infinite number of solutions to this problem that don't involve...

interesting requirement;

i just tested this trigger as both ON DATABASE and ON ALL SERVER, and it worked fine in my brief testing;

i was able to create temp tables without a...

parameters for a vbs file are limited in size for the command line...4096 chars max length, i think, right?

so while you could send parameters to teh fiel (no spaces allowed...

i think you can do it like this?

EXECUTE ( 'TRUNCATE TABLE SalesTable' ) AT MyLinkedServer;

that code example is how i can calla CREATE TABLE command at a remote, i...

a couple of other possibilities;

create lots of global temp tables, with a naming convention like #temp_51 (dynamic SQL = 'CREATE TABLE #tmp_' + CONVERT(varchar,@@spid) )

then in your procs, you'd have...

database mail is disabled, but xp_cmdShell is enabled?

that is so backward security wise.

did you try the process you outlined here and sent something to yourself? did it work?

let me help...

OK some fresh thoughts this morning.

you should be able to :

SELECT

@BeginMeasure MIN(BeginMeasure ),

@EndMeasure = MAX(EndMeasure)

FROM #RptParms

then you can use the logic i posted previously; you'll...

Donalith (8/8/2012)

---

lol.. That's why I asked, Lowell. If it's done in memory I was wondering if the internal mechanics of string comparison using LIKE would out-perform the substring-string comparison or...

Donalith there would be some performance hit, yes:

if there is an index on APImport.Description, then the LIKE can use the index to find the value(s) that match.

by getting a...

if you do that, then all 146K rows in

EDWGEARS...VW_FRED_AADT_HIST will get copied over to tempdb, adn then the join will occur.

I'm thinking that's the best solution: get a...

it's syntax;

it's like this:

Warranty1 = (

Case

When APImport.Description like 'Enduro%'

then (DateAdd(year,1,APImport.DateShipped))

ELSE NULL

End)

testing testing testing.

that's the key.

here's your updated script; i can insert 'josh' multiple times.

DROP TABLE TestUniqueNulls

CREATE TABLE TestUniqueNulls

(RowID int IDENTITY NOT NULL,

NoDupName varchar(20) NULL)

GO

Create Trigger NoDuplicates

On TestUniqueNulls

After Insert,...

much easier to just reset teh password, i think