Here's a nice one !!!

[CInman]

Is it possible to truncate a transaction log without using SQL Enterprise Manager and/or SQL Query Analyser? In other words, transaction log is full and needs truncating, but SQL Server tools not usable ... is there any other way to do it? (eg. via MS-Access or something?)

Any thoughts would be brilliant ...

 

[RickCole]

A few quick thoughts

The OSQL utility.

From within a DTS pacakage.

TSQL within a stored procedure which in turn can be called from Access or many other 3 party software prodcuts.

Rick.