TAILIEUCHUNG - Lesson Administering and Troubleshooting SQL Server 2000: Part 3A

In this lesson, you will learn about: Configuring and Using SQLMail, configuring and Using SQLAgentMail, configuring and Managing Linked Servers, introducing IIS virtual directories to support Extensible Markup Language (XML). | L Lesson 3A Additional Features of SQL SERVER 2000 Objectives Additional Features of SQL Server 2000 Objectives In this lesson you will learn about Configuring and Using SQLMail Configuring and Using SQLAgentMail Configuring and Managing Linked Servers Introducing IIS virtual directories to support Extensible Markup Language XML NIIT Additional Features of SQL Server Lesson 3A Slide 1 of 26 In this lesson you will learn about 5 Configuring and Using SQL Mail 5 Configuring and Using SQLAgentMail 5 Configuring and Managing Linked Servers 5 Introducing IIS virtual directories to support Extensible Markup Language XML Administering and Troubleshooting SQL Server 2000 NUT Additional Features of SQL Server 2000 Pre-Assessment Questions 1. Which of the following SQL Server 2000 job step helps SQL Server Agent to find the application source a Operating system commands b Transact-SQL statements c Microsoft ActiveX scripts d Replication tasks 2. Which of the following attributes of SQL Server alerts and their messages contains the name of the stored procedure if the error has occurred in a stored procedure a State code b Procedure name c Line number d Message string NIIT Additional Features of SQL Server Lesson 3A Slide 2 of 26 NUT Administering and Troubleshooting SQL Server 2000 Additional Features of SQL Server 2000 Pre-Assessment Questions 3. Which of the following functions state the code attribute of the SQL Server alert and their messages a It contains information about the cause of the error place where the error has occurred and the object concerned with this error. b It is used to find the source code location of the error and is used by Microsoft support engineers. c It indicates the line number of the Transact-SQL statement in the stored procedure which has caused the error. d It contains the name of the stored procedure if the error has occurred in a stored procedure. NIIT Additional Features of SQL Server Lesson 3A Slide 3 of 26 Administering and

• Cơ sở dữ liệu
• SQL Server 2000
• Troubleshooting SQL Server 2000 part 3A
• Troubleshooting SQL Server 2000
• Configuring and Using SQLMail
• Configuring and Using SQLAgentMail
• Administering and Troubleshooting SQL Server 2000
• Tự học Microsoft SQL Server 2000
• Học Microsoft SQL Server 2000 trong 21 ngày
• Cơ sở dữ liệu quan hệ
• Cài đặt SQL Server 2000
• Nâng cấp SQL Server 2000
• Tiện ích của SQL Server 2000 Management
• Cơ sở dữ liệu
• Giáo trình SQL Server 2000
• cơ sở dữ liệu SQL Server 2000
• Dịch vụ SQL Server 2000
• Tạo cơ sở dữ liệu
• sử dụng SQL server 2000
• hướng dẫn sử dụng SQL server 2000
• tài liệu sử dụng SQL server 2000
• cẩm nang sử dụng SQL server 2000
• Troubleshooting SQL Server 2000 part 2D
• Lesson Administering and Troubleshooting SQL Server 2000
• Additional lab exercises
• Bảng ảo
• Biến cục bộ
• hàm chuyển đổi kiểu dữ liệu
• Các hàm ngày giờ
• Các hàm toán học
• Các toán tử
• truy vấn dữ liệu
• Cấu trúc điều khiển
• biến kiểu dữ liệu Cursor
• Giá trị mặc định
• Giao tác