Im lucky to be able to avoid this, working on SQL2K only. You might try submitting this to MS at sqlwish@microsoft.com.

Andy

A simpler method if you can take the db out of production for a few minutes is to detach it from the 7.0 server, copy it to the SQL2K server,...

Try formatting it in your select as a varchar/string, either leave it as a string or convert it back to a number having only the # of decimal places you...

Hey Jon,

I dont think I'd call this ludicrous. Unusual maybe! Typically I'd look to solve any problem with a set based solution first, then move to a cursor as a...

I'll have to confess to running a much looser ship than you guys - our two junior developers send changes to me to apply after having tested on their server,...

Merge replication would work, as would transactional with immediate updating/queued updating subscibers. Both are suitable for doing data changes on both publisher and subscriber, merge probably offers more options (conflict...

Take a look at this article I posted a few months ago - might do the job!

http://www.sqlservercentral.com/columnists/awarren/20010425205439_1.asp

Andy

I never use it, so didnt even think to check. For those interested, you can see details about this at the following:

http://support.microsoft.com/support/kb/articles/Q195/2/22.ASP

Andy

Take a look at DateDiff and DateAdd in TSQL help.

Andy

Hey Colby,

Sorry we havent gotten to your question yet, give us a day or so to catch up.

Andy

Might still be permissions - maybe the agent account doesnt have access to the mdb? You might try setting up a linked server, then using that in your package. A...

Hey Bill - Im not familiar with this, but we'll see if can find someone who is! Give us a day or so to check.

Andy

I dont see why not. BCP is a command line app, so you just need to build the entire string of bcp.exe plus all the parameters you need, then execute...

Thanks for the follow up! Sorry we didnt get you an answer this time, but please keep us in mind for next time.

Andy

Looks like its a bug - take a look at this article:

http://support.microsoft.com/support/kb/articles/Q304/7/06.ASP

Gives explanation and a couple options, one of which is to use Sp_adjustpublisheridentityrange.

Andy