Tutorials to .com

Tutorials to .com » Database » Sqlserver » Microsoft SQL Server Tutorial

Microsoft SQL Server Tutorial Articles


581: Database table structure
...

582: Web Assistant Wizard
20.5.1 Web Assistant Wizard function Web Assistant Wizard is provided by SQL Server Web Publishing Wizard. It is very simple, practical, even for Web-illiterate, he can also use it to generate a database page. Web Assistant Wizard has the followin...

583: HTTP-based data access
In addition to XML technology, Microsoft SQL Server 2000 developers have HTTP access through the properties (HTTP access9 as SQL Server 2000 features a core. So that users can put the SQL Server on a URL in order to ensure the development of and pot...

584: XML documents and database tables
Including SQL Server 7.0 and other versions of SQL Server series does not provide XML. Support the development of staff previously had to use an XML parser, such as Microsoft's XML Parser (MSXML), and they must write your own code to deal with t...

585: XML technology
20.2.1 XML Introduction XML is the Extensible Markup Language (Extensible Markup Language) English abbreviation. XML language is the next generation of large-scale Web's leading technology, which is based on SGML, the simple and flexible langua...

586: SQL Server 2000 and Internet-support the new features of Web applications
In today's business world of the network is becoming increasingly common, it penetrated into every corner of life, thus the operation of enterprises, organizations, and other management methods have an enormous impact. Network characteristics to...

587: SQL Query Analyzer
Introduction 19.3.1 SQL Query Analyzer SQL Query Analyzer is a graphical management tool, primarily used in the preparation and testing Transact-SQL statement, batch. System administrators and developers through the SQL Query Analyzer to run multip...

588: Use SQL Server Profiler
19.2.1 understand the SQL Server Profiler SQL Server Profiler is a graphical real-time monitoring tools to help system administrators to monitor the conduct of the database and server, such as the number of deadlocks, fatal errors, tracking Transac...

589: SQL Server tools - SQL Mail
SQL Server in addition to providing a powerful management tool Enterprise Manager, a reliable security management and database backup and restore functions, built-in components other than the copy also includes a number of other tools and features g...

590: Alert
DTS Wizard and DTS Designer are the same as isomorphism between heterogeneous data sources or data import, export and conversion. However, DTS Designer is a graphical tool, which allows to create and edit DTS packages become more simple, easy, and p...

591: DTS Import, Export Wizard
DTS Import, Export Wizard to help users to build interactive package, in order to have the OLE DB and ODBC driver data source and destination of data between the source of the import, export and conversion. Will be the following two specific example...

592: The basic concepts of Data Transformation Services
In the use of SQL Server process, often due to a number of different locations from the data together in various locations or to copy the data, so data export, import is a very common operation. We can use the BCP command to complete this a task, bu...

593: sql warnings
In the SQL Server Manager through the definition of alarm alerts when certain events will be automatic alarm. When the alarm is triggered, the notification by e-mail or paging operators, thereby allowing system operators to understand what events, s...

594: sql operation
Means the definition of operating the multi-step tasks, each step may be carried out are Transact-SQL statement, on behalf of a task. Operation is typical of the planning tasks, and automate tasks. Database backup and recovery, data replication, dat...

595: SQL Operator
Operator means the receiving by the SQL Server Agent to send the message to the object, SQL Server can be through e-mail, pager or network message sent to the alarm notification to the operator, thereby to know what kind of system is in a state or e...

596: Agency services - Configure SQL Server Agent
SQL Server Agent is a mission planning and the alarm manager, practical application and the environment, you can be the definition of those cyclical activities into a task in SQL Server Agent to help run automatically; if you are a of system adminis...

597: Replication Monitor
In SQL Server, replication is the most powerful and most complex components, so the application of specific replication errors are inevitable thing. But at the same time It is gratifying to see, SQL Server provides a replication management tool - to...

598: Copy of planning options
SQL Server 2000 provides more than the previous version of the copy options, including ordering an immediate update, and queued updating to queued updating as a hot backup of an immediate update, copy the data transmission, the publication of data f...

599: Merge replication
An overview of merge replication Perhaps readers of the following practical examples are no strangers to large enterprises in a distribution system, the sales manager or sales of key personnel often have to go out of business, the contract will be ...

600: Copy Service
16.4.1 copy the characteristics of services In front of us pointed out that the nature of replication from source database to copy data to the target database, but in terms of different types of replication is always different. Copy the contents fr...


Page 30 of 39
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]   [33]   [34]   [35]   [36]   [37]   [38]   [39]