Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
SELECT EMPLOYEE.FIRST + ' ' + EMPLOYEE.LAST AS NAME, CLIENT.NAME AS CLIENT, PROJECT.NAME AS PROJECT, TASK.NAME AS TASK, [GROUP].NAME AS TEAM, TRANS.DATE, CUSTOMVALUE.VALUE FROM PROJECT INNER JOIN TRANS ON PROJECT.ID = TRANS.PROJECT INNER JOIN TASK ON TRANS.TASK = TASK.ID INNER JOIN EMPLOYEE ON TRANS.EMPLOYEE = EMPLOYEE.ID INNER JOIN [GROUP] ON TRANS.[GROUP] = [GROUP].ID LEFT OUTER JOIN CUSTOM INNER JOIN CUSTOMVALUE ON CUSTOM.ID = CUSTOMVALUE.CUSTOM INNER JOIN CUSTOMTEMPLATE ON CUSTOM.CUSTOMTEMPLATE = CUSTOMTEMPLATE.ID ON PROJECT.ID = CUSTOM.LINKID AND TASK.ID = CUSTOM.LINKID LEFT OUTER JOIN CLIENT ON TRANS.PROJECT = CLIENT.ID WHERE (CUSTOMVALUE.VALUE IS NOT NULL) ORDER BY NAME
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SqlServer Table Triggers||3||28|
|online environment for testing sql queries||5||29|
|SQL Session Remains Open After ReportViewerControl Form is Closed.||8||29|
|SQL Server In place upgrade from 2012 to 2014||12||21|