Follow these steps:

1) Create a new SQL Server Agent Job

2) On the job step tab, add a new job step.

3) On the General page of the new job step, choose...

Yes, I should have read your question closer. You can not go back from 2005 to 2000.  I think the approach you came up with is good.

Please post the code you are trying to run.  Here is an example where someone tried to restore a full back up and a bunch of transaction log backups with...

Yes you can do this. During the SQL Server 2005 installation, it asks you which instance to install, a new instance name or upgrade an existing instance. 

I just realized my function has a two flaws.  Try this one instead:

create FUNCTION VAL(@value varchar(100))

RETURNS decimal

AS

begin

 if @value is null return null

 declare @char char(1)

    declare @length int

    declare @newValue varchar(100)

 declare...

Almost forgot, Dale wrote a book about SQL Server Management Studio, http://www.sqlservercentral.com/store/#ssms .  It's only $8 and will get you up to speed with SSMS quickly.

If you are familiar with SQL profiler, you can set up a trace to watch the commands that SQL Server Agent sends to SQL Server.

Microsoft has a ton of free content like virtual labs and webcasts:

http://www.microsoft.com/sql/eval/webcast.mspx?wt.mc_id=SQL.AD.01059

You might also check to see if there is a SQL Server user group or PASS chapter in...

SQL Server Agent is a Windows service. So, when SQL Server Agent is started the service is turned on.  It then connects to SQL Server and looks for alerts it...

There are a couple of things that could be causing this problem. 

When you run the DTS package using EM, the package runs as the account that you are logged...

Your explanation is pretty confusing. I'm not sure what you are trying to do. After looking at the graphic of your table design, I think you have some design issues.  For...

You will find that SQL Server is pretty flexible.  For example, in SQL Server 2005 you can add your own functions using VB.Net.  While the performance won't be as good...

There are actually some other keys that the start up account needs full control that isn't documented anywhere.  

On Windows 2003, if the service account is not a member of local admins,...

I finally have the answer! One thing I didn't mention in the previous post is that they also had me add the service accounts to the local admin group.

If the service...

I spent 5 hours on the phone with MS support today.  They could tell that UDP 1434 was being "filtered" but even with all the tools couldn't tell why.  They...