Monthly Archives: July 2015

Avoid Next Line character in SSMS results

Many a time we copy data from SQL Server Management Studio results pane into Excel while preparing reports and analyzing the data. One of the most common problem is handling Next Line characters. These characters disrupts the indentation of data … Continue reading

Posted in Productivity, SQL Server, SSMS | Tagged , , , , | Leave a comment

SQL Trigger to find who updated a table and when it was done

I had a situation to find who is updating a table and when the table is getting updated but it was very difficult to enable trace for a long time. I end up creating a trigger to capture the user … Continue reading

Posted in Productivity, Script, SQL, SQL Query | Tagged , , , | Leave a comment