thx frederico, i use forums mostly to leverage other people's experience.   i post on forums when i think its the best first path over ai and google.  why have this...

thx frederico.  none so far.   that large company put a lot of stock and $ (they tend to vet things pretty thoroughly and i want to leverage that initially rather...

• This reply was modified 1 days, 11 hours ago by stan.

thx jasona.work.   by backward compatibilty i meant that flavor that we used to set explicitly.   its been a long time but as i recall you can set it manually to...

thx jasona.work.  so you are saying that if both the dev and prod are backward compatible to version xxxx, newer features in the dev's version will still work?   features that...

thx steve i was hoping the community would help me to make a case with examples for not doing this.   didnt really want a discussion on integration and deployment.   was...

i think i found it...

yes, i believe he uses bigint as his pk's.  do you think that has something to do with this?

i believe our infrastructure folks told him there was a server failure around the time of his inserts.   i'll post back here once i get some details.

correction , no failures...

• This reply was modified 1 months, 1 weeks ago by stan.

this is looking more promising for my needs, maybe not yours.   i'll have to figure out how to allow single quote marks, probably by using the replace function.  There is...

hard lesson, i guess that sql statement doesn't do what i was hoping, ie hold true in the when clause if even one character is not in the list.  i...

wow this is confusing.   for starters i dont know what an object type of 50 (with parameter name SYNCHRONIZEFD, and maybe setting my pkg level param in the same EXEC)...

• This reply was modified 2 months, 1 weeks ago by stan.
• This reply was modified 2 months, 1 weeks ago by stan.
• This reply was modified 2 months, 1 weeks ago by stan.

im circling back to this right now.   bear with me.

thx jeff.   this is a db in an off the shelf erp.   its probably not just one table.   we cant add things like that without voiding our contract, at least...

• This reply was modified 3 months ago by stan.
• This reply was modified 3 months ago by stan.

i just ran the pkg from sql agent.   I dont want to guess especially since you'd think strongly named assemblies etc should have been in play.   If anyone in the...