view sql server transaction log

1, Tailf Mywork.log | grep--line-buffered finduserlist Real-time tracking log, here is the Finduserlist this method is run, it will print out its logs, used to track the specific log run. --line-buffered is a line of buffers that can be used for real-time monitoring of logs as long as the buffer of the line is full and prints out.2, Tailf-n Mywork.log print the last 500 lines of

We generally think that truncate is an operation that cannot be rolled back, it deletes all the data in the table and resets the identity column. If you do a truncate operation in a transaction, you can roll back. Conversely, it does not recover data from the log file file. It does not record the deleted data in the log file, it only records the cell allocation

concurrent operations and ensure data integrity. SQL Server automatically adds the appropriate locks to the database based on the user's request. Assuming that a user operates on only a subset of the row data in one table, the system may add only a few row locks (rids) or page locks to support as many concurrent operations as possible for multiple users. However, if multiple records in a table are frequent

Deleting a message will cascade the reply information. At this time, we need to use the transaction, as shown in the following SQL Copy codeThe Code is as follows: alter procedure [dbo]. [proc_tb_leaveword_delete] ( @ LeavewordID INT, @ Record TINYINT OUTPUT ) AS BEGIN BEGIN TRY BEGIN TRANSACTION Delete from tb_leavewordID WHERE leavewordID = @ leavewordID Delete

Tags: style blog color ar sp div on log bsSelect * fromBankInsert intoBankValues(10000)Insert intoBankValues(20000)--Open a transactionbegin Tran--Defining temporary variablesDeclare @num int = 0;UpdateBankSetBalance=Balance-15000 whereId=1Set @num = @num + @ @error;--Previous statement error countUpdateBankSetBalance=Balance+15000 whereId=2Set @num = @num + @ @error;if @num 0 begin--rolling back a transactionrollback TranEndElse begin--Commit a

SQL server determines whether a database, table, column, or view exists. SQL server 1. Determine whether the database exists If exists (select * from sys. databases where name = 'database name ')Drop database [database name] 2. Check whether the table exists. If exists (sele

('sysdiagrams ', 'dtproperties ')5. Obtain the table name, field name, field type, and type length of the specified table [tb_phone ].SELECT SysObjects. name AS Tablename,Syscolumns. name AS Columnsname,Policypes. name AS DateType,Syscolumns. length AS DateLengthFROM Sysproperties RIGHT OUTER JOINSysobjects INNER JOINSyscolumns ON Sysobjects. id = Syscolumns. id INNER JOINPolicypes ON Syscolumns. xtype = policypes. xtype ONSysproperties. id = Syscolumns. id ANDSysproperties. smallid = Syscolumn

Error logs and access log files provide useful information for system administrators, such as troubleshooting Web servers, protecting the system from a variety of malicious activities, or simply conducting a variety of analyses to monitor HTTP servers. Depending on your WEB server configuration, the error/access log may be placed in different locations in your sy

Often listen to the students of Oracle materialized view, one of the functions of materialized view is that you can implement query rewriting, it sounds like a tall feeling, SQL Server also has the function similar to Oracle materialized view, just called indexed

The server side looks at the log shell script (where path1 and path2 are replaced with the path feature name, and the path followed by "Tail-f" is replaced with the log file path for the path feature name):#! /bin/SH#Check log.Echo "which path (G/API):"Read PathEcho "Keyword:"Read keywordif["$path"=='g']; Then Tail-F. /project/g.caipiao.163. Com/

I have read many articles about transactions before this article. Most of them are profound and difficult for beginners to understand. Here we will use a very simple example to explain the application of transactions. First, create a temporary table and fill in some data. Create Table # tab (ID int, country nvarchar (10), popu INT) insert into # tab values (1, 'China', '123 ') insert into # tab values (2, 'America ', '000000') insert into # tab values (3, 'Canada', '000000') insert into # tab v

an administrator and create a user DSN, you cannot use this DSN unless you log on to the system with the administrator, and the system type takes effect for all users of the current machine. No matter what identity you log on to the system; A file DSN is actually a text file with the suffix name of DSN. From the Visual FoxPro point of view, the author divides th

information information: After attaching the database, a new log file log is generated and the size of the new log file is 504K. You can also do this by using a command: Use master; exec sp_detach_db @dbname = ' TestDB '; exec sp_attach_single_file_db @dbname = ' TestDB ', @physname = ' D:program filesmicrosoft SQL