Is it possible to add LINKED SERVER

Discussion in 'Databases' started by linkedserver, May 13, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. linkedserver

    linkedserver

    Hi,

    I have 4-5 databases hosted in discountasp.net.
    Now i want to add one of these database as a linked server to another database.

    So i need [ALTER ANY LINKED SERVER ] permission to my login.


    Is it possible to grant this permission to my account.

    please help me regarding this.


    Thanks.
     
    linkedserver, May 13, 2009
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    Unfortunately not.
     
    Bruce, May 13, 2009
    #2
  3. linkedserver

    linkedserver

    Linked Server problem

    I just want to transfer data from one db to another using SQL query.

    these databases have different logins.

    So is there any way to do that other than Linked Server method.

    Thanks.

    ABHI
     
    linkedserver, May 13, 2009
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    i would script the tables you want to transfer.
     
    Bruce, May 14, 2009
    #4
  5. wisemx

    wisemx

    Wouldn't local DTS+SQL do the trick?
    I used to do that to tie SQL Servers together from different countries.
    Salute,
    Mark
     
    wisemx, May 14, 2009
    #5
  6. linkedserver

    linkedserver

    script help


    Since these databases have different login,
    how to write a single script query to connect between thum

    how to login different databses using sql query?

    Thanks

    ABHI
     
    linkedserver, May 14, 2009
    #6
  7. hoagieland

    hoagieland

    Since you can not access one database from within another, you would use ASP.Net as the middle-man to process and store the data you want to either go into or be returned from the secondary database and any database thereafter.
     
    hoagieland, May 15, 2009
    #7
  8. Bruce

    Bruce DiscountASP.NET Staff

    Bruce, May 18, 2009
    #8
  9. linkedserver

    linkedserver

    linkedserver, May 18, 2009
    #9
  10. JorgeR

    JorgeR DiscountASP.NET Staff

    In general, you should be able to Link your local pc to the DASP SQL Server, but you can not Link DASP SQL Servers to each other or Remote Database. If you wish to transfer data over to another server, you can use 1)use the import and export data to each database in SSMS 2)Create a SSIS package locally to your DB to transfer the data 3) use the bcp client tool - export the data and import it back to destination SQL Db
     
    JorgeR, May 19, 2009
    #10
  11. linkedserver

    linkedserver

    Hi,

    I want to do this data transfer programatically.
    I am using an aspx page as an interfase for the clients,I need do this data transfer on a button click.Since i need to transfer a huge amount of data , i dont think it is good to transfer all data to aspx server first and then process from there.

    if there is a linked server facility then i can simply use some SQL queries to do all these things.


    Thanks
    ABHI
     
    linkedserver, May 19, 2009
    #11
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page