Multi Column FTS (2005) Query

Hi
I am trying to get my query syntax to work given a typical query I expect to
passed into my FTS procedure.
The typical search string could be Italy investment. The FTS must search
for Italy filtering by investment.
With an FTS index on CountryName and Item (item is where the word investment
resides)
Some t-sql like this would do the trick:
SELECT CountryName, ItemName
FROM SearchView
WHERE CONTAINS(*, 'italy AND investment')
Given that a single textbox is displayed to allow users to type their search
criteria, how would one seperate such a query so that country names were
searched against the CountryName FTS column and other (non country names)
searched against the FTS Item column?
Should I have several queries to determine if countries exist? If so, then
apply those country names in the AND of the WHERE clause, then how would I
then parse to remove the country names from the intial query string so that
the remaining words can be searched against the FTS Item column?
To add to the delimea, I'm using the FORMSOF(THESAURUS...) functionality, so
a user can query investment Europe (getting countries in the thesaurus file
matching Europe)
Craig
Unfortunately what you would have to do is the following
select *From SearchView where contains(CountryName, 'Italy') and
contains(ItenName,'investment')
This would offer the best performance, you could also do the following
select * from SearchView where CountryName='Italy' and
contains(ItenName,'investment')
unfortunately you will have to parse the search string to see which
countries are present in it, and then build your query accordingly.
Hilary

> To add to the delimea, I'm using the FORMSOF(THESAURUS...)
functionality, so
> a user can query investment Europe (getting countries in the
thesaurus file
> matching Europe)
> Craig
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

MSSQLServerADHelper

Hi
I am getting the following error (given at the end) in the event log and the
MSSQLServerADHelper service does not start. What can I do?
Thanks
Regards
Event Type: Error
Event Source: MSSQLServerADHelper
Event Category: None
Event ID: 100
Date: 09/07/2004
Time: 18:41:36
User: N/A
Computer: MYSERVER
Description:
'0' is an invalid number of start up parameters. This service takes two
start up parameters.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
This also comes up.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 09/07/2004
Time: 19:15:36
User: N/A
Computer: MYSERVER
Description:
The MSSQLServerADHelper service terminated with service-specific error
3221225572 (0xC0000064).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"John" <john@.nospam.infovis.co.uk> wrote in message
news:ei8G85dZEHA.3092@.tk2msftngp13.phx.gbl...
> Hi
> I am getting the following error (given at the end) in the event log and
the
> MSSQLServerADHelper service does not start. What can I do?
> Thanks
> Regards
>
> Event Type: Error
> Event Source: MSSQLServerADHelper
> Event Category: None
> Event ID: 100
> Date: 09/07/2004
> Time: 18:41:36
> User: N/A
> Computer: MYSERVER
> Description:
> '0' is an invalid number of start up parameters. This service takes two
> start up parameters.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>

MSSQLServerADHelper

Hi
I am getting the following error (given at the end) in the event log and the
MSSQLServerADHelper service does not start. What can I do?
Thanks
Regards
Event Type: Error
Event Source: MSSQLServerADHelper
Event Category: None
Event ID: 100
Date: 09/07/2004
Time: 18:41:36
User: N/A
Computer: MYSERVER
Description:
'0' is an invalid number of start up parameters. This service takes two
start up parameters.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.This also comes up.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 09/07/2004
Time: 19:15:36
User: N/A
Computer: MYSERVER
Description:
The MSSQLServerADHelper service terminated with service-specific error
3221225572 (0xC0000064).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"John" <john@.nospam.infovis.co.uk> wrote in message
news:ei8G85dZEHA.3092@.tk2msftngp13.phx.gbl...
> Hi
> I am getting the following error (given at the end) in the event log and
the
> MSSQLServerADHelper service does not start. What can I do?
> Thanks
> Regards
>
> Event Type: Error
> Event Source: MSSQLServerADHelper
> Event Category: None
> Event ID: 100
> Date: 09/07/2004
> Time: 18:41:36
> User: N/A
> Computer: MYSERVER
> Description:
> '0' is an invalid number of start up parameters. This service takes two
> start up parameters.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>

MSSQLSERVER service terminated unexpectedly

HI
I have server MSDE 2000 SP3
frequently server stopped, and print in log file information:
1)
17310 :
SqlDumpExceptionHandler: Process 1984 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2)
17311 :
SQL Server is aborting. Fatal exception c0000005 caught.
3)
The MSSQLSERVER service terminated unexpectedly.
If you didn't find anything in KB on this and you are on the current service pack: Open a case with MS
Support. Exceptions etc are most often bugs in SQL Server, so you will probably need a fix or workaround from
MS for this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bies" <ANTYSPAMbies22@.poczta.onet.pl> wrote in message news:ca1ij7$dd6$1@.atlantis.news.tpi.pl...
> HI
> I have server MSDE 2000 SP3
> frequently server stopped, and print in log file information:
> 1)
> 17310 :
> SqlDumpExceptionHandler: Process 1984 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> 2)
> 17311 :
> SQL Server is aborting. Fatal exception c0000005 caught.
> 3)
> The MSSQLSERVER service terminated unexpectedly.
>

MSSQLSERVER service terminated unexpectedly

HI
I have server MSDE 2000 SP3
frequently server stopped, and print in log file information:

1)
17310 :
SqlDumpExceptionHandler: Process 1984 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

2)
17311 :
SQL Server is aborting. Fatal exception c0000005 caught.

3)
The MSSQLSERVER service terminated unexpectedly.Hi

This may be as in:

http://support.microsoft.com/defaul...kb;en-us;814572

other possibilities
http://search.microsoft.com/search/...ql+server&na=54

You may also want to check if a anti-virus software is affecting it.

John

"Bies" <ANTYSPAMbies22@.poczta.onet.pl> wrote in message
news:ca1ie6$6gh$1@.nemesis.news.tpi.pl...
> HI
> I have server MSDE 2000 SP3
> frequently server stopped, and print in log file information:
> 1)
> 17310 :
> SqlDumpExceptionHandler: Process 1984 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> 2)
> 17311 :
> SQL Server is aborting. Fatal exception c0000005 caught.
> 3)
> The MSSQLSERVER service terminated unexpectedly.|||> This may be as in:
> http://support.microsoft.com/defaul...kb;en-us;814572
> other possibilities
http://search.microsoft.com/search/...ql+server&na=54
> You may also want to check if a anti-virus software is affecting it.

thx

MSSQLSERVER service terminated unexpectedly

HI
I have server MSDE 2000 SP3
frequently server stopped, and print in log file information:
1)
17310 :
SqlDumpExceptionHandler: Process 1984 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2)
17311 :
SQL Server is aborting. Fatal exception c0000005 caught.
3)
The MSSQLSERVER service terminated unexpectedly.If you didn't find anything in KB on this and you are on the current service
pack: Open a case with MS
Support. Exceptions etc are most often bugs in SQL Server, so you will proba
bly need a fix or workaround from
MS for this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bies" <ANTYSPAMbies22@.poczta.onet.pl> wrote in message news:ca1ij7$dd6$1@.atlantis.news.tpi.
pl...
> HI
> I have server MSDE 2000 SP3
> frequently server stopped, and print in log file information:
> 1)
> 17310 :
> SqlDumpExceptionHandler: Process 1984 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> 2)
> 17311 :
> SQL Server is aborting. Fatal exception c0000005 caught.
> 3)
> The MSSQLSERVER service terminated unexpectedly.
>

MSSQLServer

Hi
I have created a ghost of a system running SQL server 7 (on windows 2000 server).
When I try and start MSSQLServer I get the message:
Your SQL Server installation is either corrupt ot has been tampered with (unknown package id).
Any ideas on how I can fix this without rerunning setup.
Thanks
Conor
Re-run setup. See http://www.karaszi.com/SQLServer/inf...erver_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Conor" <anonymous@.discussions.microsoft.com> wrote in message
news:479704EB-01A0-4AF2-BCB0-5D699ECD2ABA@.microsoft.com...
> Hi
> I have created a ghost of a system running SQL server 7 (on windows 2000 server).
> When I try and start MSSQLServer I get the message:
> Your SQL Server installation is either corrupt ot has been tampered with (unknown package id).
> Any ideas on how I can fix this without rerunning setup.
> Thanks
> Conor
|||This is correct. SQL Server 7.0 does not support ghosted installations.
Rand
This posting is provided "as is" with no warranties and confers no rights.

MSSQLServer

Hi
I have created a ghost of a system running SQL server 7 (on Windows 2000 ser
ver).
When I try and start MSSQLServer I get the message:
Your SQL Server installation is either corrupt ot has been tampered with (un
known package id).
Any ideas on how I can fix this without rerunning setup.
Thanks
ConorRe-run setup. See l]
Tibor Karaszi, SQL Server MVP
[url]http://www.karaszi.com/sqlserver/default.asp" target="_blank">http://www.karaszi.com/SQLServer/in...ver/default.asp
http://www.solidqualitylearning.com/
"Conor" <anonymous@.discussions.microsoft.com> wrote in message
news:479704EB-01A0-4AF2-BCB0-5D699ECD2ABA@.microsoft.com...
> Hi
> I have created a ghost of a system running SQL server 7 (on Windows 2000 s
erver).
> When I try and start MSSQLServer I get the message:
> Your SQL Server installation is either corrupt ot has been tampered with (
unknown package id).
> Any ideas on how I can fix this without rerunning setup.
> Thanks
> Conor|||This is correct. SQL Server 7.0 does not support ghosted installations.
Rand
This posting is provided "as is" with no warranties and confers no rights.

MSSQLOLAP Service stuck in a loop

Hi
I had installed the SP3a patch for Analysis Services.
Everything was working fine for a day and then now when I
try restarting the MSSQLOLAPService it gets into a loop
and automatically gets restarted again and again.
I am not very sure whether this is because of the SP3a
installation.
I have encountered the same on a few other desktops
running windows xp and a server running win 2000 advanced
server.
Any clue of where have I gone wrong?
Any sort of help would be appreciated!!
thanx in advance,
Lakshman.
On Mon, 12 Apr 2004 15:05:20 -0700, "Lakshman"
<babulaksh@.rediffmail.com> wrote:

>Hi
>I had installed the SP3a patch for Analysis Services.
>Everything was working fine for a day and then now when I
>try restarting the MSSQLOLAPService it gets into a loop
>and automatically gets restarted again and again.
>I am not very sure whether this is because of the SP3a
>installation.
I remember this happening to me and I wish I could be sure but I seem
to remember that it had something to do with the service pack.
Possibly a mismatch between the machine that had AS and another
machine that was hitting it...

>I have encountered the same on a few other desktops
>running windows xp and a server running win 2000 advanced
>server.
>Any clue of where have I gone wrong?
>Any sort of help would be appreciated!!
>thanx in advance,
>Lakshman.

MSSQLOLAP Service stuck in a loop

Hi
I had installed the SP3a patch for Analysis Services.
Everything was working fine for a day and then now when I
try restarting the MSSQLOLAPService it gets into a loop
and automatically gets restarted again and again.
I am not very sure whether this is because of the SP3a
installation.
I have encountered the same on a few other desktops
running Windows XP and a server running win 2000 advanced
server.
Any clue of where have I gone wrong?
Any sort of help would be appreciated!!
thanx in advance,
Lakshman.On Mon, 12 Apr 2004 15:05:20 -0700, "Lakshman"
<babulaksh@.rediffmail.com> wrote:

>Hi
>I had installed the SP3a patch for Analysis Services.
>Everything was working fine for a day and then now when I
>try restarting the MSSQLOLAPService it gets into a loop
>and automatically gets restarted again and again.
>I am not very sure whether this is because of the SP3a
>installation.
I remember this happening to me and I wish I could be sure but I seem
to remember that it had something to do with the service pack.
Possibly a mismatch between the machine that had AS and another
machine that was hitting it...

>I have encountered the same on a few other desktops
>running Windows XP and a server running win 2000 advanced
>server.
>Any clue of where have I gone wrong?
>Any sort of help would be appreciated!!
>thanx in advance,
>Lakshman.

mssql2000

Hi
I am changing my server from mssq7 to sql2000
Do i need to upgrade my mssql7 databse to 2000.
or only i want to just attach db to 2000 server.
thanks.
Thanks
You can attach a 7 database to 2000. Another option is backup and restore. Just make sure you test
your applications...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"shif" <ns_0001@.hotmail.com> wrote in message
news:214DE35F-B234-4519-8754-E7D14B317A91@.microsoft.com...
> Hi
> I am changing my server from mssq7 to sql2000
> Do i need to upgrade my mssql7 databse to 2000.
> or only i want to just attach db to 2000 server.
> thanks.
> --
> Thanks

mssql2000

Hi
I am changing my server from mssq7 to sql2000
Do i need to upgrade my mssql7 databse to 2000.
or only i want to just attach db to 2000 server.
thanks.
--
ThanksYou can attach a 7 database to 2000. Another option is backup and restore. J
ust make sure you test
your applications...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"shif" <ns_0001@.hotmail.com> wrote in message
news:214DE35F-B234-4519-8754-E7D14B317A91@.microsoft.com...
> Hi
> I am changing my server from mssq7 to sql2000
> Do i need to upgrade my mssql7 databse to 2000.
> or only i want to just attach db to 2000 server.
> thanks.
> --
> Thanks

mssql wont find NULL values in datetime field?

Hi

I have a really simple query which i can't figure out why its not working. I have a table called 'ADMIN' which has a datetime field called 'date_edited'. Because the majority of records have never been edited, i have allowed null values and they are filled with 'NULL' in each record. How ever, when i try:

SELECT * FROM ADMIN WHERE date_edited = NULL

I get no records, but i can see and know i have hundreds! I know i'm doing somthing really stupid, but for life of me can't figure it out! :eek:

thanksignore me, found the answer

SELECT * FROM ADMIN WHERE date_edited is NULL|||Consider yourself ignored. ;)|||I'm ignoring him right now. Intensely.|||please dun treat newbies like that, we all started off as a newbie right?

maybe we shall have a newbie section for them to post elementary questions...

but seriously, this NULL question does look dumb......TS shall try harder before posting it......|||personally I still hate nulls and three part logic. It causes problems for so many programmers. I slap as many not null constraints in my software as I can. Of course I spend so much time fighting fires these days, I only get to do reactive development or redevelopment.|||ROTFL ... look at Sean's title in the above post ... i almost missed that.

Another contradictory Seanism :p|||Declare @.ZenosParadox varchar(50)
Set @.ZenosParadox = 'This value is null'|||I learned in math class that zeno's paradox was that you could never reach any destination because you first had to travel 1/2 the distance, then 1/2 again, then again, so you'd never reach it.

poor zeno didn't know an infinite series can sum to a finite number.|||http://en.wikipedia.org/wiki/Liar_paradox ?

:)|||NULL value is good, I dun need to be bothered about putting constraint while showing them on a report hehe...