clean database log.

dump transaction GeminiExperiments with no_log

dbcc checkdb(GeminiExperiments)

search object in DB

Select * From sysobjects Where name like '%objectname%'

search for column in DB

SELECT b.TABLE_NAME AS TableName, a.COLUMN_NAME

FROM (SELECT TABLE_NAME, COLUMN_NAME

FROM INFORMATION_SCHEMA.COLUMNS) AS a INNER JOIN

(SELECT TABLE_NAME, TABLE_TYPE

FROM INFORMATION_SCHEMA.TABLES

WHERE (TABLE_TYPE = 'base table')) AS b ON a.TABLE_NAME = b.TABLE_NAME

WHERE (a.COLUMN_NAME = 'ColumnSearched')

send query from email from database

EXEC msdb.dbo.sp_send_dbmail

@recipients='maia.eliozashvili@vancleef.com',

@subject = 'SQL Mail Test',

@body_format = 'html', --text or html

@body = 'body1' ,

@query = 'use vcadata

select

itemno

from itemmaster

where

year(createdate)=year(getdate()) and month(createdate)=month(getdate())',

@attach_query_result_as_file = 0

--@query_attachment_filename ='Results.txt'

http://msdn.microsoft.com/en-us/library/ms190307.aspx