SQL Server application Problem Answer 13 cases (iii)

Source: Internet
Author: User
Tags log modify
Server| Solution | Question: How many ways does SQL Server start a transaction?


Answer: There are three kinds. The first is an explicit, transaction transaction that begins with the beginning of a transaction. The second is automatic submission.
, this is the default setting for SQL Server. Each T-SQL statement is automatically committed after execution is completed. The third is implied transactions, in this way,
SQL Server automatically starts a new transaction after the current transaction is committed or rolled back, and the new transaction is not until the user executes a commit or rollback, then the system
The EC will start a new business. This creates a continuous chain of transactions.


Q: What is the difference between Cluster index and Noncluster index?


A: The structure of Cluster Index and Noncluster index are all balanced trees. The main difference is that the leaf node of cluster index is the data PAGE
The leaf node of the Noncluster index is the pointer to the data page.


Q: Can you modify the name of a table in SQL server6.5,7.0?


A: You can use sp_rename to modify the name of the table.


For example:


Use pubs


CREATE TABLE Test (a char (10))


Sp_rename Test,newtest


This example changes the new table named Test to Newtest.


Q: What happens when you modify the machine name of the machine on which SQL Server7.0 is located and cannot start SQL Server?


A: In this case, run the SQL Server7.0 Setup program. The setup program will reset SQL Server based on the new machine name.


Q: What should I do if there is no successful installation of SQL Server7.0?


A: If you have not successfully installed SQLServer7.0, there are a few files that can help you determine what is wrong with that step. First in the Windows directory
The SQLstp.log file contains detailed information about the setup process. Check this file to determine if Setup was wrong in that step.


If the setup process is faulty in the configured section, view the error log in the Mssql7\log directory and the Mssql7\install directory
Cnfgsvr.out files. Sqlserver7.0setup run an application named Cnfgsvr.exe to configure SQL Server. This program starts SQL Server,
Connect SQL Server and run the initial installation script. Any errors that occur during this process will be written to the Cnfgsvr.out file.


If you are unable to determine the cause of the installation failure, save the above file and contact Microsoft Product Support, professionals who support SQL Server Help
You to solve the problem.


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.