×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络,最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络,最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

is that?

本文发表在 rolia.net 枫下论坛SQL Server Enterprise Manager
SQL Server Enterprise Manager is the primary administrative tool for Microsoft® SQL Server™ 2000 and provides a Microsoft Management Console (MMC)–compliant user interface that allows users to:

Define groups of servers running SQL Server.


Register individual servers in a group.


Configure all SQL Server options for each registered server.


Create and administer all SQL Server databases, objects, logins, users, and permissions in each registered server.


Define and execute all SQL Server administrative tasks on each registered server.


Design and test SQL statements, batches, and scripts interactively by invoking SQL Query Analyzer.


Invoke the various wizards defined for SQL Server.
MMC is a tool that presents a common interface for managing different server applications in a Microsoft Windows® network. Server applications provide a component called an MMC snap-in that presents MMC users with a user interface for managing the server application. SQL Server Enterprise Manager is the Microsoft SQL Server 2000 MMC snap-in.更多精彩文章及讨论,请光临枫下论坛 rolia.net
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / 请教:怎样从一个sql-server 访问(remote)另外一个sql-server, 用ip address?
    • up
    • sp_addlinkedserver 或其它什么的,总之是把远程sql server在自己注册一下
      • 多谢!我记得有一种方法是:把remote server 的ip address 和 log in information 嵌在sql 语句中。这方法可以吗?
        • 没见过这种用法,感觉应该不行
        • is that?
          本文发表在 rolia.net 枫下论坛SQL Server Enterprise Manager
          SQL Server Enterprise Manager is the primary administrative tool for Microsoft® SQL Server™ 2000 and provides a Microsoft Management Console (MMC)–compliant user interface that allows users to:

          Define groups of servers running SQL Server.


          Register individual servers in a group.


          Configure all SQL Server options for each registered server.


          Create and administer all SQL Server databases, objects, logins, users, and permissions in each registered server.


          Define and execute all SQL Server administrative tasks on each registered server.


          Design and test SQL statements, batches, and scripts interactively by invoking SQL Query Analyzer.


          Invoke the various wizards defined for SQL Server.
          MMC is a tool that presents a common interface for managing different server applications in a Microsoft Windows® network. Server applications provide a component called an MMC snap-in that presents MMC users with a user interface for managing the server application. SQL Server Enterprise Manager is the Microsoft SQL Server 2000 MMC snap-in.更多精彩文章及讨论,请光临枫下论坛 rolia.net
          • Thanks! I don't understand very well.Could you please tell me where are the article from?
            • sql server books online. lots of stuff. maybe it is installed with sql server 2000.
              • Thanks! Are you the henhen mm in 001? How about your new place? Is everything OK?
                • yes. Thanks.I always use this nickname. the town is not bad. :))
    • Do you mean openrowset ? openrowset is one time ,ad hoc method to connect and access remote data using OLE DB,in which you can specify the data source and login info.
      • Thanks!