I believe it should write to system log because it is a service...

Check status of SSIS in SQL CONFIGURATION MANAGER when it says stopped.

You can use the following to check...

No clue but read the following article...

http://support.microsoft.com/kb/306397/EN-US/

Try granting the CREATE CERTIFICATE permission...

As everybody say... cursors are not goo... but when there is not option you end up using it...

If you are getting the same execution for while loop and cursor you...

Check your recory model first...

If it is FULL/BULK_LOGGED then make sure you are running tlog backups every 30/60 minutes.

If it is simple then your transaction might have caused this because...

May be your function is not support for multi row updates...

Because cursor updates one row at time and with w

How many rows and what is the pysical size of the table...Are you creating clustered/non-clustered index?

You posted this in SQL 2005 forum, I think you are using sql 2005... If...

You can create linked server call to oracle and use NOT EXISTS clause in your query...

You can do this using tsql or dts...

declare @dt datetime

select @dt = max(TRANS_DATE) from...

Your jobs was processing OLAP cube...

Based the error process got cancelled.. so check if anyone killed sql query executing through olap cube or kill the process in Task Manager...

Try processing...

Cross domain trust is based on company rules and decision...

Yes it good to have but it is not required as long as you have the option to move the backups...

A transaction log backup job that is created in Database Maintenance Planner fails to execute

http://support.microsoft.com/kb/303229

BUG: Expired Transaction Log Backups May Not Be Deleted by Maintenance Plan

http://support.microsoft.com/kb/303292

If your sql 2000 files are on the SAN, you can do that but you need to remove those drives from 2000 cluster...sql 2005 cluster...

Before doing that make sure you...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp

The following features are not available...

* Availability features such as data mirroring, clustering, etc.

* Full-text search

* SQL Agent

* Reporting Services

* Business Intelligence Platform, such as...

Install SQL server on your machine and read BOOKS online...

Here is the free hands lab provided by MS..

http://msdn.microsoft.com/virtuallabs/sql/

Are you interested in development side or amdin side?

Check for few basic...

There are two type of upgrades...

1. inplace upgrade in which you will not have any option to rollback...because your db are over written with 2005...only option will be reinstall...