in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » t-sql » data access (RSS)

Browse by Tags

  • DATA ACCESS setting on local server

    When you look at the sys.servers catalog view, you will see list of linked servers defined on the server plus one additional row for the server itself. You can distinguish the local server from linked servers by column server_id, which in case of local server has value of 0. select server_id , name ...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Sun, Nov 22 2009

  • MARS - does anyone use it?

    I read recently about MARS - Multiple Active Result Sets, functionality that came with SQL Server 2005. I tried to find some 'real life' example of using MARS. Most of the resources I found showed examples on AdventureWorks database and they were, to say the least, showing how NOT to access the...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Wed, Apr 8 2009
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems