From what I'm gathering here, you're database went down prior to your 2:00 backup running and the last backup that you have is the 1:45 backup.  You can only recover...

Nested cursors on large tables, awesome!!  If speed is your concern, scrap the cursors.  I agree with Peter, post your code and work towards creating a SET-based solution. 

They do look good, but I still think it is extremely important to capture the execution plan using profiler. 

Everyone's favorite answer....it depends.  Roger has given you some very useful info here, but much of what you are after depends on what you are trying to accomplish.  You say...

Dave,

You mention that you believe that your index strategy is sound, but nowhere throughout this thread do I see that you’ve verified that your execution plan...

Roger beat me to this, but here's my answer too.  I'm in agreement with Roger, but I will add that the trace flags in SQL Server 2000 do work!

There’s...

What happens if you set the job owner to 'sa'?

I would recommend that you become an expert in T-SQL.  While you can spend as much time as you want on the front-end coding, you will want as much of...

Nimesh,

This is usually due to permissions.  When you execute the package manually, it will run under the context of the user account that you are logged in as.  When...

Why does this need to be dynamic SQL?  I don't see anything in your code that would require dynamic SQL to accomplish.

I'm not sure if this is much more efficient and there is probably a better method to this madness, but here's an example of code that will produce the same...

When I run your code with your sample data, I do not get the results that you show here.  Here's what I get, can you clarify?

CallID      UCID       GroupID    

----------- ----------...

Just curious, but what advantages are you trying to get by running this as a script over a stored procedure?

It would help if you could show an example of how the new column's data should look.  Can you take your sample data and show how the data for the...

Here it is with the PATINDEX used also:

DECLARE @string varchar(100)

SET @string = '12345 Test Address Dr.'

SELECT LEFT(@String,CHARINDEX(' ', @string)),

    LEFT(@string,PATINDEX('%[^0-9]%',@string))