Microsoft Search service can't start after SQL2005 installation!

Hi
The version numbers in your post seem to be inconsistent!
I assume that you have removed SQL 2000 and only have a named instance of
SQL 2005. If you want the instance of SQL 2005 to be the default instance you
will need to install SQL 2005 again anyhow, and possibly remove the named
instance of SQL 2005 if it is not wanted. If you want to reinstall the
current named instance you can install it from the command line with the
REINSTALLMODE=OMUS option see
http://msdn2.microsoft.com/en-us/library/ms144259.aspx#reinstallmode
REINSTALLMODE=O will replace the missing file, but it would probably not do
any harm having the other options.
John
"PG" wrote:

> Hi everybody I had a server with SQL2000 Standard on Server2003 Standard
> working, but I was told to uninstall and install SQl2005 Standard, but now
> when I start the server I receive an error saying that a service could not
> start, I went to see what service the server was talking about and it was
> the Microsoft Search service. The error says that the specified file can't
> be found, so I went to "C:\Program Files\Common
> Files\System\MSSearch\Bin\mssearch.exe" and the file mssearch.exe is
> missing!!!
> Was it the uninstall of SQL2000 that screwed this up, or the installation of
> SQL2005?
> I dont know what to do from here, what can I do?...Any help would be
> appreciated.
> Thanks in advance..
>
>
Hi
"PG" wrote:

> I'm sorry if I didn't make myself clear, what I did was uninstall SQL2000
> and afterwards install SQL2005 on the same machine (WindowsServer2003).
>
mssearch.exe is for SQL 2000 if you want to reinstall it see
http://support.microsoft.com/default.aspx/kb/827449 but if you have SQL 2005
you should see an instance of SQL Server FullText Search (MSSQLSERVER) in
your services which runs "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\msftesql.exe". The article also shows how to
remove it.
John
|||John Bell from BCSI?
Jason

Quote:

Originally Posted by John Bell

Hi
"PG" wrote:

> I'm sorry if I didn't make myself clear, what I did was uninstall SQL2000
> and afterwards install SQL2005 on the same machine (WindowsServer2003).
>
mssearch.exe is for SQL 2000 if you want to reinstall it see
http://support.microsoft.com/default.aspx/kb/827449 but if you have SQL 2005
you should see an instance of SQL Server FullText Search (MSSQLSERVER) in
your services which runs "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\msftesql.exe". The article also shows how to
remove it.
John

Metadata: Columns in Indexes

Hi, Do you know if there are any way to know the name of wich columns integrate the indexes?
I have just found a column named "keys" in the table "sysindexes" but it is just a kind of code.

I have a problem with the primary keys that have created,
something similar to the refered: http://support.microsoft.com/kb/262541/en-us

So I am trying to identify which of my indexes would make conflict with the PKs, and
also need to standarize them. Could you help me please?

There are a few ways.

1. In 2000 or earlier, you can use: INDEX_COL, which is a bit annoying, but it works

2. In 2005, use the sys.index_columns view. It gives you a much easier view.

3. In either, for KEY constraints, use the INFORMATION_SCHEMA.KEY_COLUMN_USAGE view.

|||

Thank Louis, Now I am using this query to get the column names of each index,
but just don't know how to compare the columns from one index with the ones that has
the other.

I need to be sure that the columns that I am using as a part of my PK's are not contained exactly as a
part of any Index because that will cause me problems with certain kind of querys used trough my
linked server (because of the bug that I have refered)

select so.name as tabla, si.name as indice, --, si.indid as tipoindice,
sc.name

from sysobjects so,
sysindexes si,
sysindexkeys sik,
syscolumns sc
where so.xtype = 'U'
and si.id = OBJECT_ID(so.name)
and so.id = sik.id
and si.indid = sik.indid
and so.id = sc.id
and sik.colid = sc.colid

and (indexproperty(si.id, si.name, 'IsAutoStatistics') = 0 /*Index was generated by the auto create statistics option of sp_dboption. 1 = True 0 = False NULL = Invalid input)*/
and indexproperty(si.id, si.name, 'IsHypothetical') = 0)
and indexproperty(si.id, si.name, 'IsStatistics') = 0
order by si.indid

Whit this query i get something like this:

Table Index Column
-
Author IX_Author_2 code
Author IX_Author_2 c_branch

Author IX_Author_1 code

Author PK_Author code
Author PK_Author c_branch

So, for example the case of IX_Author_2 and PK_Author will give me a problem and
I need to correct the Indexes but first i need a way to identify them.
I am trying with a cursor but just cannot get the right.
Could anybody give me an idea please.

Merging two tables then grouping them

I have two tables, one is named Employee and the other Job_title. I'm trying to combine the two tables so I can group certain columns.

This is what I thought of so far and please correct me if I'm wrong.

SELECT Last_name FROM Employee
UNION
SELECT Job_title_code FROM Job_title
GROUP BY Exempt_non_exempt
FROM Job_title

Now this is just a theory (obviously it doesn't work) but basiclly I'm trying to have columns from two tables and have the grouped.Huh?

Wha?

There is no relationship between these tables?
No foreign keys?
You are selecting a single column and performing GROUP BY without any aggregate functions?

This makes no sense.|||Well, in both tables, they each have a job_title_code column.

Employee table
lastname, firstname, job title code

Job_title Table
job title code, job title, salary, exempt/non exempt|||Is this homework?

It looks like homework.
It sounds like homework.

Are we studying relational databases?|||So why aren't you using a join?

SELECT Last_name,
Job_title_code,
Exemp_non_exempt
FROM Employee
INNER JOIN Job_title on Employee.Job_title_code = Job_title.Job_title_code

I don't think this is homework. If it was homework his question would be more clearly phrased!|||sorry for the mix up, yes it is homework. that's for suggesting the INNER JOIN command. i found a variation of what you did and it worked out for my db. by the way, how did you put your code in a window like that?

SELECT Employee.Last_Name, Job_title.Exempt_non_exempt_status
FROM Employee
INNER JOIN Job_title
ON Employee.Job_title_code=Job_title.Job_title_code|||Enclose your code in CODE tagsL

[XCode]
Your code here
[X/Code]

Remove the X characters...

Your code here

merging two databases into single one

Hi,
I have two databases.i would like to joing these two databases
into single one.How should i do it?
Example:
I have database named DatabaseA and its size was increased very high
so i renamed to DatabaseA_old & create new database DatabaseA.I have
upgraded the server and increased the database size.Now i would like
to make a single database.
Please help me.
Regards,
Vijay
Create a new Database and use Import/Export Wizard to Import the Data
from database DatabaseA_old .
Well you have to attach the DatabaseA_old first and then do a import.
|||That depends on the exact nature of your 'merge'. There is no single command
to accomplish the 'merge'. But in general you need to script out all the
objects in your old database, create them in the new database--if not already
there, and insert the data from the old database into the corresponding
tables in the new database.
Inserting data may be done with INSERT, SELECT INTO, or bulk copy out
followed by bulk copy in.
It's a good practice to script out the entire 'merge' procedure.
Linchi
"Vijay" wrote:

> Hi,
> I have two databases.i would like to joing these two databases
> into single one.How should i do it?
> Example:
> I have database named DatabaseA and its size was increased very high
> so i renamed to DatabaseA_old & create new database DatabaseA.I have
> upgraded the server and increased the database size.Now i would like
> to make a single database.
> Please help me.
> Regards,
> Vijay
>

merging two databases into single one

Hi,
I have two databases.i would like to joing these two databases
into single one.How should i do it?
Example:
I have database named DatabaseA and its size was increased very high
so i renamed to DatabaseA_old & create new database DatabaseA.I have
upgraded the server and increased the database size.Now i would like
to make a single database.
Please help me.
Regards,
VijayCreate a new Database and use Import/Export Wizard to Import the Data
from database DatabaseA_old .
Well you have to attach the DatabaseA_old first and then do a import.|||That depends on the exact nature of your 'merge'. There is no single command
to accomplish the 'merge'. But in general you need to script out all the
objects in your old database, create them in the new database--if not alread
y
there, and insert the data from the old database into the corresponding
tables in the new database.
Inserting data may be done with INSERT, SELECT INTO, or bulk copy out
followed by bulk copy in.
It's a good practice to script out the entire 'merge' procedure.
Linchi
"Vijay" wrote:

> Hi,
> I have two databases.i would like to joing these two databases
> into single one.How should i do it?
> Example:
> I have database named DatabaseA and its size was increased very high
> so i renamed to DatabaseA_old & create new database DatabaseA.I have
> upgraded the server and increased the database size.Now i would like
> to make a single database.
> Please help me.
> Regards,
> Vijay
>

merging two databases into single one

Hi,
I have two databases.i would like to joing these two databases
into single one.How should i do it?
Example:
I have database named DatabaseA and its size was increased very high
so i renamed to DatabaseA_old & create new database DatabaseA.I have
upgraded the server and increased the database size.Now i would like
to make a single database.
Please help me.
Regards,
VijayCreate a new Database and use Import/Export Wizard to Import the Data
from database DatabaseA_old .
Well you have to attach the DatabaseA_old first and then do a import.|||That depends on the exact nature of your 'merge'. There is no single command
to accomplish the 'merge'. But in general you need to script out all the
objects in your old database, create them in the new database--if not already
there, and insert the data from the old database into the corresponding
tables in the new database.
Inserting data may be done with INSERT, SELECT INTO, or bulk copy out
followed by bulk copy in.
It's a good practice to script out the entire 'merge' procedure.
Linchi
"Vijay" wrote:
> Hi,
> I have two databases.i would like to joing these two databases
> into single one.How should i do it?
> Example:
> I have database named DatabaseA and its size was increased very high
> so i renamed to DatabaseA_old & create new database DatabaseA.I have
> upgraded the server and increased the database size.Now i would like
> to make a single database.
> Please help me.
> Regards,
> Vijay
>