You might want to look at the WMI event watcher task, this allows you to write WQL queries to watch for events. Example you can watch for an event happening which...

Looks like the source has read your first 100 lines and determined they all match the dt_DbtimeStamp so they should import dirctly to a sql table of datetime. Do yhe...

on your oledb source for db2 if you right click select the advanced editor go to input output colums, What is the external data type for the colums and what...

Right click your OleDb Source Select advanced editor. Got to tab Input and output Propeties, You will see external column and output column Any difference in these two coulumn sizes...

The DT_Date or The DT_time  data types in SSIS Do not have a corresponding data type in SQL ( I believe they may have these Data types in SQL in...

Still looking into this error, does anyone use service broker if so have you run a trace on broker events, do you get this error? 

Forgot to mention setting to emergency can sometimes get you access to data.

update master..sysdatabases SET status = 512 where name = 'mydbname'

shoul update to set database to offline. their are other status you can update to set to not recovered for example....

Look in your windows eventlogs for application and system errors relating to the MSSQL service. This contains the clue to why it is not resarting.

I have recently done this and it worked ok had some problems but was due to the install source

explained at the end of this thread http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=269173

I had to rebuild...

You marked your delete stament transaction and restored up to the point before the mark so ID 12 will be recovered i.e you restored up until the point before the...

Of course, Monday mornings..

I have foun the solution. msi location is cached in the registry. Explained below.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=949298&SiteID=1

Hi i am using the above stated method to try and reinstall to correct server collation. the setup runs Ok up to chosen to upgrade and i continue. the problem is i then...

Thanks for the article cant wait for the next instalment. One thing that has confused me over the years is how sql stores and organises text data. You do not...