I keep getting this error - "invalid object name - msmerge_tombstone" when i
try to import data into a table. i'm trying to replace the old data with the
new. it gives this error when it tries to delete the old.
replication used to be enabled on this server but i disabled it and then
took it completely off. is there some switch that got missed?
any help would be greatly appreciated.
sql server 7, nt4,I have continued to try to import data with no luck. i re-enable replication
on this server but did not set up any publications. now i am getting the
error "invalid object name sysmergearticles" when i try to import to this
table. again the error is when it tries to delete the table.|||Barb,
Where you ever able to resolve this issue. It is happening to me now
and I cannot find a solution.
Craig
Barb Swafford wrote:
> *I keep getting this error - "invalid object name -
> msmerge_tombstone" when i
> try to import data into a table. i'm trying to replace the old data
> with the
> new. it gives this error when it tries to delete the old.
> replication used to be enabled on this server but i disabled it and
> then
> took it completely off. is there some switch that got missed?
> any help would be greatly appreciated.
> sql server 7, nt4, *
sohospec
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message291036.html
Showing posts with label import. Show all posts
Showing posts with label import. Show all posts
Friday, March 23, 2012
Friday, February 24, 2012
Intersolv ODBC Driver
Help me!
I try to import some data from an informix 5.0 table to Sql Server 2000 with
a DTS package.
I use Intersolv ODBC driver version 03.011.0021 to connect to the database.
It works well, but i can't define a parameter in the sql statement. For
example if a try to execute :
select *
from table
where field = ?
The dts environment give me an "unspecified syntax error...."
Where is the problem?
The driver don't support parameters or these must be defined with another
syntax?
Bye
DanieleCan you post a code snippet?
SQL Server T-SQL doesn't support anything close to that syntax so I'm not
sure what you're doing exactly...
From T-SQL, you would need to build dynamic SQL or use sp_exectutesql to do
the parameterization you're talking about.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Nonno Oreste" <dffdfd@.dfd.dfd> wrote in message
news:OSsw2unuDHA.1596@.TK2MSFTNGP10.phx.gbl...
with
database.
I try to import some data from an informix 5.0 table to Sql Server 2000 with
a DTS package.
I use Intersolv ODBC driver version 03.011.0021 to connect to the database.
It works well, but i can't define a parameter in the sql statement. For
example if a try to execute :
select *
from table
where field = ?
The dts environment give me an "unspecified syntax error...."
Where is the problem?
The driver don't support parameters or these must be defined with another
syntax?
Bye
DanieleCan you post a code snippet?
SQL Server T-SQL doesn't support anything close to that syntax so I'm not
sure what you're doing exactly...
From T-SQL, you would need to build dynamic SQL or use sp_exectutesql to do
the parameterization you're talking about.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Nonno Oreste" <dffdfd@.dfd.dfd> wrote in message
news:OSsw2unuDHA.1596@.TK2MSFTNGP10.phx.gbl...
quote:
> Help me!
> I try to import some data from an informix 5.0 table to Sql Server 2000
with
quote:
> a DTS package.
> I use Intersolv ODBC driver version 03.011.0021 to connect to the
database.
quote:
> It works well, but i can't define a parameter in the sql statement. For
> example if a try to execute :
> select *
> from table
> where field = ?
> The dts environment give me an "unspecified syntax error...."
> Where is the problem?
> The driver don't support parameters or these must be defined with another
> syntax?
> Bye
> Daniele
>
Subscribe to:
Posts (Atom)