Thank you all for the input. I am looking into the article and also have been reviewing the SP to see what may be causing the problem.

I appreciate all the...

Ian Scarlett (3/18/2011)

---

Are you trying to run the query against the default SQL instance on the server?

You aren't specifying the -S parameter to OSQL. From BOL:-

If no server is specified,...

Yes.

Currently I am able to replicate the issue on my local machine as well.

The BATCH file is sitting in a shared directory (with proper security for the client to...

Outstanding! And thanks. I think that this should get me through.

This board always gets me through when I have issues.

Ok, I got it. I needed to do 2 calls to the server, but also had to set the first call of the form: master.sys.sp_addlinkedServer 'speedy' since the odbc connection...

Lowell, thank you for the quick reply, but the issue is in trying to get the remote server linked either through the SP or permanently. I have 4 remote locations...

Jeffrey Williams-493691 (4/28/2010)

---

How did you move the logins to the new server?

If you just created them manually, or ran a script that created them - then you probably have orphaned...

Thanks all, I found the script that works, it is from MS and is called: sp_help_revlogins and can be found at: http://support.microsoft.com/kb/918992

This script really worked nicely. Thanks to...

If I got all of your excellent comments, the final code should be something like this:

use master

ALTER DATABASE JDE_CRP

set RECOVERY SIMPLE

declare @i as int

declare @FromUser sysname

declare @ToUser sysname

declare @ToSt...

Gotcha, thanks to all for the help.

This will work, that is the command I was looking for.

Since the database must be in full recovery mode for our backup software to work, is there a way to...

YES!!! YOU ROCK!! This is exactly what i was looking for!!

 

Thank you so very much!

I guess what...

that's what I thought it would do, but was not sure.

Thanks!!

Thanks for the input Peter.

All updates need to be live and near real time. I would consider replication techniques via MSSQL but the client is using the MSDE2K database and...