Use the convert function.  Here's an example with local declarations

declare

@inputval varchar(50), --your original string value

@converted decimal(10,2)

set @inputval = '-002345'

set @converted = convert(decimal(10,2),@inputval,0)

print @converted

-2345.00

I forgot to answer the 2nd part to your question.

"Is there a way once the table in in SQL server to simply re-designated the database owner part of the...

You should import the table into sql server from sql server.  Run the DTS-Import wizard, or right-click tables and select import data.  Select Microsoft Access as your data source.

This will...

Can you test and try to insert 1 row using query analyzer to see if you get the same error on one of the previously replicated tables? 

One time when I...

How are you inserting the new data?  Through SQL Data Compare?  We also use that tool but do not drop the subscriber when inserting data into the publication and haven't...

Even without a maintenance plan you can write the job steps to an output log.

Is the subscriber registered at the publisher exactly how it is named at the subscriber?  This may require an alias be set up.

Example:

subscriber in domain B (outside) named

subscriberserver\subscriber

Registered in Domain...

In FULL recovery mode, the transaction log will not make available the space until a full backup is performed, or a transaction log backup is performed at which point the...

Repost (I don't think my previous post took)

We had a similiar problem replicating sprocs.  It seems the method the sproc is created may cause a problem.  Enterprise manager seems to...

Are you using replication, or are you creating this procedure in Enterprise Manager?

What are you trying to gain from manually incrementing the unique index?  Are you constrained by a business rules?

We also use identity column for hundreds of tables in our databases...

Was a new snapshot recently generated which included object changes? 

If so, and the snapshot is being applied then:

When subscribers are set up their either already have the schema and...

I would use merge replication in this case.  You may also want to consider starting the identity seeds for A and B differently to prevent conflicts from occuring during the merge. ...

rerun the snapshot, then resync.  By default the subscription is set to expire in 14 days.