Thanks Greg.

Your 8:05 transaction backup will have transactions from after 6:05.  If you need to restore to 6:30.  Restore your db from the last db backup (in this case before 6:05). ...

I think Steve's reply is accurate.  I would guess that there is a job running somewhere that has a "truncate log" statement in it.  Sometimes people will fill up the...

Thanks to everyone for your input!  Basically, it appears that the answer is:

You can't do it through supported means.  That's fine, just so that I know.

Thanks again -

apf

Thanks for help folks!  I knew there must be some easy way to do it!

apf

Folks!

I appreciate your responses!

swjohnson - I want to convert already existing data to Spanish. The only utility that I have found is one that converts the data in Excel...

This solution is tailored to the exact situation that you described, the key move is the 'ignore_dup_key' on the index: create table MergedTable (Orig_DB char(1), Data1 int, Data2...

What are you to do if you have a record that looks like this: 1,5000,XYZ and another that looks like: 2,5000,UVW ? Would you populate Data2...

Yes, I'm sure. As a matter of fact the DDL for one table was generated from the other (obviously, I tried to simplify the situation). The column in...

The transaction log doesn't just hold the data manipulation statement (I'm not sure actually if it does at all). Among other things, it contains a before and after image...

I just wanted to point out to Robb that your solution would only work if the char field were completely filled, which doesn't often happen in the real world. ...

Hello Michelle! I am also on SQL2K (SP3). My main experience is with Sybase (which is...

Michelle's solution doesn't work if field1 is defined as char(6). It will work if it is defined as varchar(5) or varchar(6) or ... - apf

Great! I'm looking forward to it!

apf

Thanks a lot for your input folks. That was a very good article on the PHP site that was referenced. I'm a little concerned that it was written...