Tag：sqlserver
-
Time：2021-10-21
Due to its own vulnerability in SQL2000 database, hackers can easily obtain system administrator privileges through him. SQL runs with system permission by default, and the permission is super powerful. In order to make the server more secure, it is recommended to set SQL2000 to run with the permissions of ghosts, so that even if […]
-
Time：2021-10-19
Steps: 1、 Create a new text document xxx.txt and modify the file type to. UDL 2、 Open the file and find the corresponding service in provide data. 3、 Select the required database in the connection and fill in relevant information. 4、 Test the connection. If it succeeds, skip to the next step. If it fails, […]
-
Time：2021-10-4
The sa password of SQL2000 cannot be changed. The following error occurs when changing the sa password: Copy codeThe code is as follows: Error 21776: [SQL-DMO] The name ‘dbo’ was not found in the Users collection. If the name is a qualified name, use [] to separate various parts of the name, and try again. […]
-
Time：2021-9-22
One requirement is to store multiple states (including various exceptions and warning states that can exist at the same time) in a cloud monitoring state value. The bit operation mechanism is used to store them in an int type. At present, the amount of monitoring log data is very large (100 million level). The data […]
-
Time：2021-9-21
In recent days, the technical maintenance personnel of the company frequently asked me to restore the database, because they always lack the where condition, resulting in the irrecoverable consequences of update and delete. In addition, those databases are dozens of G. It will take at least ten minutes to recover. To this end, I found […]
-
Time：2021-9-20
Make a backup before deleting. When logging in to the database using SQL server, the logged in records will appear in the login box. The following is the deletion method: SQL Server 2008 Delete the drive letter: \ documents and settings \ user \ application data \ Microsoft \ Microsoft SQL Server \ 100 \ […]
-
Time：2021-9-18
Paragraph restore remains checked to ensure that the database will be consistent at the end. After the restore sequence ends, if the recovered files are valid and consistent with the database, the recovered files will directly become online. Paragraph restore is applicable to all recovery modes, but it is more flexible in full recovery mode […]
-
Time：2021-9-10
catalogue 1、 Setting up SQL server authentication 2、 Set up windows authentication 1、 Setting up SQL server authentication 1. Press windows + R to pop up the run box. 2. Enter CMD in the pop-up box and press enter. 3. Enter the command compmgmt.msc in the DOS command window and press enter. 4. In the […]
-
Time：2021-9-3
explain: There are many reasons for shrinking logs, some due to insufficient space, and some due to application constraints. –Set recovery mode to simple ALTER DATABASE xszzxt_test SET RECOVERY SIMPLE GO –Shrink log file size to 10m DBCC SHRINKFILE (N’xszzxt_test_log’ , 10, TRUNCATEONLY) GO –Set recovery mode to full ALTER DATABASE xszzxt_test SET RECOVERY FULL […]
-
Time：2021-9-2
explain: As long as the “column name” data of the data table is the same, it indicates that there are two duplicate data (the ID is the primary key of the data table, which will grow automatically). Recommended method I –Method 1 Select * from table name a where not exists (select 1 from table […]
-
Time：2021-9-1
The rand() function is the system’s own function to obtain random numbers. You can directly run select rand() to obtain floating numbers between 0 and 1. If you want to obtain an integer random number between 0 and 100, you can use Select round (100 * rand(), 0) in this way. For ease of use, […]
-
Time：2021-8-31
When we operate the table, we will inevitably encounter accidental deletion, or the deleted data still wants to be recovered. Maybe careful friends will use begin tran rollback / commit to avoid mistakes, but this is not the safest. If you commit something and find that it is deleted incorrectly or forget to commit, resulting […]
