General network error.

Receiving error:
"General network error. Check your network documentation. [SQLSTATE 08S01]
(Error 11)".
Running on SQLServer 2000 EE, SP3, Windows 2000 Adv.
This started after we rebuild the server. We have tens of jobs that run at
night. This error is happening only randomly as some days nothing happens
and same job runs fine but other day it blows up. It is not happening with
same job either. Then we restart the job and it runs fine.This error message is generated from ODBC, and not really
from SQL Server. It is generated when a connection
something the ODBC fails ie DB2 (see Microsoft) so
although SQL Server is reporting it, it is not the cause.
I would sugest that you go through the Event View on your
NT, or put in a trace to see exactly where it fails.
J
>--Original Message--
>Receiving error:
>"General network error. Check your network documentation.
[SQLSTATE 08S01]
>(Error 11)".
>Running on SQLServer 2000 EE, SP3, Windows 2000 Adv.
>This started after we rebuild the server. We have tens
of jobs that run at
>night. This error is happening only randomly as some
days nothing happens
>and same job runs fine but other day it blows up. It is
not happening with
>same job either. Then we restart the job and it runs
fine.
>
>.
>|||Nothing in the event log or SQLServer log accept that error message.
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:1302301c4433d$9f6096f0$a101280a@.phx.gbl...
> This error message is generated from ODBC, and not really
> from SQL Server. It is generated when a connection
> something the ODBC fails ie DB2 (see Microsoft) so
> although SQL Server is reporting it, it is not the cause.
> I would sugest that you go through the Event View on your
> NT, or put in a trace to see exactly where it fails.
> J
>
> >--Original Message--
> >Receiving error:
> >"General network error. Check your network documentation.
> [SQLSTATE 08S01]
> >(Error 11)".
> >
> >Running on SQLServer 2000 EE, SP3, Windows 2000 Adv.
> >
> >This started after we rebuild the server. We have tens
> of jobs that run at
> >night. This error is happening only randomly as some
> days nothing happens
> >and same job runs fine but other day it blows up. It is
> not happening with
> >same job either. Then we restart the job and it runs
> fine.
> >
> >
> >
> >.
> >|||Hi ilovesql,
We are expiriencing the same issue - I was woundering if you had this resolved.
I also wanted to ask you - when you rebuild the server did it have the same configuration as before or you installed SP3 for SQL Server?
We went from Win2000 server SQL server 2000 SP2 to WIN2003 server SP3 and we started to have this problem from that day on. Microsoft is working on it but this is the second day and they haven't came up with the solution.
I think it is SP3 - something is not right with it.
Thanks,
Anna
"ilovesql" wrote:
> Nothing in the event log or SQLServer log accept that error message.
>
> "Julie" <anonymous@.discussions.microsoft.com> wrote in message
> news:1302301c4433d$9f6096f0$a101280a@.phx.gbl...
> > This error message is generated from ODBC, and not really
> > from SQL Server. It is generated when a connection
> > something the ODBC fails ie DB2 (see Microsoft) so
> > although SQL Server is reporting it, it is not the cause.
> > I would sugest that you go through the Event View on your
> > NT, or put in a trace to see exactly where it fails.
> >
> > J
> >
> >
> > >--Original Message--
> > >Receiving error:
> > >"General network error. Check your network documentation.
> > [SQLSTATE 08S01]
> > >(Error 11)".
> > >
> > >Running on SQLServer 2000 EE, SP3, Windows 2000 Adv.
> > >
> > >This started after we rebuild the server. We have tens
> > of jobs that run at
> > >night. This error is happening only randomly as some
> > days nothing happens
> > >and same job runs fine but other day it blows up. It is
> > not happening with
> > >same job either. Then we restart the job and it runs
> > fine.
> > >
> > >
> > >
> > >.
> > >
>
>

General Network Error on subscriber

I am trying to replicate over a dial-up connection a database between
a server running Sql Server 2000 on Windows 2000 server and two SQL
server 2000 personal edition on Windows XP pro.
For one site, the replication worked correclty. For the other one, the
replication process starts, but when trying to connect to the
subscriber (i.e Windows XP pro), after waiting 5 minutes the following
error message is displayed:
Merge Process could not retreive generation information at the
subscriber.
General Network error source <windows xp database> (data source) error
number 11.
Replication tries again automatically and same error is displayed.
All suggestions are welcome.
Best Regards
Patrick
Use the slow link profile for this problem subscribe. Right click on the
agent (expand replication monitor, replication agents, merge agents, locate
your agent), select agent profiles, select the slow link profile, accept
defaults and restart it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Patrick" <pmenage@.intnet.mu> wrote in message
news:4b9f6ca1.0411250208.6f22429a@.posting.google.c om...
>I am trying to replicate over a dial-up connection a database between
> a server running Sql Server 2000 on Windows 2000 server and two SQL
> server 2000 personal edition on Windows XP pro.
> For one site, the replication worked correclty. For the other one, the
> replication process starts, but when trying to connect to the
> subscriber (i.e Windows XP pro), after waiting 5 minutes the following
> error message is displayed:
> Merge Process could not retreive generation information at the
> subscriber.
> General Network error source <windows xp database> (data source) error
> number 11.
> Replication tries again automatically and same error is displayed.
> All suggestions are welcome.
> Best Regards
> Patrick
|||I just found the solution. When I entered my user name in the dial-up
connection box I entered it with the remote machine name eg: PC1\User1.
But when I checked the user in the "add user to operating system" module
in Windows XP, the machine name was dropped, only the user name
appeared. So when connecting, I entered only the user name, and
everything worked fine.
Thank you for your support.
Best Regards
Patrick
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

General Network Error / SQL Server does not exist

Hi world,
I get the General Network Error (and sometimes the SqlServer does not
exist).
I used to get this issue for the past few months. What I used to do is
restart SQL Server (from the system tray) one or two times and it used
to continue working. I never cared.
Now one of our customers is complaining the same issue! :-)
Googling about i heard people offering "setting named pipes as the
default". I went to the Sql Server Client Network Utility program and
couldn't find any such option in the "DB-Library Options" tab to change
this default setting.
Or is the above solution for some other problem.
Thanks a lot..
Regards,
MichelleHave you tried setting up an alias to your sql server using tcp/ip?
Please post your os/sql environment as well as your clients
nivek
<mich_stone@.yahoo.com> wrote in message
news:1109590304.342547.188290@.f14g2000cwb.googlegroups.com...
> Hi world,
> I get the General Network Error (and sometimes the SqlServer does not
> exist).
> I used to get this issue for the past few months. What I used to do is
> restart SQL Server (from the system tray) one or two times and it used
> to continue working. I never cared.
> Now one of our customers is complaining the same issue! :-)
> Googling about i heard people offering "setting named pipes as the
> default". I went to the Sql Server Client Network Utility program and
> couldn't find any such option in the "DB-Library Options" tab to change
> this default setting.
> Or is the above solution for some other problem.
> Thanks a lot..
> Regards,
> Michelle
>|||Thanks for the reply. Here is some more info on my problem
OS : Windows XP
Application: On ASP.NET
Sql Server: Developer Edition (also tried with MSDE)
The application always looks at "localhost"
I have "NAMED PIPES" and "TCPIP" in the GENERAL tab selected in the
network client utility. Clicking Properties on NAMED PIPES gives
"Network Protocal Default Value Setup = sql\query". Clicking properties
on TCPIP gives "1433".
I have two aliases defined to two OTHER servers on the internet. I am
just mentioning that for completeness, as those two servers have got
nothing to do with the one having the problem.
DB Library Options File Name = "c:\windows\system32\ntwdlib.dll"
Hope this is enough information for someone to help me out.
Thanks and regards
Michelle
nivek wrote:
> Have you tried setting up an alias to your sql server using tcp/ip?
> Please post your os/sql environment as well as your clients
> nivek
> <mich_stone@.yahoo.com> wrote in message
> news:1109590304.342547.188290@.f14g2000cwb.googlegroups.com...
> > Hi world,
> >
> > I get the General Network Error (and sometimes the SqlServer does
not
> > exist).
> >
> > I used to get this issue for the past few months. What I used to do
is
> > restart SQL Server (from the system tray) one or two times and it
used
> > to continue working. I never cared.
> >
> > Now one of our customers is complaining the same issue! :-)
> >
> > Googling about i heard people offering "setting named pipes as the
> > default". I went to the Sql Server Client Network Utility program
and
> > couldn't find any such option in the "DB-Library Options" tab to
change
> > this default setting.
> >
> > Or is the above solution for some other problem.
> >
> > Thanks a lot..
> >
> > Regards,
> >
> > Michelle
> >

General Network Error / SQL Server does not exist

Hi world,
I get the General Network Error (and sometimes the SqlServer does not
exist).
I used to get this issue for the past few months. What I used to do is
restart SQL Server (from the system tray) one or two times and it used
to continue working. I never cared.
Now one of our customers is complaining the same issue! :-)
Googling about i heard people offering "setting named pipes as the
default". I went to the Sql Server Client Network Utility program and
couldn't find any such option in the "DB-Library Options" tab to change
this default setting.
Or is the above solution for some other problem.
Thanks a lot..
Regards,
Michelle
Have you tried setting up an alias to your sql server using tcp/ip?
Please post your os/sql environment as well as your clients
nivek
<mich_stone@.yahoo.com> wrote in message
news:1109590304.342547.188290@.f14g2000cwb.googlegr oups.com...
> Hi world,
> I get the General Network Error (and sometimes the SqlServer does not
> exist).
> I used to get this issue for the past few months. What I used to do is
> restart SQL Server (from the system tray) one or two times and it used
> to continue working. I never cared.
> Now one of our customers is complaining the same issue! :-)
> Googling about i heard people offering "setting named pipes as the
> default". I went to the Sql Server Client Network Utility program and
> couldn't find any such option in the "DB-Library Options" tab to change
> this default setting.
> Or is the above solution for some other problem.
> Thanks a lot..
> Regards,
> Michelle
>
|||Thanks for the reply. Here is some more info on my problem
OS : Windows XP
Application: On ASP.NET
Sql Server: Developer Edition (also tried with MSDE)
The application always looks at "localhost"
I have "NAMED PIPES" and "TCPIP" in the GENERAL tab selected in the
network client utility. Clicking Properties on NAMED PIPES gives
"Network Protocal Default Value Setup = sql\query". Clicking properties
on TCPIP gives "1433".
I have two aliases defined to two OTHER servers on the internet. I am
just mentioning that for completeness, as those two servers have got
nothing to do with the one having the problem.
DB Library Options File Name = "c:\windows\system32\ntwdlib.dll"
Hope this is enough information for someone to help me out.
Thanks and regards
Michelle
nivek wrote:[vbcol=seagreen]
> Have you tried setting up an alias to your sql server using tcp/ip?
> Please post your os/sql environment as well as your clients
> nivek
> <mich_stone@.yahoo.com> wrote in message
> news:1109590304.342547.188290@.f14g2000cwb.googlegr oups.com...
not[vbcol=seagreen]
is[vbcol=seagreen]
used[vbcol=seagreen]
and[vbcol=seagreen]
change[vbcol=seagreen]

General Network Error / SQL Server does not exist

Hi world,
I get the General Network Error (and sometimes the SqlServer does not
exist).
I used to get this issue for the past few months. What I used to do is
restart SQL Server (from the system tray) one or two times and it used
to continue working. I never cared.
Now one of our customers is complaining the same issue! :-)
Googling about i heard people offering "setting named pipes as the
default". I went to the Sql Server Client Network Utility program and
couldn't find any such option in the "DB-Library Options" tab to change
this default setting.
Or is the above solution for some other problem.
Thanks a lot..
Regards,
MichelleHave you tried setting up an alias to your sql server using tcp/ip?
Please post your os/sql environment as well as your clients
nivek
<mich_stone@.yahoo.com> wrote in message
news:1109590304.342547.188290@.f14g2000cwb.googlegroups.com...
> Hi world,
> I get the General Network Error (and sometimes the SqlServer does not
> exist).
> I used to get this issue for the past few months. What I used to do is
> restart SQL Server (from the system tray) one or two times and it used
> to continue working. I never cared.
> Now one of our customers is complaining the same issue! :-)
> Googling about i heard people offering "setting named pipes as the
> default". I went to the Sql Server Client Network Utility program and
> couldn't find any such option in the "DB-Library Options" tab to change
> this default setting.
> Or is the above solution for some other problem.
> Thanks a lot..
> Regards,
> Michelle
>|||Thanks for the reply. Here is some more info on my problem
OS : Windows XP
Application: On ASP.NET
Sql Server: Developer Edition (also tried with MSDE)
The application always looks at "localhost"
I have "NAMED PIPES" and "TCPIP" in the GENERAL tab selected in the
network client utility. Clicking Properties on NAMED PIPES gives
"Network Protocal Default Value Setup = sql\query". Clicking properties
on TCPIP gives "1433".
I have two aliases defined to two OTHER servers on the internet. I am
just mentioning that for completeness, as those two servers have got
nothing to do with the one having the problem.
DB Library Options File Name = "c:\windows\system32\ntwdlib.dll"
Hope this is enough information for someone to help me out.
Thanks and regards
Michelle
nivek wrote:[vbcol=seagreen]
> Have you tried setting up an alias to your sql server using tcp/ip?
> Please post your os/sql environment as well as your clients
> nivek
> <mich_stone@.yahoo.com> wrote in message
> news:1109590304.342547.188290@.f14g2000cwb.googlegroups.com...
not[vbcol=seagreen]
is[vbcol=seagreen]
used[vbcol=seagreen]
and[vbcol=seagreen]
change[vbcol=seagreen]

Functions in SQL Server7

Is it possible to create Functions in SqlServer 7?
I have a huge query > 500,000 rows that I want to select a subset of using a
function
Select IdentityInd, ColA, ColB
From TableA Where
UDFContains(IdentityInd, ColB ) = 1
**************************************
--Function
And UDFContains will looklike
UDFContains(@.IdentityInd, @.ColB )
Returns Bit
Begin
IF EXISTS(Select IdentityInd From TableA Where
IdentityInd = @.IdentityInd AND CONTAINS(ColA,
@.ColB)) BEGIN
Return 1
End
ELSE BEGIN
Retuen 0
End
End
****************************************
******Just in SQL Server 2000 for now.
AMB
"Sanjay Pais" wrote:

> Is it possible to create Functions in SqlServer 7?
> I have a huge query > 500,000 rows that I want to select a subset of using
a
> function
> Select IdentityInd, ColA, ColB
> From TableA Where
> UDFContains(IdentityInd, ColB ) = 1
> **************************************
> --Function
> And UDFContains will looklike
> UDFContains(@.IdentityInd, @.ColB )
> Returns Bit
> Begin
> IF EXISTS(Select IdentityInd From TableA Where
> IdentityInd = @.IdentityInd AND CONTAINS(ColA,
> @.ColB)) BEGIN
> Return 1
> End
> ELSE BEGIN
> Retuen 0
> End
> End
> ****************************************
******
>
>|||No, but you can do this in the where clause:
Select IdentityInd, ColA, ColB
From TableA
Where EXISTS( Select inExists.IdentityInd
From TableA as inExists
Where IdentityInd = tableA.IdentityInd
AND CONTAINS(inExists.ColA, tableA.ColB))
Can't you? It should be preferrable performancewise anyhow, I would expect.
----
Louis Davidson - drsql@.hotmail.com
SQL Server MVP
Compass Technology Management - www.compass.net
Pro SQL Server 2000 Database Design -
http://www.apress.com/book/bookDisplay.html?bID=266
Note: Please reply to the newsgroups only unless you are interested in
consulting services. All other replies may be ignored :)
"Sanjay Pais" <spaisatnospammarketlinksolutions.com> wrote in message
news:eeK6c$UBFHA.3924@.TK2MSFTNGP10.phx.gbl...
> Is it possible to create Functions in SqlServer 7?
> I have a huge query > 500,000 rows that I want to select a subset of using
> a function
> Select IdentityInd, ColA, ColB
> From TableA Where
> UDFContains(IdentityInd, ColB ) = 1
> **************************************
> --Function
> And UDFContains will looklike
> UDFContains(@.IdentityInd, @.ColB )
> Returns Bit
> Begin
> IF EXISTS(Select IdentityInd From TableA Where
> IdentityInd = @.IdentityInd AND CONTAINS(ColA,
> @.ColB)) BEGIN
> Return 1
> End
> ELSE BEGIN
> Retuen 0
> End
> End
> ****************************************
******
>|||You can't use two columns in a contains clause which caused my dilema in the
first place :)
Sanjay
"Louis Davidson" <dr_dontspamme_sql@.hotmail.com> wrote in message
news:ul5SFhWBFHA.4004@.tk2msftngp13.phx.gbl...
> No, but you can do this in the where clause:
> Select IdentityInd, ColA, ColB
> From TableA
> Where EXISTS( Select inExists.IdentityInd
> From TableA as inExists
> Where IdentityInd = tableA.IdentityInd
> AND CONTAINS(inExists.ColA, tableA.ColB))
> Can't you? It should be preferrable performancewise anyhow, I would
> expect.
> --
> ----
--
> Louis Davidson - drsql@.hotmail.com
> SQL Server MVP
> Compass Technology Management - www.compass.net
> Pro SQL Server 2000 Database Design -
> http://www.apress.com/book/bookDisplay.html?bID=266
> Note: Please reply to the newsgroups only unless you are interested in
> consulting services. All other replies may be ignored :)
> "Sanjay Pais" <spaisatnospammarketlinksolutions.com> wrote in message
> news:eeK6c$UBFHA.3924@.TK2MSFTNGP10.phx.gbl...
>|||Ah, sorry :)
----
Louis Davidson - drsql@.hotmail.com
SQL Server MVP
Compass Technology Management - www.compass.net
Pro SQL Server 2000 Database Design -
http://www.apress.com/book/bookDisplay.html?bID=266
Note: Please reply to the newsgroups only unless you are interested in
consulting services. All other replies may be ignored :)
"Sanjay Pais" <spaisatnospammarketlinksolutions.com> wrote in message
news:uI%23xQvWBFHA.3700@.tk2msftngp13.phx.gbl...
> You can't use two columns in a contains clause which caused my dilema in
> the first place :)
> Sanjay
> "Louis Davidson" <dr_dontspamme_sql@.hotmail.com> wrote in message
> news:ul5SFhWBFHA.4004@.tk2msftngp13.phx.gbl...
>

Function works on SQLServer but not on MSDE

I have spent considerable time trying to debug this one without
success.
I have a database which runs on my client's SQLServer 2000. It
contains a scalar-valued text function which works fine.
Using the same function definition in the same way on MSDE it returns
the wrong result. I am baffled. Is there some incompatibility I
should know about?
The function (simplified) goes like this
ALTER FUNCTION dbo.fnDoseRate
(
@.ID Int,
@.WhichDoseRate Int
)
RETURNS Float
AS
BEGIN
DECLARE @.Dose Float
IF @.WhichDoseRate=1
SELECT @.Dose = 1.2
IF @.WhichDoseRate=2
SELECT @.Dose = 2.3
IF @.WhichDoseRate=3
SELECT @.Dose = 3.4
RETURN @.Dose
END
I call it from a query
SELECT X, Y, dbo.fnDoseRate(1,1), dbo.fnDoseRate(1,2),
dbo.fnDoseRate(2,3) FROM MyTable
and the query delivers the expected results
If I change the query to
SELECT X, Y, SUM(dbo.fnDoseRate(1,1)), SUM(dbo.fnDoseRate(1,2)),
SUM(dbo.fnDoseRate(2,3)) FROM MyTable GROUP BY X, Y
and the first 2 of the SUM fields return the same value (appropriate
only to 1,1). If I change the last call to 1,3 it gives the same wrong
value.
Any ideas?
Bill Manville
MVP - Microsoft Excel, Oxford, England
FWIW I should add that I created the function definition and the view
using an Access2002 ADP project.
Bill Manville
MVP - Microsoft Excel, Oxford, England
|||Are both engines at the same service pack level?
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Bill Manville" <Bill-Manville@.msn.com> wrote in message
news:VA.000013fd.3da5fb80@.msn.com...
> FWIW I should add that I created the function definition and the view
> using an Access2002 ADP project.
> Bill Manville
> MVP - Microsoft Excel, Oxford, England
>
|||>Are both engines at the same service pack level?
Good question.
The client controls the remote server so I don't readily know about
that. Is there a way I could interrogate it to find out?
Nor am I sure how to find out the service pack level of my MSDE; I'm a
bit of an amateur in this area! Can you point me in the right
direction?
Looking at SysInfo > Loaded Modules, I see
sqlserver 2000.080.0194.00
Is that the correct place to look? And is that the most recent
version? If not, where should I go to update it?
(I run Microsoft Update regularly but I guess it might not reach MSDE)
Bill Manville
MVP - Microsoft Excel, Oxford, England
|||SELECT @.@.Version
returns:
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
Ah, I'm running on XP which is reported (in this case) as NT 5.1.
It seems to me there is a Microsoft site that lists the versions and the
service packs etc. associated with each. I'm pretty sure I have SS 2005 SP2
installed here.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Bill Manville" <Bill-Manville@.msn.com> wrote in message
news:VA.000013fe.3fc7c2fb@.msn.com...
> Good question.
> The client controls the remote server so I don't readily know about
> that. Is there a way I could interrogate it to find out?
> Nor am I sure how to find out the service pack level of my MSDE; I'm a
> bit of an amateur in this area! Can you point me in the right
> direction?
> Looking at SysInfo > Loaded Modules, I see
> sqlserver 2000.080.0194.00
> Is that the correct place to look? And is that the most recent
> version? If not, where should I go to update it?
> (I run Microsoft Update regularly but I guess it might not reach MSDE)
>
> Bill Manville
> MVP - Microsoft Excel, Oxford, England
>
|||OK, so my MSDE is
Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000
00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Personal
Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
and my client's server is
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005
23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard
Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
I guess that indicates my MSDE is a bit out of date.
Now to find out how to get it updated...
Bill Manville
MVP - Microsoft Excel, Oxford,
|||Ah, it's looks like it--perhaps dangerously so. It might still be prone to
the network attacks the pre SP2 versions faced years ago.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Bill Manville" <Bill-Manville@.msn.com> wrote in message
news:VA.000013ff.412751a3@.msn.com...
> OK, so my MSDE is
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
> Aug 6 2000
> 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Personal
> Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
>
> and my client's server is
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
> May 3 2005
> 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard
> Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
>
> I guess that indicates my MSDE is a bit out of date.
> Now to find out how to get it updated...
> Bill Manville
> MVP - Microsoft Excel, Oxford,
>

Function sequence error - Merge Replication

We are replicating from 7 publishers to 1 subscriber all running MS SQL
Server 2000 SP3 using Merge Replication.
We are in the process of upgrading our application and due to that we had to
make
some changes to the database schema like add some columns, create a few new
tables, and triggers. We did all this through a script using stored
procedures on 2 of the publisher databases and then ran the snapshot agent.
That's when we started seeing the error.
Error Message: The process could not bulk copy out of table '[dbo].[Invoice]'.
Error details: Function sequence error
(Source: ODBC SQL Server Driver (ODBC); Error number: 0)
------
Does anyone know how to resolve this?
Do we need to do anything on the subscriber database because of the schema
change done on the publisher database ?
Thanks in advance,
I wish I could tell you how to solve this one. The good news is that it
seems to be transient.
Hilary Cotter
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
"Vikram" <Vikram@.discussions.microsoft.com> wrote in message
news:E1A11B74-CE85-4C1B-87F5-248919A882CE@.microsoft.com...
> We are replicating from 7 publishers to 1 subscriber all running MS SQL
> Server 2000 SP3 using Merge Replication.
> We are in the process of upgrading our application and due to that we had
to
> make
> some changes to the database schema like add some columns, create a few
new
> tables, and triggers. We did all this through a script using stored
> procedures on 2 of the publisher databases and then ran the snapshot
agent.
> That's when we started seeing the error.
> Error Message: The process could not bulk copy out of table
'[dbo].[Invoice]'.
> Error details: Function sequence error
> (Source: ODBC SQL Server Driver (ODBC); Error number: 0)
> ----
--
> Does anyone know how to resolve this?
> Do we need to do anything on the subscriber database because of the schema
> change done on the publisher database ?
>
> Thanks in advance,
>

FullText Search SQLserver2005 using VS2005 Server Explorer

Hello,

I am using SQLServer Express and Visual Studio 2005 to create the website. I would like to implement FullText search, but have never done it before. I have looked at the msdn documentation on FullText search in SQLServer 2005 herehttp://msdn2.microsoft.com/en-us/library/ms142519.aspx.

I cannot seem to figure out how to use a FT search using Visual Studio. Can someone please help me configure my database and then explain how I can run queries based on user input to return data?

Hi KJAK,

KJAK:

I am using SQLServer Express and Visual Studio 2005 to create the website.

In the SQL Express Edition, you have to do some more work the in the other SQL editions.

KJAK:

I cannot seem to figure out how to use a FT search using Visual Studio.

Use the Sql Server Management Studio Express. Open the Template Explorer, select the Full-text folder and select theCreate Full-text Index template. Fill in the needed information and run it. Then select theCreate Full-text Catalog template and do the same.

BTW. Sql-BOL is your friend

|||

What I have now figured out is that I will not be able to implement FULL-TEXT search on this particular site. I am using a shared hosting provider and they do not provide me access via the Sql Server Management Studio Express because they do not permit remote connections. I have some documentation that may help me get around this issue to configure the database, but since the database is provided by the host, it may not work.

I have marked your reply as answered as a way to thank you for your help and will keep this post in mind when I am working with dedicated server websites.

Thanks for your reply!
KJAK

|||

KJAK:

I have some documentation that may help me get around this issue to configure the database, but since the database is provided by the host, it may not work.

Is your DataBase transmitted to the ISP sql server, or its a dynamically attached DataBase in your App_Data folder?

In the second case, AFAIK Full-text search wount works, because you need access to the Fulltext-Catalog directory to populate your index.

|||

The database is located on the hosts network. They provide a client that I connect to in which I can define tables, stored procedures, schema's, et cetera. It does not provide me access to the catalogs and is limited in what I can do all together. I have not yet spoken to the host to see if they can explain how to do it or whether I can do it or not.

|||

KJAK:

It does not provide me access to the catalogs and is limited in what I can do all together.

You may change to a ISP they will give you a dedicated SQL server. Or live with this restrictions

fulltext search in sql express 2005

I had problem when change database from sqlserver 2000 to sql express 2005.

The fulltext index does not create automatically.

Example:

i use sqldatasource to insert new name to my table.

and then i find it by query like this : select count(*) from mytable where contains(mycol,'newname')

the result is 0

but if i run query to start full index : exec sp_fulltext_catalog 'myfulltext','start_full' and run query

select count(*) from mytable where contains(mycol,'newname')

again. The result is 1.

So i alway run exec sp_fulltext_catalog 'myfulltext','start_full' after insert or update, delete to create fulltext index. When i use sql server 2000 , i didn't need do that, it automatic.

Pls help me !!! how to make fulltext index create auto in sql express 2005 .

You need to set "Change Tracking" to automatic.

The index update will not be instantaneous, but it will be automatic.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=680500&SiteID=1

http://technet.microsoft.com/en-us/library/ms187317.aspx