Category Archives: SQL Server

PLEASE READ THIS BEFORE TAKING ANY ACTION. One of my database’s log file grew to 251 GB. I was not able to take its backup or detach database for the purpose of moving this database to another server. It was … Continue reading →

One of database server was running out of disk space. The culprit was the very large SQL server log files. Using following script i was able to shrink log files of all databses in a SQL server instance so creating … Continue reading →

It is very tedious to find out all Database objects (functions, stored procedures) containing a particular string. Here is the script to get it- DECLARE @Search varchar(255) SET @Search=’texttofind’ SELECT DISTINCT o.name AS Object_Name,o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o … Continue reading →

The following  Stored Procedure can help us to search for a string within all columns and rows of all tables in a Database. CREATE PROC SearchAllTables ( @SearchStr nvarchar(100) ) AS BEGIN CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630)) SET … Continue reading →