Shrink transaction Log using linked server 3 part naming

Many times transaction log space gets full on SQL servers. To truncate transaction log we can use below script:

 DECLARE @Query NVARCHAR(1000)
 SET @Query = N'DBCC SHRINKFILE(2,0,''TRUNCATEONLY'')'
 EXEC YourServerName.YourDBName.dbo.sp_executesql
 @statement = @Query

DBCC is database console command, 2 in SHRINKFILE signifies log file.

You also like to know about:

• Do you know what happens when you hit url www.goolge.com?
• Know about Debouncing & Throttling
• AngularJS advanced trick and techniques
• Restrict input to allow only required value (jQuery plugin for input type validation)
• Spread operator or Rest parameter or Ellipsis in JavaScript
• Why call and apply two methods available in JavaScript
• Automatic Form Input Validation for complete site
• Number of ways you can create function in JavaScript +what are they called
• JavaScript Native objects
• How to Create private function in JavaScript
• functions as first class object in JavaScript
• Object Oriented concept in JavaScript
• Advanced JavaScript questions
• One good way to declare Global Variables in JavaScript
• how to align elements in a row with equal space around
• Closures in JavaScript
• AJAX call in AngularJS for cross domain service using JSONP
• Cross Site Scripting in WCF Web Service. How to use AJAX in JavaScript to Get/Consume JSON from WCF in C#
• How to add AngularJS in rails application
• Git configuration all about
• Pass XML file in stored procedure as a input parameter from C#
• XML Parser in SQL Server (T-SQL), How to parse XML in SQL
• Wish your friend with your own words and love
• Create Message in Hindi by typing in Hinglish
• Convert Multiline Text Into Single Line for HTML page