Create a linked server, then you can just use the four part syntax - server.db.owner.table to do the insert. You can use openquery to do the same thing on a...

I actually fix it as part of my backup:

For Each mDatabase In mSQLServer.Databases

if instr(strExcludeList, ucase(mDatabase.Name)) = 0 then

Set...

Check the account that the job is running under, may not have access.

Andy

Why not disable a processor to see if that is really the problem or not? I would be surprised if is, but easy to rule it out by testing.

Andy

Take a look at Index Server. It's not SQL, but it is an OLEDB data source that you can query against using sort of SQL syntax. I think Jon Winer...

You'll need to spend some time experimenting with DTS - it supports any ODBC or OLEDB data source, so you should have no problem connecting to Oracle (well, in theory...

If you're doing it real time, why not look at replication? In SQL2K you can do some pretty advanced transforms of the data as it moves? I find that the...

Its a property of the TCP config - you can turn it off there. Also via DMO. Here is an excerpt from BOL for SQL2K:

"When you install an instance of...

It does change each time. I just reset it.

Andy

Please post your solution, others would like to know too!

Andy

Try reinstalling the client tools. Upgrading to SP3 might work as well.

Andy

Always a good idea to do your reporting from a separate server if you can. Transactional replication is a great solution, low latency and low overhead. Not only do you...

Yes you can do it using sp_start_job. But you honestly can't live with a one min or greater delay moving stuff into a warehouse?

Andy

I ran this:

declare @ierr int

declare @vtcmd varchar(1000)

set @vtcmd='C:\PROGRAM FILES\TMS\Dialer List Utility\DLU.EXE /USER:username /PASS:password'

EXEC @iErr = master..xp_cmdshell @vtCmd

print @ierr

And got this:

'C:\PROGRAM' is not recognized as an internal or external command,

operable program...

Interesting - thanks for the follow up!

Andy