i found a solution to add cd.. && in the begging

SET @CONVERT_HTML_TO_PDF = 'cd.. && "C:\Program Files\Microsoft SQL Server\MSSQL15.PRI\MSSQL\monitor_binaries\wkhtmltopdf.exe" "c:\new folder\1.html" "c:\new folder\1.pdf"'

thx it's working good.

ok thanks.

i just try to failover only the BAG that have the listener on it and the second BAG is inaccessible..

thanks for the help.

another question on the extended event.

i need to put this event on bunch of server but need to put the event files on different location for every...

they know about the problem and for now they can't fix the problem.

table scan is not good because some tables can have even millions rows for they temp...

if i setup in the index page lock = false and row lock = false will it help reduce the locks on those tables?

Lynn Pettis (5/27/2016)

---

Mad-Dog (5/27/2016)

---

Lynn Pettis (5/27/2016)

---

Mad-Dog (5/27/2016)

---

GilaMonster (5/27/2016)

---

You really wouldn't want no locks at all. Rows deleted while they're still being inserted, updates affecting some of the rows they should...

Lynn Pettis (5/27/2016)

---

Mad-Dog (5/27/2016)

---

GilaMonster (5/27/2016)

---

You really wouldn't want no locks at all. Rows deleted while they're still being inserted, updates affecting some of the rows they should because the rest...

GilaMonster (5/27/2016)

---

You really wouldn't want no locks at all. Rows deleted while they're still being inserted, updates affecting some of the rows they should because the rest are still being...

spaghettidba (5/27/2016)

---

There is no way to do that in a relational database.

I would rather focus on the reason why you're getting blocked, find the root cause and fix it....

thanks all

thx.

in alwayson i will not suffer from the intermittently break in connections?

ok I'll try to capture the plans while i have this problem.

i update all the stats every night and rebuild the indexes once a week.

can i query the cache...

ok..

this is not what i'm looking for.

i need to see if a user is connected from 2 different hostname.

i can't interpolate the query at all it is closed box.

can it be done via trigger or something else?