Post reply

Object_id, Object_name, DB_ID() for Multi DBs and Linked Servers!

  • June 14, 2012 at 2:19 am

    #262860

    Hi folks,

    In a generic problem we need to link two database schemas for specific business requirement of data portability.

    We have obviously need excessive usage of OBJECT_ID, OBJECT_NAME and DB_ID() built-in functions.

    Can anyone describe these functions in following scenarios.

    1. SAME SERVER - Different Databases

    2. Different Instances - SAME Server

    3. Different Servers

    Meanwhile if we need to identify database id from system views/tables, then from where to get? (simply other than sys.databases :w00t:)

    Many thanks... and sorry for a little wordy post!!!

  • November 24, 2015 at 11:03 am

    #1842139

    Hey Abrar,

    Were you able to figure out a way to use the built-in functions in a linked server?

    I'm curious to find out how was it achieved, specifically for different servers.

    Thanks!

  • January 13, 2016 at 4:30 am

    #1851527

    Ehtesham Zulfiqar (11/24/2015)

    Hey Abrar,

    Were you able to figure out a way to use the built-in functions in a linked server?

    I'm curious to find out how was it achieved, specifically for different servers.

    Thanks!

    [font="Verdana"]

    Zulfiqar,

    I am bit late to notice your response.

    Actually i dont think so that Object_id or other functions would be helpful in these scenario. So i think we had re-tailored our logic to rather than getting dynamic objects/details at execution time, we adopted static mapping of the objects/tables/columns/or whatever else was required in static database tables.

    [/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply