Howdy, Stranger!

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

Categories

How to access database with a procedure ?

kishore_peddikishore_peddi Member Posts: 176

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

  • HackmanCHackmanC Member Posts: 441
    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.