How to find trace or log information in sql server ?

For tracking the database for any incidents like droping any objects and event monitoring.

Starting the Trace
EXEC SP_Configure ‘default trace enabled’,1
RECONFIGURE

Stopping the Trace
EXEC SP_configure ‘default trace enabled’,1
RECONFIGURE

To find the trace information for any sql server table

select * from sys.traces where id =1

How to find trace or log information in sql server ? was last modified: October 14th, 2017 by Justin Antony

Query to search for particular column from sql database

Search particular column sql database

You can search for a particular column that present in the list of database tables in sql server.

SELECT
SCHEMA_NAME(SCHEMA_ID) + '.' + TBL.NAME AS TableName,
COL.NAME AS ColumnName
FROM SYS.TABLES AS TBL
INNER JOIN SYS.COLUMNS COL
ON TBL.OBJECT_ID = COL.OBJECT_ID
WHERE COL.NAME LIKE '%ENTER COLUMN NAME%'
ORDER BY 1

 

 

Query to search for particular column from sql database was last modified: October 10th, 2017 by Justin Antony

How to create a simple report ?

simple SSRS report
New -> Project -> Report Server Project -> Right click on Shared DataSet -> Add New Data Source
Right click on Report Folder -> Add New Item
In the Report Data Tool Bar -> Right Click on the Data Sources -> Select the shared Data Source which we created already
Right Click on the Data Set -> Add DataSet -> Define your query here
Drag and Drop a table
Pick the Data fields from dataset and place it on the table.
Align and format the Table Accordingly
Add header to your Report.
Save and Run the Report.

How to create a simple report ? was last modified: October 1st, 2017 by Justin Antony

What is a SSIS breakpoint and how to configure it?

SSIS breakpoint
To troubleshoot an SSIS Package we use the breakpoints.
Right click on any task in control flow and then select Edit Breakpoint, This will display a Breakpoint window. choose when the execution to be paused(OnPreExecute, OnPostExecute, OnError events). This will be helpful to see the values of a variable at runtime using the output window.

What is a SSIS breakpoint and how to configure it? was last modified: October 1st, 2017 by Justin Antony