A great and related reference to what we will discuss in this blog post is this one: https://thesqldude.com/2011/12/30/how-to-sql-server-bulk-insert-with-constrained-delegation-access-is-denied/ Linked Servers in a sentence or two: Linked servers in SQL Server are connection definitions from one data source to another (or same instance) so that queries can be written joining tables spanning the multiple data sources. Although … Continue reading SQL Server: Curse Of Linked Server Security And The Fix: Pass-through Authentication
Tag: Connection
SQL Server – Resolve – Cannot generate SSPI context
These links are more for my own reference than anything else to resolve the error: "Cannot generate SSPI context" It is a pesky error message that is related to security setup. All the things you need to check are in the MS article below. How to troubleshoot the "Cannot generate SSPI context" error message In … Continue reading SQL Server – Resolve – Cannot generate SSPI context
SQL Server – TSQL Code Logging To Table
Update (Jan 18, 2017): I was able to add “autonomous transaction” type support to the logger using the means available in SQL Server (a loopback linked server). The new and updated code is available on GitHub. https://github.com/SQLJana/TSQL_Logger ....main post continues below Logging is one of those things no two people can agree on one way … Continue reading SQL Server – TSQL Code Logging To Table
SQL Jana 