Max server memory

Max server memory is very important if you are using full-text searching to any great extent, because you need to limit the amount of memory SQL Server will use so as not to starve the MSSearch service. It is recommended that you limit SQL Server to half of the available memory (physical plus virtual) if you are running full-text searches. Otherwise, it is best to figure out how much the operating system needs and then set SQL Server to use all the available memory minus the memory that the...

Meta Data Services Programming

In December 1998, Microsoft transferred rights to maintain and evolve the Open Information Model to the Meta Data Coalition (MDC), an industry consortium comprising dozens of vendors of enterprise tools, metadata management tools, and data warehousing products. The MDC determines the Open Information Model (OIM) standard, which is a vendor-neutral metadata standard in much the same way OLE DB is a data source-independent access standard. In July 1999, the MDC released version 1.0 of the MDC...

Sqlvariant

The sql_variant data type is, as you'd expect, more complex. It is similar to the Visual Basic variant data type. It cannot store certain data types, which include text, ntext, image, timestamp, and sql_variant types. You could place a unique index on a sql_variant column or use it as a primary key with limitations. If a sql_variant is used as a primary key, it cannot exceed 900 bytes in length. In addition, it does not support the IDENTITY attribute. Metadata is stored along with the value,...

Maintenance Plan Wizard Database Integrity Check

Periodically scanning your database for object integrity and allocation is an important proactive task that can prevent minor problems from becoming major ones. Many administrators periodically run the DBCC CHECKDB to perform these checks. The maintenance wizard will assist you in setting up scheduled execution of the DBCC CHECKDB statement on your database Check database integrity Selecting the Check database integrity option will run the DBCC CHECKDB command on your database at the scheduled...

Selecting a Recovery Model

The trunc. log on chkpt and select into bulk copy options have been replaced with three recovery models in SQL Server 2000. To simplify recovery planning and backup and recovery procedures, you can select one of the recovery models shown in Table 1.3 from the database Properties dialog box on the Options tab. Table 1.3 SQL Server 2000 Recovery Models Simple Recover up to the last successful backup. Remaining changes must be redone. Full Recover to any point in time. Bulk-Logged Recover up to...

Determining Data Recovery Requirements

The way your backup strategy is designed is based on the requirements for your data recovery. These requirements can simply be formulated as How much information are you willing to lose, and what is the maximum time available for recovery These questions boil down to financial costs. The perfect solution is one of no loss of information and recovery in zero seconds. Such a solution requires significant investments in hardware to accomplish this level of data protection. The result is choosing...

S

See Storage area network System area network Scalability. See Databases Structured Query Language Server Structured Query Language Server 2000 enhancements, 25 Scalar user-defined functions, 610 Scaling, up down, 94-98 Scaling up out, 652 Schedule, specification, 173-174 Scheduling intervals. See Differential backups Transaction logs Schema, type, 520 Schema change replication, 550 Scripts. See ActiveX JScript on-demand execution, 550 per-snapshot execution, 550 Development Kit Second...

M

See Structured Query Language name, 160-161 Maintenance Maintenance plan, 160 Maintenance plan, 338-339 completion, 178-180 history, 178 Maintenance Plan Wizard, 172-180, 286-288. See also Database Maintenance Plan Wizard MAKE DIRECTORY commands, 154 MAPI. See Messaging Application Programming Interface Mapping schema, example, 13 Master database, 132, 199, 221, 316, 318 backup, 317 Master Stored Procedures, transferring, 411 MAX functions, 619 Max server...

Configuring IIS for Analysis Services

Microsoft's Web server, known as Internet Information Server (IIS), must be installed in order to allow access to Analysis Services across the Web. IIS version 4 or later is required to be installed. In order to install it, the underlying OS must be either Windows NT Server 4.0 or Windows 2000. Note that for Windows 2000 Professional installations, the Administrative Tools pack must also be installed. Follow these steps to use IIS with Analysis Services 1. Copy the Msolap.asp file from the...

Figure 217 The SQL Server Properties Processor tab

Priorities are applied to threads by combining the priority class of the process with the priority level of the thread. Selecting Use NT fibers tells SQL Server that you want an instance of SQL Server to use fibers instead of threads. When using fibers, SQL Server allocates one thread per CPU and then allocates one fiber per concurrent user, up to the maximum worker threads value. This setting takes effect after you restart the server. The principle difference between threads and fibers is that...

Msdb

Replication publishers and distributor information Log shipping configuration and monitoring information The msdb database file (msdb.mdf) and msdb log files (msdb.ldf) are located in the Program Files Microsoft SQL Server Mssql Data directory. Due to the amount of configuration information stored in the msdb database, the database should be routinely backed up. If the msdb database becomes damaged or corrupted, you can rebuild a default msdb using a SQL build script installed during the...

Configuring the Servers

As illustrated in Figure 14.2, each server must be configured to communicate with the other servers in the federation. To do this, provide a linked server definition on each server with information about how to use OLE DB to talk to the Figure 14.2 Communication among linked servers. Figure 14.2 Communication among linked servers. other servers. For instance, Serverl must have definitions for Server2 and Server3. Likewise, Server2 must have definitions for Serverl and Server3, and Server3 must...

OLTP vs OLAP vs Data Warehousing

Perhaps the primary goal of data warehousing is to provide data from across the entire organization in a state that can be used by users who require it to make informed business decisions. The term data warehouse is used to describe an unchanging store of collected data, gathered from the entire organization and available for browsing by users. You might also encounter the term data mart, which is a subset of data from a data warehouse, commonly data for a single department. So what is the...

Using the SQL Server View Mapper

From the Start button, select Programs Microsoft SQL Server XML Tools XML View Mapper. 2. You will see a dialog box asking you to create a new project or open an existing project. Choose Create a new XML View Mapper project, and click the OK button. This action brings up a blank project, as shown in Figure 11.6. Figure 11.6 A new project in the SQL Server View Mapper. Figure 11.6 A new project in the SQL Server View Mapper. 3. Now let's add a SQL Schema. Click the left...

SQL Server XML View Mapper

Microsoft has released a tool that will assist you in creating an XML View schema file with which to map an XDR schema to a SQL Server schema. This tool, still in beta testing at the time of this writing, is designed to work with the new XML functionality built into SQL Server 2000. It helps to speed the process of writing an XML View schema by hand and automates much of the process of merging the two schemas. Downloading the SQL Server XML View Mapper To use this tool, you must download it...

Indexed Views

A view is a predefined query that you can access as you would a table. It prevents users from seeing unauthorized information and hides the data structure. However, views do not give much of a performance gain. The query is precompiled for faster execution, but the tables involved in the query are scanned each time the view is used. Any aggregations and joins are established at runtime. Now, with SQL Server 2000, you can place clustered and nonclustered indexes directly on views. Rules applying...

For Xml Syntax and

When executing queries against a SQL Server database using HTTP, you can return XML documents using the FOR XML syntax. The syntax for using the FOR XML clause follows FOR XML mode , XMLDATA , ELEMENTS , BINARY BASE64 Refer to Table 11.9 for a description of each syntax argument. Table 11.9 FOR XML Syntax Arguments Keyword Description Mode Specifies the format of the XML document being returned. This can XMLDATA Specifies that an XML schema is to be returned. The schema is included at the...

User Defined Functions

A significant addition to the programmability of SQL Server is the new User-Defined Function (UDF) object. We use dozens of the built-in SQL functions to manipulate and process data, define computed columns, and control logic flow in all our SQL applications, but now SQL development is no longer restricted to that list of predefined SQL functions from Microsoft. With support for returning single values such as integer or character data and the ability to return the new table data type, UDFs in...

Table Row Guid and Identity Values

Columns with the IDENTITY property are system-generated sequential integers that are often used as primary keys because they are unique when they are assigned to each row in a table. IDENTITY columns pose a bit of a problem during replication between servers because the sequential number used on each server has the potential to be accidentally duplicated. There are several ways to get around this problem Allow SQL Server to automatically assign identity values based on predefined ranges for the...

T

Table (data type), 603-604 Table user-defined functions, 611 Tables, 130, 183. See also Dimension table Dimensional table Fact table HyperText Markup Language Member tables copying. See Databases design, 656-657 enabling. See Full-text full-text index, creation. See Northwind database indexes, 445 RowGuid, management, 554-559 scans, 138, 660 word occurrences, 395 XML data mapping. See Databases TABLOCK, 445 TABLOCK hint, specification, 445 Tape device, 311, 324 Tape library unit (TLU), 314 Tape...

Custom tasks

The first class of tasks is the one that copies and manages data, and it is listed in Table 9.1. These tasks are used to move and manage data from the data source(s) to the destination data source(s). These are the bread-and-butter operations in DTS and are very commonly used. In addition to moving and managing the data inside data structures, this class includes tasks that can move and manage the data that define database objects. You cannot move only the data in a table you also move the...

ActiveX Data Objects

The XML features in Microsoft SQL Server 2000 can be used by applications through the Microsoft OLE DB Provider for SQL Server, which allows applications to use ADO to access these features via a data access model with which many developers are already familiar. With ADO, applications can use template queries, XML views, and the OPENXML function. You can also open and save XML files and load them into an ADO Recordset object. This is accomplished using the Recordset object's Open and Save...

FAQs

Q My SQL statement works correctly until I place it in a user-defined function. Why A You have probably included a statement that has side effects. User-defined functions are intended to return information, not change data outside the scope of execution. Therefore, external tables cannot be modified, e-mail cannot be sent, and can database objects cannot be created. Q In SQL Server 7.0, if you needed to load a temporary table with the results of a stored procedure, you needed a statement that...

SQL Server Backup and Recovery Chapter 7 339 Figure 720 Specify the Transaction Log Backup Plan dialog box

Database Maintenance Plan Wizard MORTHWIMD Specify the database backup plan to prevent failure and data loss. > 7 Back up the database as part of the maintenance plan p1 Verify the integrity of the backup on completion of the backup Location to store the backup file r Tape P Disk Schedule Occurs every 1 week(s) on Monday, Tuesday, Wednesday, (Thursday, Friday, Saturday, at 0 30 00. If you decide to make the transaction log backup part of this maintenance plan, you can Check Verify the...

Database Backup Options

Saving the content of your database to another storage device can be done in a number of ways. If these options are used in the proper way, you can have an efficient backup strategy with minimal loss of data. A complete database backup writes all data in the database to the backup storage media. Depending on the size of the database, this can be a lengthy operation. Therefore, a complete backup should be done at a larger interval than the other backup options. This interval will increase with...

Using XPath Queries

Now let's take a look at XPath queries and how to execute them. An XPath query can either be specified in a URL or it can be put in a template file that is run from a URL. You can even pass parameters to XPath queries. To execute an XPath query against an annotated XDR schema, the schema file is named in the URL or in the template. Remember that to execute a query against a schema, you must first create a virtual name of type schema. The XDR schema file must located in the directory associated...

Database Maintenance Tools

Database maintenance is a mission-critical job in today's information-gathering society. For instance, on the Internet, databases provide the means of obtaining and retaining shipping information for online shoppers. When an online shopper returns to the same site, if the shipping information is retained, the shopper has less data to enter in order to purchase an item. So, it appears that both the shipper, who retains accurate location information, and the shopper, who needs less time to...

Maintenance Plan Wizard Update Data Optimization Information

Your maintenance plan can include rebuilding indexes, updating statistics, and reorganizing free space to provide more efficient query performance and data storage. You can select from the following options Reorganize data and index pages If you select this option, your indexes will be rebuilt based on the schedule you set. Rebuilding the indexes will rearrange the data and provide space for additional data on each page. To determine how much space should be left on each page for new data, you...

New Data Types

SQL Server 2000 adds three new data types to SQL Server's relational data-base engine bigint, sql_variant, and table. The bigint data type is an 8-byte integer type with values ranging from -263 (-9,223,372,036,854,775,808) through 263-1 (9,223,372,036,854,775,807). The sql_variant data type is familiar to many Microsoft Visual Basic developers but is a new concept to SQL programmers. The sql_variant type is capable of storing various SQL Server data types, with the exception of text, ntext,...

Restoring a Database Backup

The easiest way of restoring the Northwind database is to use the Enterprise Manager. Select the Northwind database in the tree under < Your_Database_Server> Databases. Then select Tools Restore Database. This will open up the Restore Database dialog box (see Figure 7.23). The Restore Database dialog box has two tabs General and Options. The layout of the General tab is related to the type of restore (Database, Filegroups or Files, From Device) you will select. Let's take a look what other...

Publisher

The server that contains the actual database or databases to be replicated is referred to as the Publisher. The Publisher also keeps track of the specific modifi- Database Replication Techniques and Configuration Chapter 12 547 Figure 12.1 SQL Server 2000 replication roles. cations that have been made to the replicated data. Any server running SQL Server 6.5 or higher (depending on replication method) or one of several heterogeneous databases such as Oracle or DB2 can publish data for...

Data Mining Algorithms

Data-mining algorithms are at the heart of the data-mining process. These algorithms determine how cases are processed and hence provide the decision-making capabilities needed to classify, segment, associate, and analyze data for processing. Currently, Analysis Services supports two algorithms clustering and Microsoft decision trees. It also provides support for the OLE DB for Data Mining API, which allows third-party providers of data-mining algorithms to integrate their products with...

Sqldmo Bulk Copy

The BCP application provides a great deal of functionality, but it is hindered, in some ways, by being a command-line application. If you want to be able to automate many repetitive BCP tasks, the BulkCopy and BulkCopy2 SQL-DMO objects are much more useful to you. The BulkCopy and BulkCopy2 objects encapsulate all the parameters needed for the ImportData and ExportData methods of the Table SQL-DMO object and the ExportData method of the View SQL-DMO object. In addition to providing information...

Minimize Potential Conflicts

Conflicts can arise when certain data types or database properties that are being replicated from one server to another contain unique key fields that are not unique across servers. These conflicts can be resolved by the servers during replication using specialized data types such as timestamp or uniqueidentifier. SQL Server 2000 timestamp data indicate the relative sequence of data modification within a database by use of database-specific incrementing binary numbers. Note Timestamp data are...

Row delimiter

Although a format file allows you to use many different formats of data, the format file itself is an inflexible tab-delimited file. Here is what a format file could look like for the Shippers table in the Northwind database 1 SQLINT 0 4 t 1 ShipperlD 2 SQLCHAR 2 8 0 t 2 CompanyName Latin1_General_CI_AS 3 SQLCHAR 2 4 8 t 3 Phone SQ Latin1_General_CI_AS On the very first line, you will see 8.0. That is the version number of the BCP application. Immediately below it is the number 3, which is the...

SQL Server 2000 Replication

SQL Server 2000 replication accomplishes the synchronization of data among multiple copies of a SQL Server database or of copying the data from a table to another table located on a separate server. Through SQL Server's native replication, you can design a distributed database system among multiple physical servers. The replication occurs automatically, with no human intervention required. One of the enhancements to SQL Server 2000's replication component is the ability to replicate schema...

Merge Replication

Merge replication (see Figure 12.3) distributes data from Publisher to Subscribers while allowing both the Publisher and Subscribers to make updates to the data. Updates can be made when connected or disconnected. Once reconnected, the system merges updates between sites. Merge replication enables various sites to work autonomously and merge updates into a single, uniform result at a later time. Once the initial snapshot is applied to Subscribers, SQL Server 2000 tracks changes to published...

Push vs Pull Subscriptions

Push subscriptions can be created at the Publisher or Distributor using the Push Subscription Wizard. Push subscription metadata are stored on the site from which the push subscription was created. Push subscriptions require more Publisher overhead, so they should be used only in situations in which centralized management is a requirement and when the subscriber is always available to receive the pushed subscription. To create a push subscription for the Northwind snapshot publication created...

Configuring a Subscription to Use FTP to Retrieve a Snapshot

You must create a pull (or anonymous) subscription to the publication once the publication has been enabled for publishing on the Internet. All subscriptions are created the same way, whether or not they use the Internet. The only difference in subscribing to a publication over the Internet is that FTP addressing properties (FtpAddress, FtpPassword, FtpPort, and FtpUserName) must be configured for use by the Distribution Agent or Merge Agent. FTP addressing can be configured through SQL Server...

Multiple Server Instances

SQL Server 2000 supports multiple instances of SQL Server 2000 on a single server. An instance is similar to a virtual SQL Server it has its own name, its own set of passwords, and its own settings that can be different from the other instances on a particular machine. Instances can have different collation and language settings as well. This allows for quite a bit of flexibility with SQL Server. Only one instance on a machine will be the default instance. The default instance behaves as a SQL...

How to Restore a Replicated Database from Backup

In general, you cannot keep replication settings if you restore to a different server database than your backup. Replication metadata are automatically removed by the Publisher or Merge Subscriber server when you perform a full restore to a different database or server. Therefore, you will need to completely < Any time you make modifications to your replication setup, it is a good idea to make a backup in addition to your normal scheduled backup. It is also a good idea to keep a before backup...

Monitoring Log Shipping

The monitor server can be used to view detailed log-shipping information for the source server and destination server(s). Monitored data includes when the last backup and restore took place and backup load timeout or failure notices. Alert information can also be filtered or suppressed. If a destination server was previously configured to allow it to change roles, you can also use the Log Shipping Monitor to change it to a source server in the event of system failure. 1. Connect to the Monitor...

Data Mining Training

Before a data-mining model is able to produce predictions of any worth, it must go through a period of training. During this training period, the model works with a set of known (actual) data as it attempts to identify patterns, rules, and trends among that data. The concepts behind the training process are similar across OLAP and relational mining models. Put simply, the training data are expected to be found in the source tables or cubes used to build the mining model. SQL Server Analysis...

Configuring a Publisher or Distributor to Listen on TCPIP

Publishers and Distributors must be enabled to listen on either TCP IP (or the multiprotocol network library) before you can publish articles over the Internet. SQL Server 2000 uses TCP IP Sockets to establish an ODBC connection across the Internet between a Publisher or Distributor and a Subscriber. Transactional subscriptions use the Distribution Agent to connect through the Internet to the Distributor merge subscriptions use the Merge Agent to connect through the Internet to both the...

TempDB

SQL Server uses the TempDB database for working storage of temporary tables and temporary stored procedures. Temporary stored procedures and tables can be created by users, applications, or the system to support query requests. Notice the use of the word temporary here. The TempDB database is recreated each time SQL Server starts, so the TempDB should not be used for persistent data storage. Temporary tables and procedures that are generated by SQL Server are automatically dropped when...

Configuring a Publication to Allow Subscribers to Retrieve Snapshots Using FTP

Setting the enabled_for_internet property to TRUE on the publication allows you to Internet-publish any publications you create. It also enables the Snapshot Agent to place the files associated with the initial snapshot into the FTP location specified in Publication Properties (see Figure 12.9). Using FTP, the Distribution Agent and or the Merge Agent send snapshots of schema and data to the Subscriber via FTP. Snapshot images are recreated as exact duplicates of publications on the destination...

Snapshot Replication

Lished tables as well as database objects are prepared by the Snapshot Agent, which then stores the files in the snapshot folder and records synchronization jobs in the Distributor distribution database. The snapshot folder is located on the Distributor by default, but you can specify an alternate location instead of or in addition to it. The Distribution Agent copies the snapshot from the snapshot folder to the destination tables at the Subscribers. Additional tasks run on the Distributor for...

Transactional Replication

Transactional replication (see Figure 12.2) uses an initial snapshot of the data applied to the Subscribers, then captures and propagates the individual transactions to Subscribers once data modifications have been made at the Publisher. Figure 12.2 Transactional replication. Transaction logs are used by transactional replication to capture each incremental change made to data in a published table. Microsoft SQL Server 2000 monitors INSERT, UPDATE, and DELETE statements and stores the changes...

Restoring System Databases

Suppose you need to copy the system databases to another database server, overwriting the system databases on that server. You can do this by backing up the system databases on the current database server and do a restore from this backup file on the other server. This can be achieved using the Restore Database option in the Enterprise Manager, as described in previously. You need to do this manually every month. Since you have a busy schedule yourself, it is a task that tends to be forgotten....

Configuring Your Database

As we worked through the Create Database Wizard, you should have noticed that we were never asked to create our filegroups, which we defined in our example database configuration. This limitation reflects the goal of the wizard to get novice administrators up and running with new databases as quickly as possible. Microsoft recommends using a single database file and a single transaction log file for simple database applications, which, again, reflects the expected use of this wizard. We are not...

Database Maintenance Plan Wizard

Recall from our previous example using the Create Database Wizard that when we completed the wizard, we were asked to create a new maintenance plan for our database. If we had answered Yes to that prompt, SQL Server would have started the Maintenance Plan Wizard and walked us through the process of completing this task. As with all the SQL Server wizards, we can still access the Maintenance Plan Wizard from the Tools Wizards menu in Enterprise Manager. In the following sections (steps 1 through...

Warning

If you have to completely recreate a publication database, your replication settings will be lost during the restore unless you run the following stored procedure EXEC sp_replicationdboption. In addition to backing up the publication database, you must back up the corresponding database on the Distributor for that Publisher. Both databases could be needed to restore replication while maintaining transactional integrity. In addition, you need to back up the replication working folder and...

Creating a Database Virtual Directory in IIS

In order to run SQL Queries over HTTP using a URL, you are required to create a virtual directory in IIS and configure it to use an instance of SQL Server and a database on that instance. Configuring IIS to Allow URL Queries 1. From the Start menu, click Programs Microsoft SQL Server Configure SQL XML Support in IIS. 2. Now we will create a new virtual directory called XMLDemo on IIS. Right-click Default Web Site. From the Context menu, select New Virtual Directory. This action will bring up...

Containstable

CONTAINS and FREETEXT are filtering conditions that limit what is returned in your query, as would a join. CONTAINSTABLE and FREETEXTTABLE each return a table containing a KEY and RANK to which your query must join. FREETEXT is the simplest full-text predicate to use. It requires only two parameters the field that you are searching and the search string that you are looking for. It returns TRUE if finds a match for the values in the search string within the columns you are searching. This query...

English Query OLAP Project

Creating an English Query OLAP project is much like creating a SQL Project you can do it without the wizard or with the wizard. If you elect to create a project without the wizard, you must add the entities and relationships one by one. These are the steps for creating an English Query OLAP project from scratch 1. Under the File menu in the Microsoft English Query development tool, select New Project. You will see the New Project dialog box (refer back to Figure 8.7). Figure 8.8 The English...

Creating a Distributed View

The partitioned view is a set of SELECT statements of which the individual result sets are combined into one using the UNION ALL statement. Partitioned views should conform to these guidelines Each individual SELECT statement references one SQL Server base table. The table can be either a local table or a linked table referenced using either a four-part name or the OPENROWSET function. (You cannot use an OPENROWSET function that specifies a pass-through query.) No table can be referenced more...

Overview of XPath Queries and SQL Server Limitations

XPath queries can be executed in several ways. You can specify XPath queries in a template against an XDR schema. You can use inline mapping schemas by including an annotated XDR schema directly in a template. Alternatively, you can map a schema in the URL for the XPath query to execute against. Microsoft SQL Server 2000 does not support all the W3C XML XPath specification. In the next section, we discuss the XPath limitations in SQL Server. It is important to know that the relational operators...

Trigger Enhancements

Triggers are not new to SQL Server, but they have found their way into the list of updates in SQL Server 2000. SQL developers have been using triggers for years to automate and control activity against tables. SQL Server 2000 adds enhancements to the AFTER trigger the only trigger mode in previous SQL Server versions and offers a new trigger mode, the INSTEAD OF trigger. INSTEAD OF triggers can be defined for each of the data manipulation actions UPDATE, DELETE, and INSERT and can be created on...

Partitioning Your Data

Once you have decided on the criteria that you need for data portioning for example, locality or department , a unique CHECK Constraint range on the primary key field in each table on each server must be set to enforce the ranges of data you want each server to own. The key ranges of the CHECK constraints, on each table in a partitioned view, cannot overlap with the ranges of any other table used. Any given value of the partitioning column must map to only one table on each server. The CHECK...

Northwind

The Northwind database, the second of the two sample databases that are included with SQL Server, is modeled after a fictitious company that provides sales data for importing and exporting specialty foods. This popular sample database is commonly used by Microsoft and others. This book also uses the Northwind database throughout its examples. As you can with the Pubs database, you can browse Northwind's table, view, and stored procedures and modify it to examine additional functionality in SQL...

Introduction

Transferring and manipulating data was once the job of trained database administrators. With data the driving factor in markets that require reaction time in terms of minutes, having the information available to analyze is the key to making informed and accurate decisions for your organization. Getting data in and out of SQL Server is a common task, and several tools are available in SQL Server 2000 to accomplish this task. Whether it's importing data from heterogeneous systems such other...

Using the Bulk Copy Object

In order to use the BulkCopy object with Visual Basic, you must access the Microsoft SQLDMO Object Library. You can access it using late binding with the CreateObject syntax, like this Set objSQLServer2 Or you can early bind to it by creating a reference to sqldmo.dll. It will appear as the Microsoft SQLDMO Object Library in the References list. Early binding provides significantly better performance and simplifies new development with the availability of Intellisense. Once you have made a...