Results 1 to 4 of 4

Thread: SQL Server Group

  1. Dec 28th, 2009, 05:40 AM #1
    thermo_ll
    thermo_ll is offline

    Thread Starter
    Junior Member
    Join Date
    Aug 2004
    Posts
    30

    SQL Server Group

    How can i access database in another server group (e.i. i have sql server group local with table1 i have to create trigger to update table1 in another database in another server group)
    Reply With Quote Reply With Quote
  2. Dec 28th, 2009, 03:17 PM #2
    GaryMazzone
    GaryMazzone is offline
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: SQL Server Group

    You need to create a linked server to access the databases on an other server.
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    Reply With Quote Reply With Quote
  3. Dec 29th, 2009, 12:30 AM #3
    thermo_ll
    thermo_ll is offline

    Thread Starter
    Junior Member
    Join Date
    Aug 2004
    Posts
    30

    Re: SQL Server Group

    Linked Server ? how can i do that ? do you have any sample for this , hope you can help me in this ... or if you have any suggestion

    Thanks
    Reply With Quote Reply With Quote
  4. Dec 30th, 2009, 08:53 PM #4
    GaryMazzone
    GaryMazzone is offline
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: SQL Server Group

    The easiest way is in SSMS
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width