How to access database with a procedure ?


Hi,

Good day. I have written a stored procedure in SQL-Server 2000. Can i execute a different database (for Ex: Oracle database table) with it ?

Advance ThanX for your time & patience.

Cheers,
Kishore

Comments

  • I hope it never happen! You can't neither access another database in the same instance! You have different users id for each database and even each dbms. Even when you can have the same login.

    ----
    :
    : Hi,
    :
    : Good day. I have written a stored procedure in SQL-Server 2000. Can i execute a different database (for Ex: Oracle database table) with it ?
    :
    : Advance ThanX for your time & patience.
    :
    : Cheers,
    : Kishore
    :

    [red]Good luck![/red]
    [blue]Hackman[/blue]

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion