ADS: sp_mgGetUserTables() with same user name

[Tom]

The username is W2016SVR on each connection

This is the name of the computer connecting to the ADS, which only is an user name in terms of the ADS. The OS User Login Name is the real username. Anyhow, you get all this information (including the TSAddress) with "sp_mgGetTableUsers()", so it's easy to find out who's really using a table.

[messaoudlazhar]

Addition: Using those stored procedures again and again may lead to ADS Error 7216, which means the number of SQL-statements for that connection is exceeded. sp_SetStatementLimit(0) solves that problem.

Alternative solution for error 7216: Adding SQL_STATEMENT_LIMIT=0
to the adslocal.cfg file

; Max Statement SQL Limit
; Default = 50
; This configuration parameter controls the maximum number of SQL statements that
; a single connection can keep open at one time. This option is ignored by
; setting this value to zero (0).
;
SQL_STATEMENT_LIMIT=0

[Tom]

SQL_STATEMENT_LIMIT means the maximum number of statements for one connection at a time. It's really hard to reach this limit as long as all statements are properly finished and closed. See correction of my message.

Another alternative is to set a Registry Value:

SQL_STATEMENT_LIMIT (DWORD) in \HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Advantage\Configuration

[messaoudlazhar]

SQL_STATEMENT_LIMIT means the maximum number of statements for one connection at a time. It's really hard to reach this limit as long as all statements are properly finished and closed. See correction of my message.

Another alternative is to set a Registry Value:

SQL_STATEMENT_LIMIT (DWORD) in \HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Advantage\Configuration

this solution does not work. I tried it and it didn't change anything.
with SQL_STATEMENT_LIMIT=0 in the adslocal.cfg file, it works very well without limit.
Note: Put adslocal.cfg in the system32/sysWOW64 folder

[bwolfsohn]

I get an "attachment no longer exists" message when trying to view the .jpg

[Wolfgang Ciriack]

Hello Brian,
that is the message i always get with attachments from this forum.
Jimmi posted the solution:
Open the file in a new window.
The path is shown, f.e. ...bb.donnay-software.com/donnay/phpbb3/download/file.php?id=2241
Remove the "/phpbb3" from that path and the attachment is shown.
I hope, Roger will correct the path for attachments in that forum.

[rdonnay]

Open the file in a new window.

Open what file? how?

The path is shown, f.e. ...bb.donnay-software.com/donnay/phpbb3/download/file.php?id=2241
Remove the "/phpbb3" from that path and the attachment is shown.
I hope, Roger will correct the path for attachments in that forum.

I really don't know how to do this.

I have gone through the source code to figure out how PHP creates that path.
Also, I don't have any problem seeing the attachments in Edge browser.

[Wolfgang Ciriack]

Hello Roger,

Open what file? how?

Right click on the name of the attachment and choosing "Open graphic in a new tab", then remove the phpbb3\ and it is shown.

[rdonnay]

Right click on the name of the attachment and choosing "Open graphic in a new tab", then remove the phpbb3\ and it is shown.

I did as you suggested and the image shows just fine in a new tab with the below URL:

download/file.php?id=2255

[bwolfsohn]

Roger,

As an admin, you might have different rights and permissions. Can you access the board externally as a non-admin ?