Blog

Search results for: SQL Developer

SQL SERVER: T-SQL to find out when database was restored

29-Oct-2012

SQL SERVER: T-SQL to find out when database was restored

Recently, we have found that our testing database has been restored on the server and we lost our recent work. We have to identify that at what time the database has been restored, so we can know that what are the changes need to be restored again on the database

15-Mar-2010

SQL SERVER: Execute Stored Procedure when SQL SERVER is started

We have a requirements to execute Stored Procedure when SQL SERVER is started/restarted and we need to start some processes. I found that SQL SERVER provides a way to call Stored Procedure when SQL services are restarted.

SQL SERVER: How to Read Excel file by TSQL

23-Dec-2009

SQL SERVER: How to Read Excel file by TSQL

Many times developers asked that, they want to import data from Excel file.

28-Dec-2009

SQL SERVER: How to remove cursor

Many times developer ask me that How can they remove Cursor?