SqlServer Begin's

After many force restarts my laptop the MSDB database decided to that it was time and   let the owner know of the harassment and didn’t want come back up.   The error log read as following An error occurred during recovery, preventing the database 'msdb' (database ID 4) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.   Solution Following is a step by step guide to bring the database back online     1.        Put MSSQL into single user mode 1.        Click START ; Microsoft SQL Server 2005 Configuration Tools ; SQL Server Configuration Manager 2.        Right click on SQL Server and choose Properties 3.        Click on the Advanced tab. Under Startup Parameters you will be adding the following parameters to the beginning of the string: -m;-c;-T3608   2.        Restart SQL Server 3.        Connect to SQL server th

Back Drop                 Being a rookie at SSIS  I managed to complete my first SSIS package for a client. The package included loading data from EXCEL data and CSV   files to SQL server and subsequently loading to the datamart. Problem                 After deploying the package at the client environment the initial runs worked seamlessly but when the larger files were tested the a validation error stated to pop out. This was utterly confusing and for few hours I dint realize what the error message said in   plain text. Note   The current message is last of the validation errors and there was another ballistic message that appeared before this. The error message Executed as user: Microsoft (R) SQL Server Execute Package Utility   Version 10.50.1600.1 for 32-bit   Copyright (C) Microsoft Corporation 2010. All rights reserved.     Started:   1:28:45 p.m.   Error: 2012-10-05 13:29:38.05      Code: 0xC0202009      Source: Import XLSX Files Excel Source [570]