Tag Archives: Tutorial

Recover Backed-up query files in SQL Server Management Studio

Khilitchandra's Business Intelligence Blog Posted on by

Hi guys, I just want to share quickly very handy tip regarding your SQL query sessions. When you open SQL queries in SSMS, you generally go on and work in newly opened pane/window but sometimes dont save that work. SSMS by default saves them in the event of pre-mature closure or crash of SSMS or PC restart etc. You can find your SQL queries from following lcoation. C:\Users\<UserName>\Documents\SQL Server Management Studio\Backup Files\Solution1 FYI, I have found my queries here: P.S. I am using Windows Server 2008 Operating System. This path could vary based on the Operating System. You can figure … Continue reading →

Important Fact: Default Logging in SSIS which store log entries in SQL Server

Khilitchandra's Business Intelligence Blog Posted on by

Hi all, Few days back I have posted an article on “Default Logging in SSIS“. You can refer that here. In that article I have forgotten to mention a behavior of “enabling a default logging in SSIS package“. Let me show you what you need to know about this fact. Fact: When you enable a “Default Logging” with SQL Server in SSIS package, it does not create any table (i.e. dbo.sysssislog) or stored proc (i.e. dbo.sp_ssis_addlogentry) at the same time of setting-up in SSIS package. But when you run your package first time, these objects gets created automatically.

Continue reading →