Rather than use a trigger I would have simply done:

ALTER TABLE dbo.myTable ADD ShortSSN AS RIGHT(SSN,4);

Cheers,

I'm a little confused by your question.

Do you have any suggestion on when and where to call this new SP? Because when I reinitialize the snapshot it fetches data and...

So what does your modified SP's look like?

I'm still not sure if that is the best method since I'm pretty sure those SP's will get over written if you ever...

Why is it a requirement to only replicate part of the SSN column? If you are already replicating to the subscriber it can easily be extracted out in a...

This will help you with what you are looking for.

http://www.mssqltips.com/sqlservertip/1394/how-to-store-longer-sql-agent-job-step-output-messages/

Awesome, thank you sir!

Off the top of my head I'd say no...long answer is I'm not 100% sure. I'm still discovering many 'interesting' things left/done/created by my predecessors.

Perry Whittle (4/3/2015)

---

Correct. There would...

That's a real good article. It does seem like I'm on the right track but sometimes it's the little caveats in the wording of some MSDN that get me.

e.g....

opc.three (10/23/2012)

---

Eric M Russell (10/23/2012)

---

What's described above would be one form of a "property bag" technique. I have been tasked with building data extract and reporting from a large ISV...

matak (10/21/2012)

---

I have considered a consultant yes and will talk to the appropriate people about getting one in.

I thought id give the forums a go just in case it was...

IF OBJECT_ID('TempDB..#Field','U') IS NOT NULL

DROP TABLE #Field

CREATE TABLE #Field

(

fieldID int NOT NULL,

pkFromOrigTable int NOT NULL,

fieldName varchar(200) not null,

fieldValue decimal(30,20)

)

Any advice,...

Ok, couple more questions then.

You have a field called Year but are using a float datatype. I would suggest you use DATETIME types for any fields relating to well...

Out of curiosity is this database for an application that allows users to create/define custom fields or even data types? The only reason I'm asking is because I've had...

Because that is the only table that was causing performance issues when I broke down...