Joseph, A full backup does not trunctate the transaction log.  A full backup only backs up enough of the transaction log to provide a consistent database during a restore.  In...

We did so many things over the weekend, I'm not sure if we did that or not.  I'll give it a try and see what happens.

Just in case it doesn't...

Start with this and let me know how it works:

--declare @trainreqs table (

create table dbo.trainreqs (

    client      char(50),

    typecode    char(10),

    grp         int,

    hrs         int

);

insert into dbo.trainreqs values ('CLI1', 'type1', 1,...

The quick way: script out your foreign keys, drop them, truncate the tables, reload the data, replace the foreign keys.

More detail would help.  Can you post the tables DDL along with some sample data and results?

Thanks

I don't see how you can eliminate the index scan (assuming you are indexing on the Comment field) unless you create a computed column based on the first three characters...

If you are doing a complete refresh of the data you need to complete the drop and add in the following order:

Starting with the lowest child table, start deleting records...

Have you checked the error logs to see if the there is a problem while SQL Server Agent is starting?  The only time I have seen Agent XP's disabled is...

You can turn this option off when using the SQL Server Scripts Wizard.  You start it by selecting Generate Scripts when right clicking on a database in Object Explorer.

You can also eliminate your cursor to build you column list using the following code:

declare @columns varchar(5000)

SET @columns = ''

SELECT @columns = @columns + [name] + ', ' FROM syscolumns

WHERE...

You might want to post your code for the UDF dbo.fnNoTime() as I doubt Best will figure out how to write it.

Take this and run with it.  You may need to tweak it to meet your needs but it is as close as i can get it for you.

set nocount on

DECLARE...

No.  The trigger would wait for the stored procedure to complete.  It is no asyncronous.  If the stored procedure fails, the trigger fails and everything has to roll back. Remember...

If that was the case, how would this forum help him?

My System Table Map doesn't show anything for DTS, but the agent tables are in msdb.  A quick search of BOL will tell what tables you need to look at.