Is this safe. or can it cause any problems.
The reson I ask is because I see the following error "[DBNetlinb]
connectioncheckfordata" when I execute (from query analyser or osql)
Insert Into temptable select ... from [databasesource].source ...
both databases running on the same server
I have an number of insert to temptable and only one of them fails. But if I
use a top it works.
Insert Into temptable select top 1000... from [databasesource].source ...
And another thing I have tested it before the upgrade from sp3 to sp4 and
everything work fine.
Any clue.
Thank
LasseServer
I have just restored a database from SP3 to SP4. Works fime for me.
"Server Applications" <NoSpam@.dk.dk> wrote in message
news:O5zPA3e5FHA.1464@.tk2msftngp13.phx.gbl...
> Is this safe. or can it cause any problems.
> The reson I ask is because I see the following error "[DBNetlinb]
> connectioncheckfordata" when I execute (from query analyser or osql)
> Insert Into temptable select ... from [databasesource].source ...
> both databases running on the same server
> I have an number of insert to temptable and only one of them fails. But if
> I
> use a top it works.
> Insert Into temptable select top 1000... from [databasesource].source ...
> And another thing I have tested it before the upgrade from sp3 to sp4 and
> everything work fine.
> Any clue.
> Thank
> Lasse
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment