Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ SQL statement to repair SQL Server database     - Installation and configuration to compile MySQL 5.6.10 under CentOS 5.9 (Database)

- Ubuntu install virtual machine software VirtualBox 4.3.10 (Linux)

- Thinking in Java study notes - Access modifiers (Programming)

- Introduction to Linux Shell (Programming)

- Ansible module Know (Linux)

- Access.log Apache access log analysis and how to import it into MySQL (Server)

- Getting case of Python Hello World (Programming)

- Use Ansible to bulk manage remote servers (Server)

- Teamviewer not start in Linux (Linux)

- Object-C in the preparation of multi-parameter function parameter is omitted (Programming)

- Zabbix installation and configuration process (Server)

- How to Install Cantata MPD 1.3.3 for Ubuntu and Derived Version Users (Linux)

- Debugging with GDB tool Go (Programming)

- SSL VPN SSL VPN access to security websites patron (Linux)

- CentOS environment prepared crontab scheduled tasks (Linux)

- The wrong in Linux: too many open files (Linux)

- Linux partition command (Linux)

- Linux disk partition batch format mount script (Linux)

- MySQL5.6 based GTID master-slave replication (Database)

- Linux operating system security management skills notes (Linux)

 
         
  SQL statement to repair SQL Server database
     
  Add Date : 2018-11-21      
         
       
         
  Using SQL Server database in the process, due to the power failure or other reasons, it may cause the database to some minor errors, such as particularly slow to retrieve some of the tables, query data can not meet the conditions and the like.

The reason for these conditions, often because some damage to the database, or index is not complete.

In ACCESS, there is a repair database function can solve this problem, in the SQL Enterprise Manager, do not have this feature, use the statement to complete, the following describes how to complete repair of the database with SQL statements should be noted that, during the when the following operations must disconnect all connected users:

USE MASTER

GO

sp_dboption '' your database name '', '' single user '', '' true ''

Go

DBCC CHECKDB ( '' your database name '', REPAIR_REBUILD)

Go

USE your database name

go

exec sp_msforeachtable '' DBCC CHECKTABLE ( '' ''? '' '', REPAIR_REBUILD) ''

go

sp_dboption '' your database name '', '' single user '', '' false ''

Go
     
         
       
         
  More:      
 
- Use Python to perform system commands common usage (Programming)
- Use custom backup plans for Debian backupninja (Linux)
- Run Windows in FreeBSD bhyve (Linux)
- Briefly explain the invasion of the four-level denial of service attack DoS Linux server (Linux)
- lack of SWAP space during installation of Oracle (Database)
- Under Ubuntu on how to use iptables firewall (Linux)
- Let Linux operating system more secure (Linux)
- Android development, may cause a memory leak problem (Programming)
- Ubuntu install the camera driver (Linux)
- The new features of MySQL 5.7 Generated Column (index function) (Database)
- CentOS installation Docker series (Linux)
- How to use the DM-Crypt encryption Linux File System (Linux)
- How to find out a Unix system library files are 32-bit or 64-bit (Linux)
- Spring multi data source configuration (Programming)
- To install network scanning and packet sniffer tool Nmap 7.00 under ubuntu (Linux)
- Terminal multiplexing tool tmux use (Linux)
- Oracle 11g + RAC + RHEL6.5 + udev + ASM + PSU installation summary (Database)
- Linux system Perl Lite netstat (Linux)
- The Objects in JavaScript (Programming)
- Linux System Getting Started Learning: The Linux logrotate (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.