tailieunhanh - Beginning SQL Server 2005 for Developers From Novice to Professional phần 2

Mô tả American Standard Code để trao đổi thông tin, được sử dụng trên hầu hết các máy tínhVấn đề với ASCII là nó hỗ trợ bảng chữ cái trên và chữ thường Latin, số 0-9, và một số ký tự thêm: tổng cộng 128 ký tự. Sau đây là các ký tự in của ASCII (các nhân vật khác là những thứ như thức ăn đường và các nhân vật vận chuyển-trở lại). | 30 CHAPTER 2 SQL SERVER MANAGEMENT STUDIO 7. As you can see the only real difference from the Connect to Server dialog box is that the Server Name combo box is empty and there is a new section called Registered Server. In this area you can give a registration a different name such as Development Server or User Testing Region and on top of this give the registration a description. You don t have a server to register so just click Cancel now. 8. Moving back to SSMS s explorer window below the registered servers take a look at the Object Explorer which should have been present when you first brought up SSMS. If it isn t there or if it disappears you can redisplay it by selecting View Object Explorer or by pressing F8. You will likely use this explorer the most as it details every object every security item and many other areas concerning SQL Server. You can see that SSMS uses nodes which you expand by clicking the signs to keep much of the layout of the Object Explorer the hierarchy compact and hidden until needed. Let s go through each of the nodes you see in Figure 2-6 now. Figure 2-6. Object Explorer nodes Databases. Holds the system and user databases within the SQL Server you are connected to. Security. Details the list of SQL Server logins that can connect to SQL Server. You will see more on this in Chapter 4. Server objects. Details objects such as backup devices and provides a list of linked servers where one server is connected to another remote server. Replication. Shows the details involving data replication from a database on this server to another database on this or another server or vice versa. Management. Details maintenance plans which you will learn more about in Chapter 7 and provides a log of informational and error messages that can be very useful when troubleshooting SQL Server. Notification Services. Sends out notifications of changes of data or objects to the outside world via media such as e-mail or SMS. People can subscribe to these .