Reading through this .. so we can set up replication from the data warehouse to the various app db servers. Once question that jumps out at me is the effect...

I have not set it up yet.. so the type could be any... what I am looking to do is to kick off a pull, then move forward with all...

if you are needing a Pull.. is there a way to tell when the data is now up to date, so that other jobs can now run? (that process the...

In the Log-Reader Agent section... is there any effect on having the database set up as "simple log".. I am getting a sinking feeling that the log reader would not...

Sachin Nandanwar (3/21/2016)

---

In our SQL environment my observation always had been that TVP outperformed all the custom TSQL splitter functions and CLR methods.In some instances the TVP performance was on...

Thanks folks for the help... you would think this would be simple.. oh well. I sort of hate to use a table.. since I would have to have code to...

Hugo Kornelis (1/23/2016)

---

After taking a quick look, I can tell you that you are right.

The UPDATE FROM used in the trigger will affect all rows that match an inserted/updated row...

Erland Sommarskog (1/5/2016)

---

You don't set up proxy account per user. You set up a single proxy account that all non-sysadmin users. That would be a special login that is not...

Jeff Moden (1/1/2016)

---

dwilliscp (12/31/2015)

---

I tried to put the call to their code in () but got...

I tried to put the call to their code in () but got a syntax error....

Never mind, earlier post below, a co-worker had opened my file... after I ran in cmd window.

However I do know why our vendor was using a temp table and added...

dwilliscp (12/30/2015)

---

The big hint here is the word "identifier". Obviously, their code works but your call to their code does not. If you're using and EXEC or EXECUTE...

The big hint here is the word "identifier". Obviously, their code works but your call to their code does not. If you're using and EXEC or EXECUTE statement...

BTW their code is using varchar(max) for what is being passed into their program and varchar(8000) for everything else. So nothing is using varchar(128).. to match the error that I...

dwilliscp (12/30/2015)

---

Jeff Moden (12/29/2015)

---

Actually, that explains a lot.

So who's code is it that's in your first...