In a procedure, can i query from other database with password?

Page 1 of 1

1 Replies - 697 Views - Last Post: 12 September 2012 - 12:37 AM

#1 notice88  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 81
  • Joined: 21-December 11

In a procedure, can i query from other database with password?

Posted 10 September 2012 - 06:19 PM

Im Using DBName.dbo.TableName to connect to other database, but my database architect put passwords to all other database so my account to database cannot connect to other.. I know the password and username of the account which has access to the database that i want to access.. I just can't find the sql code to connect to other database with password..
Is This A Good Question/Topic? 0
  • +

Replies To: In a procedure, can i query from other database with password?

#2 thava  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 172
  • View blog
  • Posts: 1,560
  • Joined: 17-April 07

Re: In a procedure, can i query from other database with password?

Posted 12 September 2012 - 12:37 AM

if your server is above server 2005
then you can use one of the following
openRowset
opendatasource
linkedserver
Was This Post Helpful? 1
  • +
  • -
Page 1 of 1