"Order by" error running DBCC DBREINDEX

I'm running a simple DBCC DBREINDEX ('myTable') and I receive the
following error:

"Server: Msg 169, Level 15, State 2, Line 2
A column has been specified more than once in the order by list.
Columns in the order by list must be unique. DBCC execution
completed. If DBCC printed error messages, contact your system
administrator."

I can successfully reindex other tables in this database. I thought
that perhaps I had objects in the database that ended up with the same
name, but I've pretty much ruled that out.

Any suggestions?

Thanks
John D. Morris
mailto://jmorris_42@.hotmail.comjmorris_42@.hotmail.com (John Morris) wrote in message news:<5b4367be.0308050426.10612a9f@.posting.google.com>...
> I'm running a simple DBCC DBREINDEX ('myTable') and I receive the
> following error:
> "Server: Msg 169, Level 15, State 2, Line 2
> A column has been specified more than once in the order by list.
> Columns in the order by list must be unique. DBCC execution
> completed. If DBCC printed error messages, contact your system
> administrator."
> I can successfully reindex other tables in this database. I thought
> that perhaps I had objects in the database that ended up with the same
> name, but I've pretty much ruled that out.
> Any suggestions?
> Thanks
> John D. Morris
> mailto://jmorris_42@.hotmail.com

Followup:

As it turns out, I had a hidden "Hypothetical" index that the index
tuning wizard decided not to clean up when it was done. The only way
to see the index was in sp_helpindex. It did not appear in the object
browser. MS claims this was fixed in SP1...I guess not. Anyway,
dropped the hypothetical index and all is well.

-jdm|||John,

Can you consistently repro the bug?
--
Arun Marathe
Microsoft Corporation

Disclaimers:
(1) This posting is provided "AS IS" with no warranties, and confers no
rights.
(2) Use of included script samples are subject to the terms specified at:
http://www.microsoft.com/info/cpyright.htm

"John D. Morris" <jmorris@.sni.org> wrote in message
news:d034511a.0308051015.60cc849a@.posting.google.c om...
> jmorris_42@.hotmail.com (John Morris) wrote in message
news:<5b4367be.0308050426.10612a9f@.posting.google.com>...
> > I'm running a simple DBCC DBREINDEX ('myTable') and I receive the
> > following error:
> > "Server: Msg 169, Level 15, State 2, Line 2
> > A column has been specified more than once in the order by list.
> > Columns in the order by list must be unique. DBCC execution
> > completed. If DBCC printed error messages, contact your system
> > administrator."
> > I can successfully reindex other tables in this database. I thought
> > that perhaps I had objects in the database that ended up with the same
> > name, but I've pretty much ruled that out.
> > Any suggestions?
> > Thanks
> > John D. Morris
> > mailto://jmorris_42@.hotmail.com
> Followup:
> As it turns out, I had a hidden "Hypothetical" index that the index
> tuning wizard decided not to clean up when it was done. The only way
> to see the index was in sp_helpindex. It did not appear in the object
> browser. MS claims this was fixed in SP1...I guess not. Anyway,
> dropped the hypothetical index and all is well.
> -jdm

"must declare variable" when variable has been declared!

Any idea why the following message is returned?

Server: Msg 137, Level 15, State 2, Line 5
Must declare the variable '@.table'.

The script is created to run through each column in the database and check it against cross referenced data in other table. It had to be built because of the database we own has not a single referntial constraint in it (long story but it's from the the age old "our code works better than a well designed database" school of thought).

excuse the poorly laid out SQL - it's hard to copy and paste into this thing...

Thanks
Yal

------------------------

SET NOCOUNT ON

DECLARE @.table VARCHAR(32)
,@.column VARCHAR(32)
,@.x_table VARCHAR(32)
,@.x_column VARCHAR(32)
,@.x_type VARCHAR(32)
,@.problem VARCHAR(32)
,@.count VARCHAR(32)

DECLARE xref_check CURSOR FOR
SELECT table_name, column_name, xref_table, xref_column, xref_type
FROM xref_check

OPEN xref_check
FETCH NEXT FROM xref_check INTO @.table, @.column, @.x_table, @.x_column, @.x_type

WHILE @.@.FETCH_STATUS = 0
BEGIN

IF @.x_table = 'PS_XREF'
BEGIN
-- SELECT @.table, @.column, @.x_table, @.x_column, @.x_type
EXEC ('IF (SELECT COUNT('+ @.column +')
FROM '+ @.table +'
WHERE '+ @.column + ' NOT IN (SELECT code FROM PS_XREF WHERE type = '''+ @.x_type +''')) > 0
BEGIN
SELECT @.table, @.column, @.x_table, @.x_column, @.x_type, x.'+ @.column +'
FROM '+ @.table +' x
WHERE '+ @.column + ' NOT IN (SELECT code FROM PS_XREF WHERE type = '''+ @.x_type +''')
END'
)

END

ELSE
BEGIN
-- SELECT @.table, @.column, @.x_table, @.x_column, @.x_type
EXEC ('IF (SELECT COUNT('+ @.column +')
FROM '+ @.table +'
WHERE '+ @.column + ' NOT IN (SELECT '+ @.x_column +' FROM '+ @.x_table +')) > 0
BEGIN
SELECT @.table, @.column, @.x_table, @.x_column, @.x_type, x.'+ @.column +'
FROM '+ @.table +' x
WHERE '+ @.column + ' NOT IN (SELECT '+ @.x_column +' FROM '+ @.x_table +')
END')
END

FETCH NEXT FROM xref_check INTO @.table, @.column, @.x_table, @.x_column, @.x_type

END

CLOSE xref_check
DEALLOCATE xref_checkMake sure your references to these variables exist outside the string. For example:

@.x_type +''')) > 0
BEGIN
SELECT @.table, @.column, @.x_table, @.x_column, @.x_type, x.'

should have @.table, @.column ... outside the string like you did before this statement.

"Internal SQL Server error."

"Server: Msg 8624, Level 16, State 7, Procedure p_get_LocalAuthor2, Line 58
Internal SQL Server error."
...and on that note, I'm going home.
What does SELECT @.@.VERSION yield? What does p_get_LocalAuthor2 look like?
What is on line 58?
"Mike C#" <xyz@.xyz.com> wrote in message
news:uOisHvzEHHA.3608@.TK2MSFTNGP02.phx.gbl...
> "Server: Msg 8624, Level 16, State 7, Procedure p_get_LocalAuthor2, Line
> 58
> Internal SQL Server error."
> ...and on that note, I'm going home.
>
|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:e66wS1zEHHA.3784@.TK2MSFTNGP02.phx.gbl...
> What does SELECT @.@.VERSION yield? What does p_get_LocalAuthor2 look like?
> What is on line 58?
Hi Aaron,
Don't sweat it. This is a stored procedure that ran fine about 20 times in
a row on SQL 2000 SP 4. The 21st time seems to have been the charm. I
already checked and there's no KB articles that address this particular
situation (though there are a few that talk about "Internal Server Error"
under different circumstances that don't apply to my situation.)
BTW, Line 58 looks like this: DECLARE @.s VARCHAR(50)
Cool, huh? Thanks.
|||> already checked and there's no KB articles that address this particular
> situation (though there are a few that talk about "Internal Server Error"
> under different circumstances that don't apply to my situation.)
Most "Internal Server Error" issues are internal bugs that are fixed with
SPs or hotfixes. It may very well be a symptom that is fixed by a hotfix
that addressed a different system (not all bugs ever make it to the
knowledge base, so don't consider it to be gospel).
But, if you want to stay at SP4 and ignore the more recent hotfixes, you may
still continue to have this problem. If you can reproduce it on a second
box, especially after applying the latest hotfix, you may want to post a bug
on connect.
A
|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23SYpze8EHHA.4016@.TK2MSFTNGP02.phx.gbl...
> Most "Internal Server Error" issues are internal bugs that are fixed with
> SPs or hotfixes. It may very well be a symptom that is fixed by a hotfix
> that addressed a different system (not all bugs ever make it to the
> knowledge base, so don't consider it to be gospel).
> But, if you want to stay at SP4 and ignore the more recent hotfixes, you
> may still continue to have this problem. If you can reproduce it on a
> second box, especially after applying the latest hotfix, you may want to
> post a bug on connect.
Thanks, I was just venting For now I've rebooted the box and it
suddenly works again. Go figure. I'll probably post a bug if it happens
again.
Thanks again
|||> Thanks, I was just venting
You should consider a blog.
Here, just about everything is presumed to be a request for help.
A

"Internal SQL Server error."

"Server: Msg 8624, Level 16, State 7, Procedure p_get_LocalAuthor2, Line 58
Internal SQL Server error."
...and on that note, I'm going home.What does SELECT @.@.VERSION yield? What does p_get_LocalAuthor2 look like?
What is on line 58?
"Mike C#" <xyz@.xyz.com> wrote in message
news:uOisHvzEHHA.3608@.TK2MSFTNGP02.phx.gbl...
> "Server: Msg 8624, Level 16, State 7, Procedure p_get_LocalAuthor2, Line
> 58
> Internal SQL Server error."
> ...and on that note, I'm going home.
>|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:e66wS1zEHHA.3784@.TK2MSFTNGP02.phx.gbl...
> What does SELECT @.@.VERSION yield? What does p_get_LocalAuthor2 look like?
> What is on line 58?
Hi Aaron,
Don't sweat it. This is a stored procedure that ran fine about 20 times in
a row on SQL 2000 SP 4. The 21st time seems to have been the charm. I
already checked and there's no KB articles that address this particular
situation (though there are a few that talk about "Internal Server Error"
under different circumstances that don't apply to my situation.)
BTW, Line 58 looks like this: DECLARE @.s VARCHAR(50)
Cool, huh? Thanks.|||> already checked and there's no KB articles that address this particular
> situation (though there are a few that talk about "Internal Server Error"
> under different circumstances that don't apply to my situation.)
Most "Internal Server Error" issues are internal bugs that are fixed with
SPs or hotfixes. It may very well be a symptom that is fixed by a hotfix
that addressed a different system (not all bugs ever make it to the
knowledge base, so don't consider it to be gospel).
But, if you want to stay at SP4 and ignore the more recent hotfixes, you may
still continue to have this problem. If you can reproduce it on a second
box, especially after applying the latest hotfix, you may want to post a bug
on connect.
A|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:%23SYpze8EHHA.4016@.TK2MSFTNGP02.phx.gbl...
> Most "Internal Server Error" issues are internal bugs that are fixed with
> SPs or hotfixes. It may very well be a symptom that is fixed by a hotfix
> that addressed a different system (not all bugs ever make it to the
> knowledge base, so don't consider it to be gospel).
> But, if you want to stay at SP4 and ignore the more recent hotfixes, you
> may still continue to have this problem. If you can reproduce it on a
> second box, especially after applying the latest hotfix, you may want to
> post a bug on connect.
Thanks, I was just venting For now I've rebooted the box and it
suddenly works again. Go figure. I'll probably post a bug if it happens
again.
Thanks again|||> Thanks, I was just venting
You should consider a blog.
Here, just about everything is presumed to be a request for help.
A

"Internal SQL Server error."

"Server: Msg 8624, Level 16, State 7, Procedure p_get_LocalAuthor2, Line 58
Internal SQL Server error."
...and on that note, I'm going home.What does SELECT @.@.VERSION yield? What does p_get_LocalAuthor2 look like?
What is on line 58?
"Mike C#" <xyz@.xyz.com> wrote in message
news:uOisHvzEHHA.3608@.TK2MSFTNGP02.phx.gbl...
> "Server: Msg 8624, Level 16, State 7, Procedure p_get_LocalAuthor2, Line
> 58
> Internal SQL Server error."
> ...and on that note, I'm going home.
>|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:e66wS1zEHHA.3784@.TK2MSFTNGP02.phx.gbl...
> What does SELECT @.@.VERSION yield? What does p_get_LocalAuthor2 look like?
> What is on line 58?
Hi Aaron,
Don't sweat it. This is a stored procedure that ran fine about 20 times in
a row on SQL 2000 SP 4. The 21st time seems to have been the charm. I
already checked and there's no KB articles that address this particular
situation (though there are a few that talk about "Internal Server Error"
under different circumstances that don't apply to my situation.)
BTW, Line 58 looks like this: DECLARE @.s VARCHAR(50)
Cool, huh? Thanks.|||> already checked and there's no KB articles that address this particular
> situation (though there are a few that talk about "Internal Server Error"
> under different circumstances that don't apply to my situation.)
Most "Internal Server Error" issues are internal bugs that are fixed with
SPs or hotfixes. It may very well be a symptom that is fixed by a hotfix
that addressed a different system (not all bugs ever make it to the
knowledge base, so don't consider it to be gospel).
But, if you want to stay at SP4 and ignore the more recent hotfixes, you may
still continue to have this problem. If you can reproduce it on a second
box, especially after applying the latest hotfix, you may want to post a bug
on connect.
A|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23SYpze8EHHA.4016@.TK2MSFTNGP02.phx.gbl...
>> already checked and there's no KB articles that address this particular
>> situation (though there are a few that talk about "Internal Server Error"
>> under different circumstances that don't apply to my situation.)
> Most "Internal Server Error" issues are internal bugs that are fixed with
> SPs or hotfixes. It may very well be a symptom that is fixed by a hotfix
> that addressed a different system (not all bugs ever make it to the
> knowledge base, so don't consider it to be gospel).
> But, if you want to stay at SP4 and ignore the more recent hotfixes, you
> may still continue to have this problem. If you can reproduce it on a
> second box, especially after applying the latest hotfix, you may want to
> post a bug on connect.
Thanks, I was just venting :) For now I've rebooted the box and it
suddenly works again. Go figure. I'll probably post a bug if it happens
again.
Thanks again|||> Thanks, I was just venting :)
You should consider a blog.
Here, just about everything is presumed to be a request for help.
A

"DISTINCT" problem...

I build an application that should show a on line magazin.
the articles in the magazin have name' article ID and "type"- "humor", "news" a ns so...
all of the article stored in a table and i use "SELECT DISTINCT type" to get the list of the types...
but' i want this types to be sorted, and if i use "ORDER BY theorder" i get an error massage- "you can't use DISTINCT with out including the column name".
so i changed to:
"SELECT DISTINCT type, theorder FROM..."
but then i get each type more then one' since the theorder column has diferent values...
how can i get the types, only one time each, and sort them?

Can you post your exact query? It should look something like this...
select distinct type from myTable order by theorder
Order by values do not have to appear in a select list, that only applies to the group by clause.

|||this is my query:cmd.CommandText = "SELECT DISTINCT type FROM tbl_paper WHERE alonNUM='" & alonNUM & "' ORDER BY theorder"and this the error massage and i copyed it from the screen:ORDER BY items must appear in the select list if SELECT DISTINCT is specified.|||This is a flaw with your data. You are saying you want to order by a field that is not distinct to each of your "types". How does the system know which one of the "theorder" fields to use for each of the "type" fields? I think you need to examine the data or how you want to display this field.
Anyhow, without getting multiple "types" back you cant do this type of query with the order by clause based on your data.

Nick|||This will happen even if your Data in the table is 100% correct. When? If you have 1:Many mapping, then you can't avoid having duplicate rows with join.
But in your case, it seems single table. So you table is not designed properly. If you add addition column to the select list then the combined value for all select columns will
be tried for distinctness. In this case {type, theorder} pair is distinct even though you might see multiple copies of the same type.|||Instead of DISTINCT, try a GROUP BY, and use a MAX() or a MIN() on the other column, like this:

SELECT
type,
MAX(theorder)
FROM
tbl_paper
WHERE
alonNUM='something'
GROUP BY
type
ORDER BY
2

This will give you one row per type, ordered by the maximum theorder value found for each type.

"Best" error messages contest

Server: Msg 1015, Level 15, State 1, Line 1
An aggregate cannot appear in an ON clause unless it is in a subquery
contained in a HAVING clause or select list, and the column being aggregated
is an outer reference.Why not to post the statement also?
AMB
"Ian Boyd" wrote:

> Server: Msg 1015, Level 15, State 1, Line 1
> An aggregate cannot appear in an ON clause unless it is in a subquery
> contained in a HAVING clause or select list, and the column being aggregat
ed
> is an outer reference.
>
>|||Cause it was querying a view, with a self aggregate join. It wouldn't make
sense.
Besides, that's not the contest.

> Why not to post the statement also?|||"Ian Boyd" <ian.msnews010@.avatopia.com> wrote in message
news:%23iiDq5LTFHA.3840@.tk2msftngp13.phx.gbl...
> Server: Msg 1015, Level 15, State 1, Line 1
> An aggregate cannot appear in an ON clause unless it is in a subquery
> contained in a HAVING clause or select list, and the column being
> aggregated is an outer reference.
>
RAISERROR('Two guys walk into a bar...',0,1)|||Q: "Who Killed the Monkey in Raiders of the Lost Ark?"
A: "Bad Date."
"Chris Hohmann" <nospam@.thankyou.com> wrote in message
news:eUuKDXOTFHA.584@.TK2MSFTNGP15.phx.gbl...
> "Ian Boyd" <ian.msnews010@.avatopia.com> wrote in message
> news:%23iiDq5LTFHA.3840@.tk2msftngp13.phx.gbl...
> RAISERROR('Two guys walk into a bar...',0,1)
>|||"Michael C#" <howsa@.boutdat.com> wrote in message
news:uQjzyhOTFHA.2520@.TK2MSFTNGP09.phx.gbl...
> Q: "Who Killed the Monkey in Raiders of the Lost Ark?"
> A: "Bad Date."
> "Chris Hohmann" <nospam@.thankyou.com> wrote in message
> news:eUuKDXOTFHA.584@.TK2MSFTNGP15.phx.gbl...
>
Dilbert: What color do you want that database?
PHB: I think mauve has more RAM.

"Balance Carried Forward" / "Balance Brought Forward"

I have a statement report. There is a table which contains the statement
line details. The printout of this may last several pages. Assume it lasts n
pages.
The bottom of page1 should show the total debits and total credits for page
1 only.
The bottom of page 2 should show the total debits and credits for page 1 and
2 only e.t.c.
I found I cant add Globals!PageNumber as a group to the table.
Neither am I allowed to put the data field in the page footer.
I thought RunningValue function might do it, but this always prints the
grand total for all pages.
Help !
Thanks
Chris BrooksbankPagination and aggregation (I suspect) are in unrelated parts of the RS
code..(I think all of the aggregation stuff is done prior to pagination).
There are no page totals kinds of functions that I am aware of..
Probably the best you can do is to create small groupings, so that a group
will never be larger than a page and total at the group level...
Unless one of the dev guys has a suggestion.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Chris Brooksbank" <NoSpam@.Ta.com> wrote in message
news:OR2sIiBZEHA.2408@.tk2msftngp13.phx.gbl...
> I have a statement report. There is a table which contains the statement
> line details. The printout of this may last several pages. Assume it lasts
n
> pages.
> The bottom of page1 should show the total debits and total credits for
page
> 1 only.
> The bottom of page 2 should show the total debits and credits for page 1
and
> 2 only e.t.c.
> I found I cant add Globals!PageNumber as a group to the table.
> Neither am I allowed to put the data field in the page footer.
> I thought RunningValue function might do it, but this always prints the
> grand total for all pages.
> Help !
> Thanks
> Chris Brooksbank
>

rebuild master

hi,
is there a way to rebuild the master database in sql server 2005 without
installing SQL Server again. I try from the command line, but it sends me to
add/remove program, and from here there are is no option to do that.
in advance i'll appreciatte all your help.
Edmundo J. Davila
Tibor,
That instruction send me to the add/remove programs, and as i said, there is
not option to rebuild master database from there.
Edmundo J. Davila
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribi
en el mensaje de noticias
news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
> You find instructions for how to rebuild in Books Online:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
> More specifically:
> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName>
> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
> Above it from the BOL topic...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>
|||Are you running SQL Server Express? If so, why not just detach your user
databases, uninstall / reinstall, then re-attach your user databases?
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
> hi,
> is there a way to rebuild the master database in sql server 2005 without
> installing SQL Server again. I try from the command line, but it sends me
> to add/remove program, and from here there are is no option to do that.
> in advance i'll appreciatte all your help.
> Edmundo J. Davila
|||How about this link?
How to: Install SQL Server 2005 from the Command Prompt:
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Ekrem nsoy
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
> Tibor,
> That instruction send me to the add/remove programs, and as i said, there
> is not option to rebuild master database from there.
> Edmundo J. Davila
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> escribi en el mensaje de noticias
> news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>
|||Yes Tibor I know, I just thought this link could direct him to the mentioned
web site as the link you gave didn't work for him as far as I see.
Ekrem nsoy
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23fm8pD3JIHA.2064@.TK2MSFTNGP06.phx.gbl...
> That is the same article as I posted, but I posted a local BOL URL...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
> news:6F10DBDF-C18B-4C7F-9CC7-AC63878907D1@.microsoft.com...
>

rebuild master

hi,
is there a way to rebuild the master database in sql server 2005 without
installing SQL Server again. I try from the command line, but it sends me to
add/remove program, and from here there are is no option to do that.
in advance i'll appreciatte all your help.
Edmundo J. DavilaYou find instructions for how to rebuild in Books Online:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
More specifically:
start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine
REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
Above it from the BOL topic...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
> hi,
> is there a way to rebuild the master database in sql server 2005 without installing SQL Server
> again. I try from the command line, but it sends me to add/remove program, and from here there are
> is no option to do that.
> in advance i'll appreciatte all your help.
> Edmundo J. Davila|||Tibor,
That instruction send me to the add/remove programs, and as i said, there is
not option to rebuild master database from there.
Edmundo J. Davila
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió
en el mensaje de noticias
news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
> You find instructions for how to rebuild in Books Online:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
> More specifically:
> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName>
> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
> Above it from the BOL topic...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005 without
>> installing SQL Server again. I try from the command line, but it sends me
>> to add/remove program, and from here there are is no option to do that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>|||Are you running SQL Server Express? If so, why not just detach your user
databases, uninstall / reinstall, then re-attach your user databases?
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
> hi,
> is there a way to rebuild the master database in sql server 2005 without
> installing SQL Server again. I try from the command line, but it sends me
> to add/remove program, and from here there are is no option to do that.
> in advance i'll appreciatte all your help.
> Edmundo J. Davila|||Strange. I just tried the URL and it took me to the below topic:
How to: Install SQL Server 2005 from the Command Prompt
In there (towards the end) there's a sample on how to rebuild. Or are you saying that the START
command that I pasted (after adjustment) took you to add/Remove programs?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
> Tibor,
> That instruction send me to the add/remove programs, and as i said, there is not option to rebuild
> master database from there.
> Edmundo J. Davila
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió en el mensaje de
> noticias news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine
>> REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005 without installing SQL Server
>> again. I try from the command line, but it sends me to add/remove program, and from here there
>> are is no option to do that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>|||How about this link?
How to: Install SQL Server 2005 from the Command Prompt:
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
--
Ekrem Önsoy
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
> Tibor,
> That instruction send me to the add/remove programs, and as i said, there
> is not option to rebuild master database from there.
> Edmundo J. Davila
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> escribió en el mensaje de noticias
> news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName>
>> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005 without
>> installing SQL Server again. I try from the command line, but it sends
>> me to add/remove program, and from here there are is no option to do
>> that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>|||That is the same article as I posted, but I posted a local BOL URL...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:6F10DBDF-C18B-4C7F-9CC7-AC63878907D1@.microsoft.com...
> How about this link?
> How to: Install SQL Server 2005 from the Command Prompt:
> http://msdn2.microsoft.com/en-us/library/ms144259.aspx
> --
> Ekrem Önsoy
>
> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
> news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
>> Tibor,
>> That instruction send me to the add/remove programs, and as i said, there is not option to
>> rebuild master database from there.
>> Edmundo J. Davila
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió en el mensaje de
>> noticias news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine
>> REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005 without installing SQL Server
>> again. I try from the command line, but it sends me to add/remove program, and from here there
>> are is no option to do that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>>
>|||Yes Tibor I know, I just thought this link could direct him to the mentioned
web site as the link you gave didn't work for him as far as I see.
--
Ekrem Önsoy
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23fm8pD3JIHA.2064@.TK2MSFTNGP06.phx.gbl...
> That is the same article as I posted, but I posted a local BOL URL...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
> news:6F10DBDF-C18B-4C7F-9CC7-AC63878907D1@.microsoft.com...
>> How about this link?
>> How to: Install SQL Server 2005 from the Command Prompt:
>> http://msdn2.microsoft.com/en-us/library/ms144259.aspx
>> --
>> Ekrem Önsoy
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
>> Tibor,
>> That instruction send me to the add/remove programs, and as i said,
>> there is not option to rebuild master database from there.
>> Edmundo J. Davila
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
>> escribió en el mensaje de noticias
>> news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName>
>> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005
>> without installing SQL Server again. I try from the command line, but
>> it sends me to add/remove program, and from here there are is no
>> option to do that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>>
>|||OK, got it. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:5667FAAD-2499-41BF-AF08-6370F9453042@.microsoft.com...
> Yes Tibor I know, I just thought this link could direct him to the mentioned web site as the link
> you gave didn't work for him as far as I see.
> --
> Ekrem Önsoy
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%23fm8pD3JIHA.2064@.TK2MSFTNGP06.phx.gbl...
>> That is the same article as I posted, but I posted a local BOL URL...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
>> news:6F10DBDF-C18B-4C7F-9CC7-AC63878907D1@.microsoft.com...
>> How about this link?
>> How to: Install SQL Server 2005 from the Command Prompt:
>> http://msdn2.microsoft.com/en-us/library/ms144259.aspx
>> --
>> Ekrem Önsoy
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
>> Tibor,
>> That instruction send me to the add/remove programs, and as i said, there is not option to
>> rebuild master database from there.
>> Edmundo J. Davila
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió en el mensaje de
>> noticias news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine
>> REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005 without installing SQL
>> Server again. I try from the command line, but it sends me to add/remove program, and from
>> here there are is no option to do that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>>
>>
>|||Unfortunatelly I had to remove and reinstall the instance from add/remove
programs from the control panel. It was impossible to do it with your
recommendations.
I appreciatte your help.
Regards,
Edmundo J. Davila
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió
en el mensaje de noticias news:eOZc3a3JIHA.2480@.TK2MSFTNGP05.phx.gbl...
> OK, got it. :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
> news:5667FAAD-2499-41BF-AF08-6370F9453042@.microsoft.com...
>> Yes Tibor I know, I just thought this link could direct him to the
>> mentioned web site as the link you gave didn't work for him as far as I
>> see.
>> --
>> Ekrem Önsoy
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:%23fm8pD3JIHA.2064@.TK2MSFTNGP06.phx.gbl...
>> That is the same article as I posted, but I posted a local BOL URL...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
>> news:6F10DBDF-C18B-4C7F-9CC7-AC63878907D1@.microsoft.com...
>> How about this link?
>> How to: Install SQL Server 2005 from the Command Prompt:
>> http://msdn2.microsoft.com/en-us/library/ms144259.aspx
>> --
>> Ekrem Önsoy
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
>> Tibor,
>> That instruction send me to the add/remove programs, and as i said,
>> there is not option to rebuild master database from there.
>> Edmundo J. Davila
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
>> escribió en el mensaje de noticias
>> news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn
>> INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1
>> SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>>> hi,
>>> is there a way to rebuild the master database in sql server 2005
>>> without installing SQL Server again. I try from the command line,
>>> but it sends me to add/remove program, and from here there are is no
>>> option to do that.
>>>
>>> in advance i'll appreciatte all your help.
>>>
>>> Edmundo J. Davila
>>
>>
>>
>