2K Developer Edition Install

Hi, folks.

I've just reached the end of my frustration with trying to learn MSDE with no interface (in addition to simultaneously learning ASP.NET), so I'm going to install 2K Developer Edition. However, I'd like to know if it's safe install it on top of MSDE. I'm currently running XP Pro, VS.NET, IIS 5.x, so I'm afraid that if I have uninstall MSDE that I'll break a bunch things that I've painstakingly configured. ;-)

Advice?

TIA,

BobI'd detach the database(s) you've created, and tuck them away for safekeeping. Once you get the developer edition installed, reattach them (and maybe fix any SQL login/user mappings using sp_change_users_login (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ca-cz_8qzy.asp)).

-PatP|||MSDE only supports named instance, if I am not mistaken. This means that your new install will also have a named instance. If you want to live with it, - then start double-clicking on setup. Otherwise remove MSDE install completely. I wouldn't keep it even if you're trying to learn it. There's nothing to learn other than the fact that it has the highest number of limitations among all editions.

2005: using SMO

Hello,
I am learning SQL Server 2005. I would like to write a procedure
making database backup using SMO. According to my book I should write
such code:

using Microsoft.SqlServer.Management.SMO;
public static void MakeBackup()
{
Server server = new Server("localhost");
Backup backup = new Backup();
backup.Action = BackupActionType.Database;
backup.BackupSetName = "Backup copy";
backup.BackupSetDescription = "Backup copy";
backup.Database = "DemoSQLServer";
backup.Devices.AddDevice("C:\\DemoSQLServer.bak",
DeviceType.File);
backup.SqlBackup(server);
}

The code cannot be compiled because of error:
The type or namespace name 'Management' does not exist in the
namespace 'Microsoft.SqlServer'.
Please help to correct the problem - I cannot find proper name of SMO
namespace. Is the code OK?
Thank you very much
/RAM/I tried adding references to Microsoft.SqlServer.ConnectionInfo and
Microsoft.SqlServer.Smo - and I could build assembly. But then I
cannot create assembly in SQL Server:

"An exception occured while executing a Transact statement or batch
(Microsoft.SqlServer.Express.ConnectionInfo).
Assembly 'microsoft.sqlserver.smo, version=9.0.242.0, culture=neutral,
publictoken=89845dcd8080cc91.' was not found in the SQL catalog.
(Microsoft SQL Server, Error: 6503)"

Could you help me to solve it...|||R.A.M. (r_ahimsa_m@.poczta.onet.pl) writes:

Quote:

Originally Posted by

I tried adding references to Microsoft.SqlServer.ConnectionInfo and
Microsoft.SqlServer.Smo - and I could build assembly. But then I
cannot create assembly in SQL Server:
>
"An exception occured while executing a Transact statement or batch
(Microsoft.SqlServer.Express.ConnectionInfo).
Assembly 'microsoft.sqlserver.smo, version=9.0.242.0, culture=neutral,
publictoken=89845dcd8080cc91.' was not found in the SQL catalog.
(Microsoft SQL Server, Error: 6503)"
>
Could you help me to solve it...

There is a smaller set of .Net Fx assemblies that are loaded by default
in SQL Server. Apparently Microsoft.SqlServer.Smo is not one of them.
You could create an assembly in your database for the DLL with CREATE
ASSEMBLY, but I suspect that there is a reason why this DLL is not
loaded. I don't think the intention is that SMO is to be called from
within SQL Server. (But I have stayed away from SMO, so I don't really
know for sure.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

2005: creating aggregate function from .NET assembly

Hello,
I am learning SQL Server 2005. I have (correctly) written in .NET
assembly DemoSQLServer with aggregate function AvgNoMinMax in class
Demo and I have added assembly to database DemoSQLServer. Now I need
to create aggregate in SQL Server. I tried this way:

CREATE AGGREGATE AvgNoMinMax(@.v float) RETURNS float EXTERNAL NAME
[DemoSQLServer].[DemoSQLServer.Demo].[AvgNoMinMax]

Unfortunately I have error:

Incorrect syntax near '.'.

I don't know what's wrong. Please help.
Thank you very much!
/RAM/R.A.M. (r_ahimsa_m@.poczta.onet.pl) writes:

Quote:

Originally Posted by

I am learning SQL Server 2005. I have (correctly) written in .NET
assembly DemoSQLServer with aggregate function AvgNoMinMax in class
Demo and I have added assembly to database DemoSQLServer. Now I need
to create aggregate in SQL Server. I tried this way:
>
CREATE AGGREGATE AvgNoMinMax(@.v float) RETURNS float EXTERNAL NAME
[DemoSQLServer].[DemoSQLServer.Demo].[AvgNoMinMax]
>
Unfortunately I have error:
>
Incorrect syntax near '.'.

The thing to do when you get a syntax error is to look up the topic
for the command in question and study the syntax graph in detail to
find out what's wrong.

Yes, I'm telling you to read the manual. You see, you are learning SQL 2005,
and part of that is to learn the tremendous asset that Books Online actually
is. Besides, by doing mistakes and finding what mistake - that is how you
really learn things. You don't learn things by being spoon-fed in
newsgroups.

(That is not to say that asking in newsgroups is a bad idea. Sometimes
it's rather creativity you need help with, and that is not be found in
Books Online.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

2005: calling .NET procedure

Hi,
I am learning SQL Server 2005. I need to call .NET assembly procedure
from T-SQL.
Here's part of my assembly:

using System;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
namespace DemoSQLServer
{
public sealed class Demo
{
[SqlProcedure(Name="PodajKsiki")]
public static void PodajKsiki()
{
SqlCommand cmd = new SqlCommand("SELECT * FROM Ksiki");
SqlDataReader dr = cmd.ExecuteReader();
SqlContext.Pipe.Send(dr);
}
...
}
}

I have created assembly in Object Explorer (Programmability /
Assemblies).
How to call procedure? I tried:
exec DemoSQLServer.PodajKsiki
but I got a message:

Could not find stored procedure 'DemoSQLServer.PodajKsiki'.

Please help.
Thank you.
/RAM/On Mon, 10 Jul 2006 20:38:44 +0200, R.A.M. wrote:

Quote:

Originally Posted by

>Hi,
>I am learning SQL Server 2005. I need to call .NET assembly procedure
>from T-SQL.
>Here's part of my assembly:

(snip)

Quote:

Originally Posted by

>I have created assembly in Object Explorer (Programmability /
>Assemblies).

Hi RAM,

How did your CREATE ASSEMBLY statement look? Can you post it?

--
Hugo Kornelis, SQL Server MVP|||On Tue, 11 Jul 2006 00:18:29 +0200, Hugo Kornelis
<hugo@.perFact.REMOVETHIS.info.INVALIDwrote:

Quote:

Originally Posted by

>On Mon, 10 Jul 2006 20:38:44 +0200, R.A.M. wrote:
>

Quote:

Originally Posted by

>>Hi,
>>I am learning SQL Server 2005. I need to call .NET assembly procedure
>>from T-SQL.
>>Here's part of my assembly:

>(snip)

Quote:

Originally Posted by

>>I have created assembly in Object Explorer (Programmability /
>>Assemblies).

>
>Hi RAM,
>
>How did your CREATE ASSEMBLY statement look? Can you post it?

I haven't used CREATE ASSEMBLY. I simply right-clicked
Programmability/Assemblies, and chosen "New Assembly...".
Please help
/RAM/|||On Tue, 11 Jul 2006 00:18:29 +0200, Hugo Kornelis
<hugo@.perFact.REMOVETHIS.info.INVALIDwrote:

Quote:

Originally Posted by

>On Mon, 10 Jul 2006 20:38:44 +0200, R.A.M. wrote:
>

Quote:

Originally Posted by

>>Hi,
>>I am learning SQL Server 2005. I need to call .NET assembly procedure
>>from T-SQL.
>>Here's part of my assembly:

>(snip)

Quote:

Originally Posted by

>>I have created assembly in Object Explorer (Programmability /
>>Assemblies).

>
>Hi RAM,
>
>How did your CREATE ASSEMBLY statement look? Can you post it?

I scripted:

CREATE ASSEMBLY [DemoSQLServer]
AUTHORIZATION [dbo]
FROM ...
WITH PERMISSION_SET = SAFE|||On Tue, 11 Jul 2006 14:22:00 +0200, R.A.M. wrote:

Quote:

Originally Posted by

>On Tue, 11 Jul 2006 00:18:29 +0200, Hugo Kornelis
><hugo@.perFact.REMOVETHIS.info.INVALIDwrote:
>

Quote:

Originally Posted by

>>On Mon, 10 Jul 2006 20:38:44 +0200, R.A.M. wrote:
>>

Quote:

Originally Posted by

>>>Hi,
>>>I am learning SQL Server 2005. I need to call .NET assembly procedure
>>>from T-SQL.
>>>Here's part of my assembly:

>>(snip)

Quote:

Originally Posted by

>>>I have created assembly in Object Explorer (Programmability /
>>>Assemblies).

>>
>>Hi RAM,
>>
>>How did your CREATE ASSEMBLY statement look? Can you post it?

>
>I scripted:
>
>CREATE ASSEMBLY [DemoSQLServer]
>AUTHORIZATION [dbo]
>FROM ...
>WITH PERMISSION_SET = SAFE

Hi RAM,

Thanks. Unfortunately, I now realise that I forgot to ask to post the
CREATE PROCEDURE statement you used as well - my apologies.

To cut this short, I'll just post my assumption: I _think_ that yoru
CREATE PROCEDURE statement looks like this:

CREATE PROCEDURE [PodajKsiki]
AS
EXTERNAL NAME DemoSQLServer.[DemoSQLServer.Demo].[PodajKsiki]
go

If this is indeed hoow yoou created the stored procedure, then you use
the following syntax to call it:

EXEC [PodajKsiki]

(or, if you want to follow best practice and explicitly add the schema:
EXEC dbo.[PodajKsiki] - but of course, then you'd add an explicit
schema on the various CREATE statements as well).

(Note - I used copy and paste for the procedure name since some of the
characters appear to be from a character set that's not installed on my
computer - I hope the procedure name looks right to you!)

(Second note - I chose safety first and enclosed the stored procedure's
name between bracktes, since I don't know if the actual characters that
look like on my computer are valid or not in an identifier. You can
always try to use PodajKsiki instead of [PodajKsiki]).

--
Hugo Kornelis, SQL Server MVP|||>CREATE PROCEDURE [PodajKsiki]

Quote:

Originally Posted by

>AS
>EXTERNAL NAME DemoSQLServer.[DemoSQLServer.Demo].[PodajKsiki]
>go

Thanks.

I cannot run procedure because of the followinf error:

Execution of user code in the .NET Framework is disabled. Enable "clr
enabled" configuration option.

I couldn't find the option in Configuration Manager nor Management
Studio, neigher a .config file. Do you know how to enable the option?
Thank you very much!
/RAM/|||sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO|||I have one more question - concernign functions.
I've written function:

[SqlFunction(Name="GetCurrentDateText")]
public static SqlString GetCurrentDateText()
{
DateTime dt = new DateTime();
return dt.ToString();
}

And I have tried to create a function:

CREATE FUNCTION GetCurrentDateText RETURNS nvarchar(MAX) AS EXTERNAL
NAME DemoSQLServer.DemoGetCurrentDateText

(according to Books Online) But I recive an error:

Incorrect syntax near 'RETURNS'.

I cannot guess what is wrong. Could you help me please?
Thank you!
/RAM/|||R.A.M. (r_ahimsa_m@.poczta.onet.pl) writes:

Quote:

Originally Posted by

I have one more question - concernign functions.
I've written function:
>
[SqlFunction(Name="GetCurrentDateText")]
public static SqlString GetCurrentDateText()
{
DateTime dt = new DateTime();
return dt.ToString();
}
>
And I have tried to create a function:
>
CREATE FUNCTION GetCurrentDateText RETURNS nvarchar(MAX) AS EXTERNAL
NAME DemoSQLServer.DemoGetCurrentDateText
>
(according to Books Online) But I recive an error:
>
Incorrect syntax near 'RETURNS'.
>
I cannot guess what is wrong. Could you help me please?

Parentheses are mandatory, even for parameterless funtions.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

2005: Business Intelligence Development Studio?

Hello,
I am learning SQLServer 2005 Express Edition. I wanted to learn Report
Designer which - according to my tutorial book - is part of Business
Intelligence Development Studio. I can't find it in Internet. Could
you help me plase?
Thank you very much!
/RAM/It only comes with Express Advanced Services and not Express, they are both
free.

--
Tony Rogerson
SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson - technical commentary from a SQL
Server Consultant
http://sqlserverfaq.com - free video tutorials

"R.A.M." <r_ahimsa_m@.poczta.onet.plwrote in message
news:p2f6b2d20jnmn9mfdvsh8504p5d4aml0s0@.4ax.com...

Quote:

Originally Posted by

Hello,
I am learning SQLServer 2005 Express Edition. I wanted to learn Report
Designer which - according to my tutorial book - is part of Business
Intelligence Development Studio. I can't find it in Internet. Could
you help me plase?
Thank you very much!
/RAM/
>

|||On Tue, 11 Jul 2006 07:11:36 +0100, "Tony Rogerson"
<tonyrogerson@.sqlserverfaq.comwrote:

Quote:

Originally Posted by

>It only comes with Express Advanced Services and not Express, they are both
>free.

I have just installed Express Edition Advanced Services. I see no
Business Intelligence application. What should I do?
Please help.
/RAM/|||I have installed also SQLEXPR_TOOLKIT.EXE. Now I see "SQL Server
Business Intelligence Development Studio" in the Start menu with a
link to "C:\Program Files\Microsoft Visual Studio
8\Common7\IDE\devenv.exe" - but I do not have such file. What should I
do? Please help
/RAM/

2005: BACKUP

Hello,
I am learning SQL Server 2005. I need to know how to make a backup of
a database. I tried (according to my book):
BACKUP DATABASE DemoSQLServer TO DISK = "G:\DemoSQLServer.bak"
But I got error:
Incorrect syntax near 'G:\DemoSQLServer.bak'.
Please help.
Thank you very much.
/RAM/RAM (r_ahimsa_m@.poczta.onet.pl) writes:

Quote:

Originally Posted by

I am learning SQL Server 2005. I need to know how to make a backup of
a database. I tried (according to my book):
BACKUP DATABASE DemoSQLServer TO DISK = "G:\DemoSQLServer.bak"
But I got error:
Incorrect syntax near 'G:\DemoSQLServer.bak'.
Please help.

If the book fails, try Books Online.

Generally, in T-SQL, single quote is used as the string delimiter. (Although
it is possible with a legacy setting in force also use double quote as
string delimiter, but this is not recommended.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||The error is the double quotes! You need to use single quotes to
specify the filename. The statement should be rewritten as:
BACKUP DATABASE DemoSQLServer TO DISK = 'G:\DemoSQLServer.bak'

N.I.T.I.N.

RAM wrote:

Quote:

Originally Posted by

Hello,
I am learning SQL Server 2005. I need to know how to make a backup of
a database. I tried (according to my book):
BACKUP DATABASE DemoSQLServer TO DISK = "G:\DemoSQLServer.bak"
But I got error:
Incorrect syntax near 'G:\DemoSQLServer.bak'.
Please help.
Thank you very much.
/RAM/

|||On 25 Jul 2006 00:24:24 -0700, "NiTiN" <emailme.nitin@.gmail.com>
wrote:

Quote:

Originally Posted by

>The error is the double quotes! You need to use single quotes to
>specify the filename. The statement should be rewritten as:
>BACKUP DATABASE DemoSQLServer TO DISK = 'G:\DemoSQLServer.bak'

Thanks,
but I have another problem:
Cannot open backup device 'G:\DemoSQLServer.bak'. Operating system
error 5(Access denied.).

(Changing drive don't help.)
I have no problem with accessing drives from other applications. I had
no problems with SQL Server setup.

Please help.
/RAM/|||"RAM" <r_ahimsa_m@.poczta.onet.plwrote in message
news:6lkec292thjpbhkm7b2h03unpeg045jhp2@.4ax.com...

Quote:

Originally Posted by

On 25 Jul 2006 00:24:24 -0700, "NiTiN" <emailme.nitin@.gmail.com>
wrote:
>

Quote:

Originally Posted by

The error is the double quotes! You need to use single quotes to
specify the filename. The statement should be rewritten as:
BACKUP DATABASE DemoSQLServer TO DISK = 'G:\DemoSQLServer.bak'

>
Thanks,
but I have another problem:
Cannot open backup device 'G:\DemoSQLServer.bak'. Operating system
error 5(Access denied.).
>
(Changing drive don't help.)
I have no problem with accessing drives from other applications. I had
no problems with SQL Server setup.

SQL Server itself for some reason doesn't have access to this drive.

If it's local, check permissions.

If it's remote, change it to a UNC path and make sure the user has domain
priviliges.

Quote:

Originally Posted by

>
Please help.
/RAM/
>

|||but I have another problem:

Quote:

Originally Posted by

Cannot open backup device 'G:\DemoSQLServer.bak'. Operating system
error 5(Access denied.).
>
(Changing drive don't help.)

Hi!

My guess is that you need to grant filesystem privileges to the account
that SQL Server runs as. That account is usually sysopr.

N.I.T.I.N.|||>My guess is that you need to grant filesystem privileges to the account

Quote:

Originally Posted by

>that SQL Server runs as. That account is usually sysopr.

I have little experience with Microsoft software...
On my Windows XP computer I have two accounts Robert (admin) and
Guest. I have installed SQL Server 2005 on Robert's account. I haven't
found information about sysopr in BOL nor Internet. Could you help me
please?
/RAM/|||A few months ago I could create backup using right-click menu, now I
cannot. What's going on?
/RAM/|||RAM (r_ahimsa_m@.poczta.onet.pl) writes:

Quote:

Originally Posted by

but I have another problem:
Cannot open backup device 'G:\DemoSQLServer.bak'. Operating system
error 5(Access denied.).
>
(Changing drive don't help.)
I have no problem with accessing drives from other applications. I had
no problems with SQL Server setup.

Is that a local drive or a network drive?

Presumably the service account for SQL Server does not have access to
this place. Keep in mind that SQL Server is a server application that
logs on its own.

Start SQL Server Configuraiton Manager. Select "SQL Server 2005 Services".
Find the SQL Server service you have problem with. Double-click. Here
you can see under which account SQL Server runs. If you change, you will
have to restart SQL Server.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

2005 Express: testing replication

Hello,
I am learning SQL Server 2005 Express. I need to test replication but
when I run New Subscription Wizard I got error: "There are no
publications to which you can subscribe, either because this server
has no publications or because you do not have sufficient privileges
to access the publications."
I see no option for publications. Does this mean that in Express I
cannot run replication? If I can, how?
Thank you very much
/RAM/Am Fri, 07 Jul 2006 13:59:23 +0200 schrieb R.A.M.:

Quote:

Originally Posted by

Hello,
I am learning SQL Server 2005 Express. I need to test replication but
when I run New Subscription Wizard I got error: "There are no
publications to which you can subscribe, either because this server
has no publications or because you do not have sufficient privileges
to access the publications."
I see no option for publications. Does this mean that in Express I
cannot run replication? If I can, how?
Thank you very much
/RAM/

SQLExpress can use Replication, but only as subscriber. And your message
says, SQLExpress cannot access the publisher. Do you have a publisher
running? Publisher cannot be done with SQLExpress.

bye, Helmut|||On Fri, 7 Jul 2006 14:55:16 +0200, Helmut Woess <user22@.inode.at>
wrote:

Quote:

Originally Posted by

>Am Fri, 07 Jul 2006 13:59:23 +0200 schrieb R.A.M.:
>

Quote:

Originally Posted by

>Hello,
>I am learning SQL Server 2005 Express. I need to test replication but
>when I run New Subscription Wizard I got error: "There are no
>publications to which you can subscribe, either because this server
>has no publications or because you do not have sufficient privileges
>to access the publications."
>I see no option for publications. Does this mean that in Express I
>cannot run replication? If I can, how?
>Thank you very much
>/RAM/

>
>SQLExpress can use Replication, but only as subscriber. And your message
>says, SQLExpress cannot access the publisher. Do you have a publisher
>running? Publisher cannot be done with SQLExpress.
>
>bye, Helmut

thank you
no, I have only Express Edition.
pity.
BTW, is Replication and Data Mirroring the same thing?

/RAM/|||Am Fri, 07 Jul 2006 16:05:09 +0200 schrieb R.A.M.:

...

Quote:

Originally Posted by

BTW, is Replication and Data Mirroring the same thing?
>
/RAM/

Hmm, i am no expert for this. As much as i know is, that data mirroring
means it happens in real time, so you can switch with no delay from one
server to the other one. Replikation goes in intervals, between the
intervals data between the two databases is different. But i am not sure if
this is the right definition.

bye, Helmut|||"R.A.M." <r_ahimsa_m@.poczta.onet.plwrote in message
news:v7qsa2tmij36hi65heqv02j8p52t59nesi@.4ax.com...

Quote:

Originally Posted by

On Fri, 7 Jul 2006 14:55:16 +0200, Helmut Woess <user22@.inode.at>
wrote:
>
thank you
no, I have only Express Edition.
pity.
BTW, is Replication and Data Mirroring the same thing?

No.

Quote:

Originally Posted by

>
/RAM/
>

2005 EE: using full-text indexing

Hello,
I am learning SQL Server 2005 Expres Edition. I need to create full
text index on Books.Remarks column in my database. I tried:

CREATE FULLTEXT CATALOG FTC_Books AS DEFAULT
CREATE FULLTEXT INDEX ON Books (Remarks) KEY INDEX IX_Books_Remarks ON
FTC_Books

Unfortunately I got error:

Full-Text Search is not installed, or a full-text component cannot be
loaded.

I don't understand this because I marked all options during setup.
Please help
/RAM/On Mon, 10 Jul 2006 13:16:49 +0200, R.A.M. wrote:

Quote:

Originally Posted by

>Hello,
>I am learning SQL Server 2005 Expres Edition. I need to create full
>text index on Books.Remarks column in my database. I tried:
>
>CREATE FULLTEXT CATALOG FTC_Books AS DEFAULT
>CREATE FULLTEXT INDEX ON Books (Remarks) KEY INDEX IX_Books_Remarks ON
>FTC_Books
>
>Unfortunately I got error:
>
>Full-Text Search is not installed, or a full-text component cannot be
>loaded.
>
>I don't understand this because I marked all options during setup.
>Please help
>/RAM/

Hi RAM,

Which version of SQL Server Express did yoou download? The "normal"
ediition ("SQL Server 2005 Express Edition" or "SQL Server 2005 Express
Edition SP1"), or the extended version ("SQL Server 2005 Express Edition
with Advanced Services SP1")?

As yoou can see on the feature comparison chart
(http://www.microsoft.com/sql/prodin...-features.mspx),
Full-text Search is only available for SQL Server Express in the SQL
Server Express with Advanced Services download.

--
Hugo Kornelis, SQL Server MVP|||On Mon, 10 Jul 2006 23:15:36 +0200, Hugo Kornelis
<hugo@.perFact.REMOVETHIS.info.INVALIDwrote:

Quote:

Originally Posted by

>Full-text Search is only available for SQL Server Express in the SQL
>Server Express with Advanced Services download.

Now I have installed Advanced Services. But full-text search does not
work... Could you help me please?|||On Wed, 19 Jul 2006 09:03:19 +0200, RAM wrote:

Quote:

Originally Posted by

>On Mon, 10 Jul 2006 23:15:36 +0200, Hugo Kornelis
><hugo@.perFact.REMOVETHIS.info.INVALIDwrote:
>

Quote:

Originally Posted by

>>Full-text Search is only available for SQL Server Express in the SQL
>>Server Express with Advanced Services download.

>
>Now I have installed Advanced Services. But full-text search does not
>work... Could you help me please?

Hi RAM,

I'm sorry. I know from googling that full-text is included in Advanced
Services, but I've never worked with or installed full-text search in
any edition of SQL Server.

Maybe you should ask this in microsoft.public.sqlserver.fulltext. The
experts there will probably be better equipped to help you.

--
Hugo Kornelis, SQL Server MVP|||On Thu, 20 Jul 2006 23:06:51 +0200, Hugo Kornelis
<hugo@.perFact.REMOVETHIS.info.INVALIDwrote:

Quote:

Originally Posted by

>On Wed, 19 Jul 2006 09:03:19 +0200, RAM wrote:
>

Quote:

Originally Posted by

>>On Mon, 10 Jul 2006 23:15:36 +0200, Hugo Kornelis
>><hugo@.perFact.REMOVETHIS.info.INVALIDwrote:
>>

Quote:

Originally Posted by

>>>Full-text Search is only available for SQL Server Express in the SQL
>>>Server Express with Advanced Services download.

>>
>>Now I have installed Advanced Services. But full-text search does not
>>work... Could you help me please?

>
>Hi RAM,
>
>I'm sorry. I know from googling that full-text is included in Advanced
>Services, but I've never worked with or installed full-text search in
>any edition of SQL Server.
>
>Maybe you should ask this in microsoft.public.sqlserver.fulltext. The
>experts there will probably be better equipped to help you.

I don't see the group microsoft.public.sqlserver.fulltext.|||On Thu, 27 Jul 2006 15:12:35 +0200, RAM <r_ahimsa_m@.poczta.onet.pl>
wrote:

Quote:

Originally Posted by

>I don't see the group microsoft.public.sqlserver.fulltext.

It does exist:

http://groups.google.com/group/micr...server.fulltext
Not all news servers carry all the newsgroups. For the Microsoft
groups it is best to get them directly from the Microsoft news servers
at msnews.microsoft.com.

Roy Harvey
Beacon Falls, CT