sql server replication:
msSQL2000 sp4
Win2003 server
ERROR:
[Microsoft][ODBC SQL Server Driver]Syntax error or access violation
when I run this SP.
{CALL sp_tmp_rn_tp (260, 340, 1, 4, NULL, NULL,
{ts '2006-07-03 00:00:00.000'},
{ts '2006-08-13 00:00:00.000'},
{ts '2006-06-17 11:00:00.000'},
{ts '2006-06-17 15:00:00.000'},
''+{fn CHAR(0)}+'',
''+{fn CHAR(0)}+'',
''+{fn CHAR(0)}+'',
''+{fn CHAR(0)}+'',
''+{fn CHAR(0)}+'',
'1',
''+{fn CHAR(0)}+'',
NULL)}
The statement is from the Distribution database (sp_browsereplcmds) and ment
for a subdcriber (mssql2005)
But I got the same error localy when I create a test table and a test SP and
run it
what is wrong here?
Table look like this:
CREATE TABLE tmp_rn_tp (
[DBOWNER_ID] [T_NUM_ID] NOT NULL ,
[CUSTOMER_ID] [T_NUM_ID] NOT NULL ,
[PRODUCT_ID] [T_NUM_ID] NOT NULL ,
[TIMEPLACE_ID] [T_NUM_ID] NOT NULL ,
[CUS_DBOWNER_ID] [T_NUM_ID] NULL ,
[CUS_CUSTOMER_ID] [T_NUM_ID] NULL ,
[FROM_DATE] [T_DATE] NULL ,
[TO_DATE] [T_DATE] NULL ,
[FROM_TIME] [T_TIME] NULL ,
[TO_TIME] [T_TIME] NULL ,
[MONDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
[TUESDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
[WEDENSDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
[THURSDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
[FRIDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
[SATURDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
[SUNDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
[NAME] [T_NAME] NULL
) ON [PRIMARY]
what does the proc sp_tmp_rn_tp look like? -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "Roger Nygård" <roger@askit.no> wrote in message
news:129d0ql20fr0k37@corp.supernews.com...
> msSQL2000 sp4
> Win2003 server
>
> ERROR:
> [Microsoft][ODBC SQL Server Driver]Syntax error or access violation
>
> when I run this SP.
>
>
> {CALL sp_tmp_rn_tp (260, 340, 1, 4, NULL, NULL,
> {ts '2006-07-03 00:00:00.000'},
> {ts '2006-08-13 00:00:00.000'},
> {ts '2006-06-17 11:00:00.000'},
> {ts '2006-06-17 15:00:00.000'},
> ''+{fn CHAR(0)}+'',
> ''+{fn CHAR(0)}+'',
> ''+{fn CHAR(0)}+'',
> ''+{fn CHAR(0)}+'',
> ''+{fn CHAR(0)}+'',
> '1',
> ''+{fn CHAR(0)}+'',
> NULL)}
>
> The statement is from the Distribution database (sp_browsereplcmds) and
> ment for a subdcriber (mssql2005)
>
> But I got the same error localy when I create a test table and a test SP
> and run it
>
> what is wrong here?
>
>
>
> Table look like this:
> CREATE TABLE tmp_rn_tp (
> [DBOWNER_ID] [T_NUM_ID] NOT NULL ,
> [CUSTOMER_ID] [T_NUM_ID] NOT NULL ,
> [PRODUCT_ID] [T_NUM_ID] NOT NULL ,
> [TIMEPLACE_ID] [T_NUM_ID] NOT NULL ,
> [CUS_DBOWNER_ID] [T_NUM_ID] NULL ,
> [CUS_CUSTOMER_ID] [T_NUM_ID] NULL ,
> [FROM_DATE] [T_DATE] NULL ,
> [TO_DATE] [T_DATE] NULL ,
> [FROM_TIME] [T_TIME] NULL ,
> [TO_TIME] [T_TIME] NULL ,
> [MONDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
> [TUESDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
> [WEDENSDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
> [THURSDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
> [FRIDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
> [SATURDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
> [SUNDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
> [NAME] [T_NAME] NULL
> ) ON [PRIMARY]
>
>
>
>
SP look like this: create procedure "sp_tmp_rn_tp" @c1 numeric(10,0), @c2 numeric(10,0), @c3 numeric(10,0), @c4 numeric(10,0), @c5 numeric(10,0), @c6 numeric(10,0), @c7 datetime, @c8 datetime, @c9 datetime, @c10 datetime, @c11 char(1), @c12 char(1), @c13 char(1), @c14 char(1), @c15 char(1), @c16 char(1), @c17 char(1), @c18 char(60) as begin insert into "dbo"."tmp_rn_tp"( "DBOWNER_ID" ,"CUSTOMER_ID" ,"PRODUCT_ID" ,"TIMEPLACE_ID" ,"CUS_DBOWNER_ID" ,"CUS_CUSTOMER_ID" ,"FROM_DATE" ,"TO_DATE" ,"FROM_TIME" ,"TO_TIME" ,"MONDAY" ,"TUESDAY" ,"WEDENSDAY" ,"THURSDAY" ,"FRIDAY" ,"SATURDAY" ,"SUNDAY" ,"NAME" ) values ( @c1 ,@c2 ,@c3 ,@c4 ,@c5 ,@c6 ,@c7 ,@c8 ,@c9 ,@c10 ,@c11 ,@c12 ,@c13 ,@c14 ,@c15 ,@c16 ,@c17 ,@c18 ) end GO [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:eynnBM5kGHA.4816@TK2MSFTNGP05.phx.gbl... > what does the proc sp_tmp_rn_tp look like? > > -- > Hilary Cotter > Director of Text Mining and Database Strategy > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. > > This posting is my own and doesn't necessarily represent RelevantNoise's > positions, strategies or opinions. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "Roger Nygård" <roger@askit.no> wrote in message > news:129d0ql20fr0k37@corp.supernews.com... >> msSQL2000 sp4 >> Win2003 server >> >> ERROR: >> [Microsoft][ODBC SQL Server Driver]Syntax error or access violation >> >> when I run this SP. >> >> >> {CALL sp_tmp_rn_tp (260, 340, 1, 4, NULL, NULL, >> {ts '2006-07-03 00:00:00.000'}, >> {ts '2006-08-13 00:00:00.000'}, >> {ts '2006-06-17 11:00:00.000'}, >> {ts '2006-06-17 15:00:00.000'}, >> ''+{fn CHAR(0)}+'', >> ''+{fn CHAR(0)}+'', >> ''+{fn CHAR(0)}+'', >> ''+{fn CHAR(0)}+'', >> ''+{fn CHAR(0)}+'', >> '1', >> ''+{fn CHAR(0)}+'', >> NULL)} >> >> The statement is from the Distribution database (sp_browsereplcmds) and >> ment for a subdcriber (mssql2005) >> >> But I got the same error localy when I create a test table and a test SP >> and run it >> >> what is wrong here? >> >> >> >> Table look like this: >> CREATE TABLE tmp_rn_tp ( >> [DBOWNER_ID] [T_NUM_ID] NOT NULL , >> [CUSTOMER_ID] [T_NUM_ID] NOT NULL , >> [PRODUCT_ID] [T_NUM_ID] NOT NULL , >> [TIMEPLACE_ID] [T_NUM_ID] NOT NULL , >> [CUS_DBOWNER_ID] [T_NUM_ID] NULL , >> [CUS_CUSTOMER_ID] [T_NUM_ID] NULL , >> [FROM_DATE] [T_DATE] NULL , >> [TO_DATE] [T_DATE] NULL , >> [FROM_TIME] [T_TIME] NULL , >> [TO_TIME] [T_TIME] NULL , >> [MONDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL , >> [TUESDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL , >> [WEDENSDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL , >> [THURSDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL , >> [FRIDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL , >> [SATURDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL , >> [SUNDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL , >> [NAME] [T_NAME] NULL >> ) ON [PRIMARY] >> >> >> >> > >
Don't see what you're looking for? Try a search.
|
