Có 40+ tài liệu thuộc chủ đề "thiết kế CSDL quan hệ"
tailieu.vn Xem trực tuyến Tải xuống
ptg TABLE 5.1 Command-Line Utility Installation Locations. sqlcmd x:\Program Files\Microsoft SQL Server\100\Tools\Binn dta x:\Program Files\Microsoft SQL Server\100\Tools\Binn tablediff x:\Program Files\Microsoft SQL Server\100\COM bcp x:\Program Files\Microsoft SQL Server\100\Tools\Binn sqldiag x:\Program Files\Microsoft SQL Server\100\Tools\Binn. sqlservr x:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn executable. The tablediff utility is installed when SQL Server replication is installed. If you can’t find the tablediff.exe in the location specified in...
tailieu.vn Xem trực tuyến Tải xuống
ptg 114 CHAPTER 5 SQL Server Command-Line Utilities. This utility is bidirectional, allowing for the movement of data into and out of a SQL Server database.. The –E option allows you to import data into SQL Server fields that are defined with identity properties.. SSIS is a sophisticated GUI that allows for both data import and data export, and it...
tailieu.vn Xem trực tuyến Tải xuống
ptg The first place you should look when creating a new trace is at the trace templates. The available trace templates, found in the template drop-down on the General tab of the Trace Properties window, are listed in Table 6.1.. This template is useful for debugging client applications where some of the statements are not complet- ing successfully.. After you...
tailieu.vn Xem trực tuyến Tải xuống
having a trace file gobble up all the disk space on the drive you are writing to. You can also use this file size option in conjunction with the Enable File Rollover option. When the Enable File Rollover option is used, the trace does not stop when the file size maximum is met. Instead, a new trace file is created,...
tailieu.vn Xem trực tuyến Tải xuống
ptg TABLE 6.2 Trace Events and Their Related Categories. 102 Audit Database Scope GDR Event Security Audit 103 Audit Schema Object GDR Event Security Audit. 104 Audit Addlogin Event Security Audit. 105 Audit Login GDR Event Security Audit. 106 Audit Login Change Property Event Security Audit 107 Audit Login Change Password Event Security Audit 108 Audit Add Login to Server...
tailieu.vn Xem trực tuyến Tải xuống
ptg 154 CHAPTER 6 SQL Server Profiler. This is the default trace that SQL Server automatically initiates when it starts. You can identify which trace is the default by selecting from the sys.traces catalog view and examining the is_default column. You can disable this default trace, but it is generally light- weight and should be left enabled.. The output from...
tailieu.vn Xem trực tuyến Tải xuống
ptg 164 CHAPTER 6 SQL Server Profiler. Whether you are a developer or database administrator, you should not ignore the power of the SQL Profiler. It is often one of the most underused applications in the SQL Server toolkit, yet it is one of the most versatile. This chapter wraps up the introduction to the tools and utilities available with...
tailieu.vn Xem trực tuyến Tải xuống
ptg TABLE 7.2 SQL Server 2008 Alternatives for SQL Server 2000 System Tables. SQL Server 2000 System Table. SQL Server 2008 System View View Type. sys.foreign_keys Catalog view syscurconfigs sys.configurations Catalog view sysdatabases sys.databases Catalog view sysdepends sys.sql_dependencies Catalog view sysdevices sys.backup_devices Catalog view sysfilegroups sys.filegroups Catalog view sysfiles sys.database_files Catalog view sysforeignkeys sys.foreign_keys Catalog view sysfulltextcatalogs sys.fulltext_catalogs Catalog view....
tailieu.vn Xem trực tuyến Tải xuống
Installing SQL Server 2008. What’s New in Installing SQL Server 2008. Installing SQL Server Using a. I nstalling SQL Server is the first and one of the easiest tasks you’ll accomplish as an administrator. And even though it may take as little as 15 minutes to get SQL Server 2008 up and running by clicking through the install screens and...
tailieu.vn Xem trực tuyến Tải xuống
FIGURE 8.3 System Configuration Checker window. You typically first want to run the System Configuration Checker to confirm that your system meets the minimum hardware and software requirements for installing SQL Server 2008. Click on the link for the System Configuration Checker to bring up the screen shown in Figure 8.3. This is essentially the Setup Support Rules screen that...
tailieu.vn Xem trực tuyến Tải xuống
ptg 204 CHAPTER 8 Installing SQL Server 2008. FIGURE 8.15 Server Configuration page.. Also on the Service Accounts tab, you can select the server startup options for the SQL Server services being installed by selecting the startup type in the drop-down selection list to the right of the service. It is highly recommended to autostart the SQL Server service so...
tailieu.vn Xem trực tuyến Tải xuống
Specify if errors can be reported to Microsoft to improve future SQL Server releases. INSTALLSHAREDDIR=”C:\Program Files\Microsoft SQL Server”. Specify the installation directory.. Specify that SQL Server feature usage data can be collected and sent to Microsoft. This parameter is required when installing the SQL Server Database Engine (SQL), Analysis Services (AS), or Reporting Services (RS).. Startup type for the SQL...
tailieu.vn Xem trực tuyến Tải xuống
ptg 224 CHAPTER 8 Installing SQL Server 2008. Because Slipstream support is introduced with SP1, the setup.exe program that shipped with the original SQL Server 2008 installation media doesn’t support the /PCUSource or /CUSource options that allow you to speci- fy the locations of the service pack and cumulative updates to be slipstreamed.. Instead, you need to run the SQL...
tailieu.vn Xem trực tuyến Tải xuống
ptg 234 CHAPTER 9 Upgrading to SQL Server 2008. FIGURE 9.6 The Upgrade Advisor Progress screen.. Components feature when installing SQL Server 2008. otherwise, SQL Server 2008 will not be able to run your DTS packages (unless they are upgraded to the new SSIS format). Make sure that all the SQL Server services you are analyz- ing are running and...
tailieu.vn Xem trực tuyến Tải xuống
FIGURE 9.14 The Select Instance screen in the SQL Server Installation Center.. Import—Typically, import is the fastest method of upgrading, but an imported full- text catalog does not use the new and enhanced word breakers introduced in SQL Server 2008, so you might want to rebuild your full-text catalogs eventually if not during the upgrade.. Rebuild—This method uses the new...
tailieu.vn Xem trực tuyến Tải xuống
You need to enter the name of your SQL Server 2000 Analysis Services server as the source. Server—You can choose this radio button and enter the name of your new SSAS instance to immediately migrate your OLAP databases.. To fully explore that topic and learn more about other new features and func- tionality in Analysis Services, check out Chapter 51,...
tailieu.vn Xem trực tuyến Tải xuống
ptg was introduced in SQL Server 2005 and was a key part of client configuration. Management features and changes in the SQL Server Configuration Manager (SSCM) tool.. You should look to the SSCM tool and enable or disable the protocols for which you want to allow connections. One last change in SQL Server 2008 Client Installation and Configuration that may...
tailieu.vn Xem trực tuyến Tải xuống
By default, all network protocols except for VIA are enabled on the client during installation.. If you build an application that relies on SNAC, you need to be aware that it can be redis- tributed in two ways:. As part of any SQL Server 2008 installation or upgrade . When you are building MSI files for an application, it is...
tailieu.vn Xem trực tuyến Tải xuống
Note that the .NET provider supports a variety of connection string styles, including ODBC, OLE DB, and OLE DB/SNAC, and you can mix and match some of their respective connection string keywords. Applications built on .NET Framework 1.0 and 1.1 can access SQL Server 2008 databases without issue. The only caveat is that those earlier versions of ADO.NET can’t make...
tailieu.vn Xem trực tuyến Tải xuống
Security can be established on these hierarchical components, which in turn cascades the security to the underlying components. The first level of security encountered when accessing SQL Server is known as. The authentication process performs the validation needed to allow a user or client machine to connect to SQL Server. This connection can be granted via a Windows login or...