EugeneChiang.com

Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’

Error: Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Reason: Token-based server access validation failed with an infrastructure error. Source Logon Message Error: 18456, Severity: 14, State: 11. Note: This error seems to happen when trying to query the database using SQL Server Manager Studio (SSMS) on a remote computer. This error does not happen when... » read more

Replacing Foreign Key with Check Constraint

Defrag Index Script

uspDbaIndexDefrag xx_dba_indexDefragStatus xx_dba_indexDefragExclusion xx_dba_indexDefragLog

TSQL Parse String

Run SQL Query from CMD

Restart SQL Server from CMD

Call Another CMD

File and Folder in CMD

Variables in CMD

TestScript.cmd Result What is your name: John Specify Project?: 123 Name=John Project=123 Press any key to continue . . .

Parameters in CMD

TestScript.cmd Result D:\>TestScript 1 2 First Parameter: 1 Second Parameter: 2 Press any key to continue . . .