database link creation on same server

• supremesubha

  Newbie

  Points: 5

  More actions

  April 27, 2009 at 4:20 am

  #129617

  Want to create a database link in sql server 2005.

  The two databases exist in the same database server . But both have different authentication .

  For eg :

  DB server : DBSQL/DBSQL

  Database 1 : projectdb1

  database 2 : empdb

  I just want to link "projectdb1" from "empdb" both have different sql server authentication.

  Please help me out.

  Thanks in advance

• VastSQL

  SSC-Dedicated

  Points: 36278

  More actions

  April 27, 2009 at 5:36 am

  #984267

  What you mean by link?

  If u want to query a particular table from second db when u r in first then use db_name.schema.object_name