view sql server transaction log

Zheng Zuo 2006-6-26 During the BizTalk project, BizTalk Server and SQL The server is not on the same computer, and the SQL adapter is used to send data prompting the error "new transactions cannot be registered to the specified transaction processor". The same problem occurs

Label:SQL Server transaction log unexpectedly increases or fills up the processing methodTransaction log files transaction log file is a file that is used to record database updates, with an extension of LDF.In

Stored Procedure format:CREATE PROCEDURE yourprocedure asbegin SET NOCOUNT on; BEGIN TRY---------------------start catching exception BEIN TRAN------------------start transaction UPDATE A SET a.names= B.names from T1 as A INNER joins T2 as B on a.id =b.id UPDATE A SET a.names= B.names from T1 as A INNER joins T2 as B on a.test =b.test COMMIT TRAN-------COMMIT TRANSACTION END TRY-----------End catch Exceptio

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 ServerMSSQL10.SQL2008MSSQLDATATestDB.mdf ' Second, empty the log This command is supported in SQL Server 2005 and 2000,

Label:Begin transaction--Start TransactionDECLARE @errorSun INT--Define error countersSET @errorSun = 0--yes, 0.UPDATE dbo. Test SET testname= ' 232 'WHERE testid=1--transaction operation SQL statementSET @[email Protected][email protected] @ERROR--whether the accumulation is wrong--waitfor delay ' 0:2:0 '--Delay 2 minutesUPDATE dbo. Testcustorm SET testnickname1

administrator directly run the script, you can get the following results: SQL Server belongs to which release, which version, which service pack, which integration fix pack, and so on. At the same time, the most important thing is that it will give you advice on which recent patch package you should install and which Servcie pack you should upgrade to. You can download and use this script from TechNet as o

SQL cannot log on to the SQL console= = = Problem description A domain-joined SQL production server, login repeatedly failed to view the error message after the prompt "in the SQL

master; exec sp_detach_db @dbname = ' TestDB '; exec sp_attach_single_file_db @dbname = ' TestDB ', @physname = ' D:\Program Files\Microsoft SQL Server\mssql10. Sql2008\mssql\data\testdb.mdf ' Second , empty the log This command is supported in SQL Server 2005 and 2000,

Tags: run backup file management clears CTI Trunc set DBCC SQL2008 's shrink log due to SQL2008 's optimization of file and log management, the following statements can be run in SQL2005 but have been canceled in SQL2008: (SQL2005) Backuplog dnname withno_logGo Dump TransactionDnname withno_logGo UseDnnameDBCCShrinkfile (2) Go -------------------------------------------------------------- (SQL2008): In the

Over time, you will find that the log files for the database will be up to 20G or more, and you will need the following methods.--first change the recovery model of the database to SimpleALTER DATABASE [Database] SETRECOVERY Simple;GO--to reduce the log file to 1M, the logical name can be obtained by sp_helpfileDBCCShrinkfile ([Database log name],1); GO--Resettin

The transaction log (Transaction logs) is a very important but often overlooked part of the database structure. Because it is not as active as the schema in the database, few people are concerned about the transaction log. The transacti