Q: How can I start a transaction on SQL Server?
A: There are three types. The first is an explicit TRANSACTION, which must start with begin transaction. The second is automatic submission.
This is the default setting of SQL Server. Each T-SQL statement is automatically submitted after execution is complete. The third is implicit transactions. In this way,
After the current transaction is committed or rolled back, SQL Server automatically starts a new transaction until the user executes COMMIT or ROLLBACK.
And starts a new transaction. This forms a continuous transaction chain.
Q: What is the difference between Cluster Index and Noncluster Index?
A: The structure of Cluster Index and Noncluster Index is a balance tree. The main difference between them is that the leaf node of Cluster Index is data page.
The leaf node of Noncluster Index is the pointer of DATA in data page.
Q: Can I modify the Table name in SQL Server 7.0 and?
A: You can use SP_RENAME to modify the Table name.
For example:
Use pubs
Create table test (a char (10 ))
Sp_rename test, newtest
In this example, the newly created Table named test is changed to newtest.
Q: After modifying the name of the machine on which SQL Server is located, SQL Server cannot be started. What should I do?
A: In this case, run the SQL Server7.0 Setup program. The Setup program will reset the SQL Server according to the new machine name.
Q: What should I do if SQL Server7.0 is not successfully installed?
A: If you have not successfully installed SQLServer7.0, several files can help you identify the errors in that step. First
The SQLstp. log package contains detailed information about the setup process. Check this file to confirm that Setup is incorrect at that step.
If an error occurs during Setup, view the error log in the MSSQL7Log directory and in the MSSQL7Install directory.
Cnfgsvr. out file. Sqlserver7.0setupruns an application named cnfgsvr.exe to configure SQLServer. This program starts SQLServer,
Connect to SQLServer and run the initial installation script. Any errors that occur during this process will be written to the Cnfgsvr. out file.
If you cannot determine the cause of installation failure, save the above files and contact the Microsoft product support department. SQLServer support professionals will help
You can solve the problem.
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.
