in-memory oltp

Technical Article

Linked Server

  • Topic

Hai ALLI am not able to access the data in ms access through Linked Server. But if i logged in as "SA" i am able to access the data I am using "four part name" method for accessing the the query analyzer it is giving the following errorServer: Msg 7416, Level 16, State 2, Line […]


1 reads


Tales From The Field Weekly Wrap Up for the Week of 01-23-2022


 Hello Dear Reader!  It's been a while since I had time to sit down...

CONCAT_WS Function Truncates Text


I was writing some dynamic SQL that generates some SQL statements to load my...

Flyway Desktop Projects for My PoC


In a previous post, I set up the basic databases for the PoC project...

Read the latest Blogs


Track Insert/Update/Delete Operations in Sql Server DB Table

By RCRock

Hi Team, I have a requirement to track any insert/update/Delete operations happened against Database...

Microsoft SQL over IPSEC VPN TPLink routers - 2 locations

By cpaphouse

Hi Experts. We recently set up a second location. our software at our first...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers