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

Jeff Moden (12/29/2015)

---

Actually, that explains a lot.

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

I will remove their proc call from our code and just do the export in a...

I would love to post the code.. but it is my vendor's code... sorry.