Sign in | Join | Help

Piotr Rodak

if datepart(dw, getdate()) in (6, 7)
use pubs;

This Blog

  • Home
  • Contact

Syndication

  • RSS
  • Atom
  • Comments RSS

Search

  • Go

Tags

    • bcp
    • BLOB
    • bug
    • bulk insert
    • c#
    • collation
    • concurrency
    • configuration
    • data access
    • data import
    • database maintenance
    • deadlocks
    • distributed transaction
    • download
    • error
    • errors
    • ETL
    • events
    • format files
    • linked server
    • locking hits
    • MARS
    • Numbers table
    • OLE DB
    • OPENQUERY
    • performance
    • photography
    • practices
    • Profiler
    • programming
    • Reporting Services
    • revelations
    • scientific notation
    • script
    • security
    • source code
    • SSIS
    • SSRS
    • Sybase
    • Tally table
    • textsize
    • tips and tricks
    • trace flags
    • trigger
    • troubleshooting
    • truncate
    • t-sql
    • util

Navigation

  • Home
  • Blogs
  • Forums
  • Photos
  • Downloads

Archives

  • March 2010 (1)
  • February 2010 (2)
  • January 2010 (4)
  • December 2009 (2)
  • November 2009 (1)
  • October 2009 (2)
  • September 2009 (1)
  • July 2009 (1)
  • June 2009 (1)
  • May 2009 (1)
  • April 2009 (1)
  • March 2009 (1)
  • November 2008 (1)
  • April 2008 (1)
  • December 2007 (1)
  • November 2007 (3)
  • October 2007 (2)

Browse by Tags

All Tags » OPENQUERY (RSS)
  • data access
  • linked server
  • tips and tricks
  • t-sql
22 November 2009 22:02

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...
Posted by Piotr Rodak | 4 comment(s)
Filed under: linked server, tips and tricks, t-sql, data access, OPENQUERY
 
Powered by Community Server (Commercial Edition), by Telligent Systems