I was too, but I am fully patched. I assmue it does that as well.

Thank you Julie, I was missing something key to all this.

Good to know for sure, however I would be concerned with what would happen if I had to restart replication for any reason from scratch then. racosta have you done...

Is the file device large and is it local. Also exactly what point does the freeze occur what actions did you take, just opening restore, if so then most likely...

The only issue with that is it will create a high CPU utilization than does connection to a SQL Server and doing a WAITFOR (even to the local server, works...

Sorry you missed the quote item. I was referring to using CONVERT in the other presented solution.

However do look at my other post jsut before yours.

What error is it giving and however are you creating your backups?

Not really and I do suggest getting rid of outdated entries. However is this from a file device or Tape device? Tapes are slow because it actually reads the backupsets...

Yes, there are tools on the internet and some simple code at Planet-Source-Code to do this sorrt of thing. Note however some do it by changing the SP to garbage...

Please do not cross post. As most users use the Active thread option you generally will be seen with one post. See/Leave responses in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=107882

I have not seen any other tool as you need. The biggest problem with tools like Access and the reason they perform so badly is the way they read the...

You can always have more tables in the other database as it will not effect that. However I am not sure you can have the extra columns on the replicated...

However you do have to create a variable and put in thet position with the word OUTPUT behind it to return you the value.

declare @x int

exec sp_trace_setstatus @x OUTPUT, 1

select...

I have not seen a way to prevent these and no option to do so. Might could have an external app parse and remove after the DTS package runs but...

Also keep in mind his variable for Num_Source which can be null run one query, not null do the other.

set rowcount 1

UPDATE a with (rowlock)

SET a.ckd_out_to = @tnSalesPoint, @NewAssign =...