Saturday, February 25, 2012

MSSQL to Oracle

hello,

I built my application using SQLClient classes and MSSQL database

i have another version of the database with Oracle, is changing to OracleClient classes the only change i have to do in order to run the program and the connection string?

Thanks

Nope...You also have to install the Oracle client, and give the accountthat your ASP.Net application is running under access to the directorythat the Oracle client is in.

MSSQL Stored procedure Query using SELECT TOP

Is there a way to do a SELECT TOP # using a variable for the #?

In other words I'm doing a SELECT TOP 50* FROM DATATABLE

If I pass an @.value for the number

SELECT TOP @.value* FROM DATATABLE doesn't work

I am generating a random sampling of data and I want to allow the user to select the number of results they choose to have.

Thanks in advance.

I believe that is possible in 2005 and not in 2000. You can however use SET ROWCOUNT in 2000.

DECLARE @.tintSET @.t = 10SET ROWCOUNT @.tSELECT *FROM YourTableSET ROWCOUNT 0

|||

In 2005, the following works:

DECLARE @.t int
SET @.t = 20
SELECT TOP(@.t) * FROM yourTable

MSSQL status icon

Is there a method to prohibit the server icon (the one with the computer case
and a green arrow) from appearing in the status area of the taskbar? I’m
attempting to lockdown a terminal services desktop and want to avoid a
curious user from playing point and click with the icon.
Many thanks for all of you being there to help.
SQL 2000 running on a 2003 server.
Remove it from the startup group.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:5F8F1072-2D0B-490D-9F7B-69B899ACCFF4@.microsoft.com...
> Is there a method to prohibit the server icon (the one with the computer case
> and a green arrow) from appearing in the status area of the taskbar? I'm
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>
|||Hi coenzyme,
Remove it out of the Programs\Startup menu for users.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"coenzyme" wrote:

> Is there a method to prohibit the server icon (the one with the computer case
> and a green arrow) from appearing in the status area of the taskbar? I’m
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>

MSSQL status icon

Is there a method to prohibit the server icon (the one with the computer cas
e
and a green arrow) from appearing in the status area of the taskbar? I’m
attempting to lockdown a terminal services desktop and want to avoid a
curious user from playing point and click with the icon.
Many thanks for all of you being there to help.
SQL 2000 running on a 2003 server.Remove it from the startup group.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:5F8F1072-2D0B-490D-9F7B-69B899ACCFF4@.microsoft.com...
> Is there a method to prohibit the server icon (the one with the computer c
ase
> and a green arrow) from appearing in the status area of the taskbar? I'm
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>|||Hi coenzyme,
Remove it out of the Programs\Startup menu for users.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"coenzyme" wrote:

> Is there a method to prohibit the server icon (the one with the computer c
ase
> and a green arrow) from appearing in the status area of the taskbar? I’m
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>

MSSQL status icon

Is there a method to prohibit the server icon (the one with the computer case
and a green arrow) from appearing in the status area of the taskbar? Iâ'm
attempting to lockdown a terminal services desktop and want to avoid a
curious user from playing point and click with the icon.
Many thanks for all of you being there to help.
SQL 2000 running on a 2003 server.Remove it from the startup group.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:5F8F1072-2D0B-490D-9F7B-69B899ACCFF4@.microsoft.com...
> Is there a method to prohibit the server icon (the one with the computer case
> and a green arrow) from appearing in the status area of the taskbar? I'm
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>|||Hi coenzyme,
Remove it out of the Programs\Startup menu for users.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"coenzyme" wrote:
> Is there a method to prohibit the server icon (the one with the computer case
> and a green arrow) from appearing in the status area of the taskbar? Iâ'm
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>

MSsql Standard connect error

Hello
I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
instance name "mssql" ( hostname ="DBServer". Now I can only connect
from localhost with path "DBServer\mssql". From all other computers in
my network i cannot connect ( error "Mssql server does not exist...").
I cant even connect from localhost with path "localhost\mssql".
Previous I had Mssql 2000 Developer Edition installed on other Win2003
SP1 and I had no problems with connecting.
What can be wrong ?
Best Regards
Wojciech Znaniecki
Is SP3 or higher installed on the Win2K3 server? Is the instance listening
on TCP? Check the SQL Server errorlog to find out...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"wojtas_z" <wojtas_z@.poczta.fm> wrote in message
news:1131012588.047990.42900@.g14g2000cwa.googlegro ups.com...
> Hello
> I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
> instance name "mssql" ( hostname ="DBServer". Now I can only connect
> from localhost with path "DBServer\mssql". From all other computers in
> my network i cannot connect ( error "Mssql server does not exist...").
> I cant even connect from localhost with path "localhost\mssql".
> Previous I had Mssql 2000 Developer Edition installed on other Win2003
> SP1 and I had no problems with connecting.
> What can be wrong ?
> Best Regards
> Wojciech Znaniecki
>

MSsql Standard connect error

Hello
I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
instance name "mssql" ( hostname ="DBServer". Now I can only connect
from localhost with path "DBServer\mssql". From all other computers in
my network i cannot connect ( error "Mssql server does not exist...").
I cant even connect from localhost with path "localhost\mssql".
Previous I had Mssql 2000 Developer Edition installed on other Win2003
SP1 and I had no problems with connecting.
What can be wrong ?
Best Regards
Wojciech ZnanieckiIs SP3 or higher installed on the Win2K3 server? Is the instance listening
on TCP? Check the SQL Server errorlog to find out...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"wojtas_z" <wojtas_z@.poczta.fm> wrote in message
news:1131012588.047990.42900@.g14g2000cwa.googlegroups.com...
> Hello
> I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
> instance name "mssql" ( hostname ="DBServer". Now I can only connect
> from localhost with path "DBServer\mssql". From all other computers in
> my network i cannot connect ( error "Mssql server does not exist...").
> I cant even connect from localhost with path "localhost\mssql".
> Previous I had Mssql 2000 Developer Edition installed on other Win2003
> SP1 and I had no problems with connecting.
> What can be wrong ?
> Best Regards
> Wojciech Znaniecki
>

MS-SQL SQL to Access SQL

I have some SQL that looks like this (see below) it is for MySQL and MS-SQL (so I am told) however I need to impliment the data structure in Access. I have written a VBscript Class that converts and adds all the tables etc but the constraints are not going to work.

My script can strip out the "[dbo]." that access doesn't need but what I need to get any further is to reconstruct this SQL (See below) so that I have SQL that does the same thing in Access.

Once there I can create a few string manipulations to transform it and bingo job done.

I need some help as I am very weak in the ALTER TABLE department.
ALTER TABLE [dbo].[openwiki_macrohelp] ADD
CONSTRAINT [DF__openwiki___macro__7908F585] DEFAULT (1) FOR [macro_builtin],
CONSTRAINT [DF__openwiki___macro__79FD19BE] DEFAULT (0) FOR [macro_numparams],
CONSTRAINT [DF__openwiki___macro__7AF13DF7] DEFAULT ('No description available') FOR [macro_description],
CONSTRAINT [DF__openwiki___macro__7BE56230] DEFAULT ('None') FOR [macro_param1],
CONSTRAINT [DF__openwiki___macro__7CD98669] DEFAULT ('None') FOR [macro_param2],
CONSTRAINT [DF__openwiki___macro__7DCDAAA2] DEFAULT ('None') FOR [macro_param3],
CONSTRAINT [DF__openwiki___macro__7EC1CEDB] DEFAULT ('None') FOR [macro_comment]
GOI can't see why you'd need any code in MS-Access. Just set the default values specified using the MS-Access GUI, and it should handle the rest for you.

While MS-Access doesn't scale well compared to MS-SQL, it certainly is easier to use!

-PatP

MSSQL SPROC and VB6

I wrote the following SPROC and it works the first time i run it. But if I attempt to run it again I get the following T-SQL Error: "There is not enough memory to complete the task. Close down some operations and try again". Then the app closes. Any ideas?

Here is my complete code:

USE IADATA
IF EXISTS (select * from syscomments where id = object_id ('TestSP'))
DROP PROCEDURE TestSP

GO
CREATE PROCEDURE TestSP
/*Declare Variables*/
@.ListStr varchar(100) /*Hold Delimited String*/
AS
Set NoCount On
DECLARE @.ListTbl Table (InvUnit varchar(50)) /*Creates Temp Table*/
DECLARE @.CP int /*Len of String */
DECLARE @.SV varchar(50) /*Holds Result */

While @.ListStr<>''
Begin
Set @.CP=CharIndex(',',@.ListStr) /*Sets length of words - Instr */
If @.CP<>0
Begin
Set @.SV=Cast(Left(@.ListStr,@.CP-1) as varchar) /*Copies Portion of String*/
Set @.ListStr=Right(@.ListStr,Len(@.ListStr)-@.CP) /*Sets up next portion of string*/
End
Else
Begin
Set @.SV=Cast(@.ListStr as varchar)
Set @.ListStr=''
End
Insert into @.ListTbl Values (@.SV) /*Inserts variable into Temp Table*/
End

Select InvUnit From @.ListTbl LT
INNER Join dbo.Incidents ST on ST.Inv_Unit=LT.InvUnit

and my VB6 Code:

Dim adoConn As ADODB.Connection
Dim adoCmd As ADODB.Command
Dim adoRS As ADODB.Recordset
Dim strLegend As String
Dim strData As String

Set adoConn = New ADODB.Connection
adoConn.Open connString

Set adoRS = New ADODB.Recordset
Set adoCmd = New ADODB.Command

With adoCmd
Set .ActiveConnection = adoConn
.CommandText = "TestSP"
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter("ListStr", adVarChar, adParamInput, 100)
.Parameters("ListStr").Value = "Unit 41,Unit 32,Unit 34,Unit 54"

Set adoRS = .Execute

Do While Not adoRS.EOF
Debug.Print adoRS.Fields(0).Value
adoRS.MoveNext
Loop

End With

Set adoCmd = Nothing
adoRS.Close
Set adoRS = Nothing
Set adoCmd = Nothing
adoConn.Close
Set adoConn = Nothing

End Sub

Any ideas?

ThanksWhat is the edition of SQL used and its memory settings?
Is SQL Server shared by other applications?|||Thanks for the reply my problem was resolved (http://vbforums.com/showthread.php?t=405134)

MsSQL Software

is there any free web apps out there that can interface with an SQL Server in real time, like add, edit, delete, update and search the DB?Ummm yeah, any ideas?|||There's always Query Analyzer, the free query tool that ships with MS-SQL Server. Free to use as long as the server you connect to is licensed.

If you're looking for a non-MS tool, just google 'SQL Query tool' and you'll find lots of stuff or check tucows.|||Originally posted by loach
There's always Query Analyzer, the free query tool that ships with MS-SQL Server. Free to use as long as the server you connect to is licensed.

If you're looking for a non-MS tool, just google 'SQL Query tool' and you'll find lots of stuff or check tucows.

Thats not what I am talkin about, I dont want to find an SQL Query tool, I want a full GUI interface to control the DB. All the programs I found in google to view and export data. I dont want a program that just lets you control the DB via SQL statements alone...|||I guess I don't really understand what you're looking for. What is it that you're looking for that Enterprise Manager does not do?|||Originally posted by sabastious
Thats not what I am talkin about, I dont want to find an SQL Query tool, I want a full GUI interface to control the DB. All the programs I found in google to view and export data. I dont want a program that just lets you control the DB via SQL statements alone...

Hello.

See if this help... I have not tried it myself yet.

http://www.msde.biz/msdequery/download.htm|||Originally posted by sabastious
is there any free web apps out there that can interface with an SQL Server in real time, like add, edit, delete, update and search the DB?

myLittleAdmin : http://www.myLittleTools.net/mla_sql

This is a web-based GUI for MS Sql.

best regards|||You can link to your SQL Server database via a Microsoft Access database Access Data Project (.adp file extension) and control many things such as table, view, and procedure creation as well as data manipulation. It acts like a stripped down Enterprise Manager.

But again, why not just use Enterprise Manager?

blindman

MSSQL SNMP

Is there a way to set up MSSQL's SNMP counters if MSSQL was installed before
the SNMP service?
-Walt Zydhek
Hi,
Study this in BOL
SNMP, enabling support
Hope this help u
Killer
|||I read that, and it only applies to windows 98. SQL server is installed on a
windows 20003 server machine. I also could not find any
Tools\Reskit\Netadmin\Snmp directory either on the cd, the sp3a cd, nor
anywhere on the server.
-Walt Zydhek
"doller" <sufianarif@.gmail.com> wrote in message
news:1124516625.450996.285640@.g47g2000cwa.googlegr oups.com...
> Hi,
> Study this in BOL
> SNMP, enabling support
> Hope this help u
> Killer
>
|||Hi
I have the same problem and I have tried to removed the sql installation and
reinstalled it again but I am still not able to use the snmp feature. It's
not visual in the SQL Network Server Utility.
Isn't there anyone that have an regedit solution for this problem ?
I have tested it on Windows 2000srvSP4 and also tested it with Windows2003
and also tested it with SQL SP3 and SQL SP4...
// Daniel Olsson
"Walter Zydhek" wrote:

> Is there a way to set up MSSQL's SNMP counters if MSSQL was installed before
> the SNMP service?
> -Walt Zydhek
>
>

MSSQL SNMP

Is there a way to set up MSSQL's SNMP counters if MSSQL was installed before
the SNMP service?
-Walt ZydhekHi,
Study this in BOL
SNMP, enabling support
Hope this help u
Killer|||I read that, and it only applies to windows 98. SQL server is installed on a
windows 20003 server machine. I also could not find any
Tools\Reskit\Netadmin\Snmp directory either on the cd, the sp3a cd, nor
anywhere on the server.
-Walt Zydhek
"doller" <sufianarif@.gmail.com> wrote in message
news:1124516625.450996.285640@.g47g2000cwa.googlegroups.com...
> Hi,
> Study this in BOL
> SNMP, enabling support
> Hope this help u
> Killer
>|||Hi
I have the same problem and I have tried to removed the sql installation and
reinstalled it again but I am still not able to use the snmp feature. It's
not visual in the SQL Network Server Utility.
Isn't there anyone that have an regedit solution for this problem ?
I have tested it on Windows 2000srvSP4 and also tested it with Windows2003
and also tested it with SQL SP3 and SQL SP4...
// Daniel Olsson
"Walter Zydhek" wrote:

> Is there a way to set up MSSQL's SNMP counters if MSSQL was installed befo
re
> the SNMP service?
> -Walt Zydhek
>
>

MSSQL SNMP

Is there a way to set up MSSQL's SNMP counters if MSSQL was installed before
the SNMP service?
-Walt ZydhekHi,
Study this in BOL
SNMP, enabling support
Hope this help u
Killer|||I read that, and it only applies to windows 98. SQL server is installed on a
windows 20003 server machine. I also could not find any
Tools\Reskit\Netadmin\Snmp directory either on the cd, the sp3a cd, nor
anywhere on the server.
-Walt Zydhek
"doller" <sufianarif@.gmail.com> wrote in message
news:1124516625.450996.285640@.g47g2000cwa.googlegroups.com...
> Hi,
> Study this in BOL
> SNMP, enabling support
> Hope this help u
> Killer
>|||Hi
I have the same problem and I have tried to removed the sql installation and
reinstalled it again but I am still not able to use the snmp feature. It's
not visual in the SQL Network Server Utility.
Isn't there anyone that have an regedit solution for this problem ?
I have tested it on Windows 2000srvSP4 and also tested it with Windows2003
and also tested it with SQL SP3 and SQL SP4...
// Daniel Olsson
"Walter Zydhek" wrote:
> Is there a way to set up MSSQL's SNMP counters if MSSQL was installed before
> the SNMP service?
> -Walt Zydhek
>
>

MSSQL Slowing Down until unusable.

Over time, MSSQL seems to get slower and slower until we cannot even log into the db list using Enterprise Manager.
We are using:
Win2k Pro SP3
2 @. 1ghz Pentium processors
2 gig RAM
143 GB Disk space 3 hot swap Raid 5

It seems in time the speed of the server slows until it almost becomes unusable. We run Optimization and Integrity checks without errors once a week. There are about 300 databases on the server, the largest being about 1.5 gig. Full backup every night.
Our web applications are used during the day (bulk insert is used alot by the web application) so I logged in to the server at about 3am to find the high memory use and Page Faults at over 1.5 million. This is while the server is getting no queries. I watched as the page faults just continually increased at about 100 to 200 per second.
We eventually have to move to the backup server, re-build the server and it will be good for a few months. Any suggestions or ideas?Originally posted by tpmcmaho
Over time, MSSQL seems to get slower and slower until we cannot even log into the db list using Enterprise Manager.
We are using:
Win2k Pro SP3
2 @. 1ghz Pentium processors
2 gig RAM
143 GB Disk space 3 hot swap Raid 5

It seems in time the speed of the server slows until it almost becomes unusable. We run Optimization and Integrity checks without errors once a week. There are about 300 databases on the server, the largest being about 1.5 gig. Full backup every night.
Our web applications are used during the day (bulk insert is used alot by the web application) so I logged in to the server at about 3am to find the high memory use and Page Faults at over 1.5 million. This is while the server is getting no queries. I watched as the page faults just continually increased at about 100 to 200 per second.
We eventually have to move to the backup server, re-build the server and it will be good for a few months. Any suggestions or ideas?

did you dump transaction log after Full Backup?|||Thanks for the reply...

No, I did not dump the transaction log files on the databases.

DB maint. is from the standard wizard:
-Reorganize data and index pages
-Optimize w/remove unused space from database files
-Check Integrity w/include indexes, attempt repair

Data and Trans. files are set to grow automatically by 10% unrestricted.
Options inlcude Auto Shrink.

Thank you!|||As far as autoshrink option is set to true it may hamper ur speed b'coz as soon as it gets shrunk again it starts increase to its default size which is required for the database for its manipulation.
In brief again it consumes ur resources .
This overhead u can avoid by autoshrink to manually when there is very less workload on sql server like (break).
2nd option could be problem with indexes which are clustured do u check showcntig reports scan density page density etc if not pl go through it it may give u some improvements in performance after running indexdefrag followed by index name.
there are some more options which i can tell u may be after getting -ve some reply from u .

MSSQL Slow Queries on One Database only all others fine.

Hello Everyone,

I have a strange problem that I cannot seem to solve. I have two server running Windows 2003 MSSQL on one IIS on the other.

Out of the blue I have slow queries that cause asp script timeouts and I cannot figure it out. I have moved some test code to other sites on the server and still have these long delays.

I have tried dropping the tables, then the database entirely and restoring and still slow. I run the same code on my test server at home running both iis and sql on the same server and it is a little slow but not too bad and the test server is a duron 1.6.

Here it is:
Code: ( text )

    <!-- #include file="adovbs.inc" --> <% response.write("<table width=100% border=0>") response.write("<tr><td align=left>") Set dbconn = Server.CreateObject("ADODB.Connection") dbconn.Open database_three dbconn.CommandTimeout = 0 Set group_master = Server.CreateObject("ADODB.Recordset") Set section_master = Server.CreateObject("ADODB.Recordset") Set document_master = Server.CreateObject("ADODB.Recordset") group_master.open "SELECT * FROM group_master",dbconn,adOpenForwardOnly,adLockReadOnly Do while not group_master.EOF group_number = clng(group_master("group_number")) group_title = group_master("group_title") group_description = group_master("group_description") group_stat = group_master("group_status") response.write("<table width=100% border=0>") If group_stat = "A" Then response.write("<tr><td align=left colspan=3 CLASS=activegroup>" & group_title & "</td></tr>") If group_stat = "O" Then response.write("<tr><td align=left colspan=3 CLASS=obsoletegroup>" & group_title & "</td></tr>") response.write("<tr><td align=justify colspan=3 CLASS=groupdescription>" & group_description & "</td></tr>") section_master.open "SELECT * FROM section_master where group_number=" & group_number,dbconn,adOpenForwardOnly,adLockReadOn ly If not section_master.EOF Then Do while not section_master.EOF sec_no = clng(section_master("section_number")) If section_master("section_status") = "A" Then response.write("<tr><td></td><td align=left colspan=2 class=activesection><font color=black><strong>" & x & ".</strong></font> " & section_master("section_title") & "</td></tr>") If section_master("section_status") = "O" Then response.write("<tr><td></td><td align=left colspan=2 class=obsoletesection><font color=black><strong>" & x & ".</strong></font> " & section_master("section_title") & "</td></tr>") response.write("<tr><td></td><td align=justify colspan=2 class=sectiondescription><font color=white><strong>" & x & ".</strong></font> " & section_master("section_description") & "</td></tr>") document_master.open "SELECT * FROM document_master where group_number=" & group_number & " and section_number=" & sec_no & " ORDER BY document_seq",dbconn,adOpenForwardOnly,adLockReadOnly If not document_master.EOF Then Do while not document_master.EOF If document_master("document_status") = "A" Then response.write("<tr><td></td><td></td><td align=left CLASS=activedocument><font color=black><strong>" & formatnumber(document_master("document_seq"),2) & "</strong></font> " & document_master("document_title") & "</td></tr>") If document_master("document_status") = "O" Then response.write("<tr><td></td><td></td><td align=left CLASS=obsoletedocument><font color=black><strong>" & formatnumber(document_master("document_seq"),2) & "</strong></font> " & document_master("document_title") & "</td></tr>") response.write("<tr><td></td><td></td><td align=left CLASS=documentdescirption><font color=white><strong>" & formatnumber(document_master("document_seq"),2) & "</strong></font> " & document_master("document_details") & "</td></tr>") document_master.MoveNext Loop document_master.Close Else document_master.close End If ' Make sure there are documents to loop thru. section_master.MoveNext Loop section_master.Close Else section_master.Close End If ' Make sure there was sections to look at. group_master.MoveNext Loopresponse.write("</td></tr></table></td></tr></table>") dbconn.Close Set dbconn = Nothing Set group_master = Nothing Set section_master = Nothing Set document_master = Nothing %>

Keep in mind nothing about my code has changed so it must be something on the server like maybe a security setting or routing issue, I just can't figure out what could have MAGICALLY changed. I am not the only admin on the servers but everyone says they changed nothing. Any help would be GREATLY appreciated.Is it possible that you just have more data then before?
Do you have indexes on your tables?|||Yeah I do have index's. I also ran the optimizer.

The data has not changed, it is only updated as we add documents and none have been added for a couple of months.

Its not really that much data.

MSSQL setting

Hi All,
we will have another server to be set up as DB server, we currently have another SQL server, we want the 2 server have same
settings, how can i do this or any tools can help to do this? thanks all
Hi,
I understood that there must be various third party tools available,
however, I would love to recommend you the following Knowledge Base
articles to do the job
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/kb/314546
This step-by-step article describes how to move SQL Server user databases
and most common SQL Server components between computers that are running
SQL Server.
Hope this helps.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

MSSQL setting

Hi All,
we will have another server to be set up as DB server, we currently have another SQL server, we want the 2 server have same
settings, how can i do this or any tools can help to do this? thanks allHi,
I understood that there must be various third party tools available,
however, I would love to recommend you the following Knowledge Base
articles to do the job
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/kb/314546
This step-by-step article describes how to move SQL Server user databases
and most common SQL Server components between computers that are running
SQL Server.
Hope this helps.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

MSSQL setting

Hi All,
we will have another server to be set up as DB server, we currently have ano
ther SQL server, we want the 2 server have same
settings, how can i do this or any tools can help to do this? thanks allHi,
I understood that there must be various third party tools available,
however, I would love to recommend you the following Knowledge Base
articles to do the job
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/kb/314546
This step-by-step article describes how to move SQL Server user databases
and most common SQL Server components between computers that are running
SQL Server.
Hope this helps.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

mssql service manager don't start

after a black out mssqlservice doesn't start also if i try to start it manually
it say no errors or alert windows just return to stop status after few second
have an idea?
i don't know much about mssql this program is used only by my main
billing/accountacy program
thank you for your answer
exscuse for my bad english i am italian
Stivi,
I'm not sure that the problem have something to do with this but i think you
can try.
Sometimes happens that the account used with mssqlservice is not well
configured.
Use Services in the administrative tools to see wich account is used to
authenticate mssqlservice. This account must have administrative permissions
in the machine and the password must not expire or be changed by anyone.
after verifying this try to restart the service.
"stivi" wrote:

> after a black out mssqlservice doesn't start also if i try to start it manually
> it say no errors or alert windows just return to stop status after few second
> have an idea?
> i don't know much about mssql this program is used only by my main
> billing/accountacy program
> thank you for your answer
> exscuse for my bad english i am italian
|||Check the application and system event logs to see why the service
isn't starting. If your server didn't have a UPS then the abrupt
shutdown could've damaged files on the hard drive. As a consequence
the service encounters a damaged file and is unable to start.
Hopefully you (or your system administrator) can fix the
problem...otherwise, be prepared to uninstall/reinstall SQL Server
:-(.
On Sat, 26 Nov 2005 03:56:01 -0800, "stivi"
<stivi@.discussions.microsoft.com> wrote:

>after a black out mssqlservice doesn't start also if i try to start it manually
>it say no errors or alert windows just return to stop status after few second
>have an idea?
>i don't know much about mssql this program is used only by my main
>billing/accountacy program
>thank you for your answer
>exscuse for my bad english i am italian

mssql service manager don't start

after a black out mssqlservice doesn't start also if i try to start it manua
lly
it say no errors or alert windows just return to stop status after few secon
d
have an idea?
i don't know much about mssql this program is used only by my main
billing/accountacy program
thank you for your answer
exscuse for my bad english i am italianStivi,
I'm not sure that the problem have something to do with this but i think you
can try.
Sometimes happens that the account used with mssqlservice is not well
configured.
Use Services in the administrative tools to see wich account is used to
authenticate mssqlservice. This account must have administrative permissions
in the machine and the password must not expire or be changed by anyone.
after verifying this try to restart the service.
"stivi" wrote:

> after a black out mssqlservice doesn't start also if i try to start it man
ually
> it say no errors or alert windows just return to stop status after few sec
ond
> have an idea?
> i don't know much about mssql this program is used only by my main
> billing/accountacy program
> thank you for your answer
> exscuse for my bad english i am italian|||Check the application and system event logs to see why the service
isn't starting. If your server didn't have a UPS then the abrupt
shutdown could've damaged files on the hard drive. As a consequence
the service encounters a damaged file and is unable to start.
Hopefully you (or your system administrator) can fix the
problem...otherwise, be prepared to uninstall/reinstall SQL Server
:-(.
On Sat, 26 Nov 2005 03:56:01 -0800, "stivi"
<stivi@.discussions.microsoft.com> wrote:

>after a black out mssqlservice doesn't start also if i try to start it manu
ally
>it say no errors or alert windows just return to stop status after few seco
nd
>have an idea?
>i don't know much about mssql this program is used only by my main
>billing/accountacy program
>thank you for your answer
>exscuse for my bad english i am italian

mssql service manager don't start

after a black out mssqlservice doesn't start also if i try to start it manually
it say no errors or alert windows just return to stop status after few second
have an idea?
i don't know much about mssql this program is used only by my main
billing/accountacy program
thank you for your answer
exscuse for my bad english i am italianStivi,
I'm not sure that the problem have something to do with this but i think you
can try.
Sometimes happens that the account used with mssqlservice is not well
configured.
Use Services in the administrative tools to see wich account is used to
authenticate mssqlservice. This account must have administrative permissions
in the machine and the password must not expire or be changed by anyone.
after verifying this try to restart the service.
"stivi" wrote:
> after a black out mssqlservice doesn't start also if i try to start it manually
> it say no errors or alert windows just return to stop status after few second
> have an idea?
> i don't know much about mssql this program is used only by my main
> billing/accountacy program
> thank you for your answer
> exscuse for my bad english i am italian|||Check the application and system event logs to see why the service
isn't starting. If your server didn't have a UPS then the abrupt
shutdown could've damaged files on the hard drive. As a consequence
the service encounters a damaged file and is unable to start.
Hopefully you (or your system administrator) can fix the
problem...otherwise, be prepared to uninstall/reinstall SQL Server
:-(.
On Sat, 26 Nov 2005 03:56:01 -0800, "stivi"
<stivi@.discussions.microsoft.com> wrote:
>after a black out mssqlservice doesn't start also if i try to start it manually
>it say no errors or alert windows just return to stop status after few second
>have an idea?
>i don't know much about mssql this program is used only by my main
>billing/accountacy program
>thank you for your answer
>exscuse for my bad english i am italian

MSSQL Server Taskbar Icon

I just upgraded Win2000 to SP4 from SP3. I have SQL2000
Server on the a DELL 2600 PowerEdge and it was working
wonderfully. After the upgrade the green arrow on the icon
in the taskbar is missing. When I double click on the
icon, the server name is present but no services to
start. I checked services in Administrator Tools and they
are present and started. I can connect to the MSSQL
Server in Enterprise Manager and Query Analyzer. I
stopped and restarted the services in Administrator Tools
with no luck and rebooted. Any ideas'?Just wondering if the SQL Service Manager has lost focus from your machine
and is looking at a machine that doesn't have SQL installed.
Open the SQL Service Manager, ensure the Server :- pull down list is focused
on the correct machine.
--
HTH
Ryan Waight, MCDBA, MCSE
"Kerry" <kerry.ross@.wheelsus.gknplc.com> wrote in message
news:067c01c38a03$498ba790$a301280a@.phx.gbl...
> I just upgraded Win2000 to SP4 from SP3. I have SQL2000
> Server on the a DELL 2600 PowerEdge and it was working
> wonderfully. After the upgrade the green arrow on the icon
> in the taskbar is missing. When I double click on the
> icon, the server name is present but no services to
> start. I checked services in Administrator Tools and they
> are present and started. I can connect to the MSSQL
> Server in Enterprise Manager and Query Analyzer. I
> stopped and restarted the services in Administrator Tools
> with no luck and rebooted. Any ideas'?

mssql server started and then stopped

I have a problem with all mssql servers in the domain that is unable to
start
The error is
the mssql server started and then stopped. All mssql service is started
with the local system account
any idea?
ERROR.LOG contains something? Event Viewer?
"nobody" <nobody@.nobody.com> wrote in message
news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>I have a problem with all mssql servers in the domain that is unable to
>start
> The error is
> the mssql server started and then stopped. All mssql service is started
> with the local system account
>
> any idea?
>
|||didnt see anything in event viewer but error.log in mssql\log shows this
2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-11-13 06:40:43.76 server All rights reserved.
2007-11-13 06:40:43.76 server Server Process ID is 2448.
2007-11-13 06:40:43.76 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
2007-11-13 06:40:43.77 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2007-11-13 06:40:43.81 server SQL Server configured for thread mode
processing.
2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
I am not doing any restores
please help
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
> ERROR.LOG contains something? Event Viewer?
>
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>
|||Hi
Peraphs it got corrupted.Do you have a backup?
/*
Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
*/
"nobody" <nobody@.nobody.com> wrote in message
news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
> didnt see anything in event viewer but error.log in mssql\log shows this
>
> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-11-13 06:40:43.76 server All rights reserved.
> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
> 2007-11-13 06:40:43.77 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).
> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
> processing.
> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500] Lock
> Blocks, [1000] Lock Owner Blocks.
> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in the middle of a restore.
>
> I am not doing any restores
> please help
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>
|||the thing is several mssql on the same domain is failing to start. I think
it might have to do with backup exec backups failed last night.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
> Hi
> Peraphs it got corrupted.Do you have a backup?
> /*
> Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in
> the middle of a restore.
> */
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>
|||The problem is I did not do any restores. In backup exec I backed up the
databases but selected the option (continue backup if consistency check
fails)
"Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
> Also, there is a KB about this problem, you may want to read it.
> http://support.microsoft.com/kb/822852
> --
> Ekrem nsoy
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
>
|||how do I run dbcc from query analyzer? I have another machine failed to
start sql. I believe this had to do with backup exec
"nobody" <nobody@.nobody.com> wrote in message
news:uFm1nphJIHA.5208@.TK2MSFTNGP04.phx.gbl...
> The problem is I did not do any restores. In backup exec I backed up the
> databases but selected the option (continue backup if consistency check
> fails)
>
> "Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
> news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
>

mssql server started and then stopped

I have a problem with all mssql servers in the domain that is unable to
start
The error is
the mssql server started and then stopped. All mssql service is started
with the local system account
any idea?ERROR.LOG contains something? Event Viewer?
"nobody" <nobody@.nobody.com> wrote in message
news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>I have a problem with all mssql servers in the domain that is unable to
>start
> The error is
> the mssql server started and then stopped. All mssql service is started
> with the local system account
>
> any idea?
>|||didnt see anything in event viewer but error.log in mssql\log shows this
2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-11-13 06:40:43.76 server All rights reserved.
2007-11-13 06:40:43.76 server Server Process ID is 2448.
2007-11-13 06:40:43.76 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
2007-11-13 06:40:43.77 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2007-11-13 06:40:43.81 server SQL Server configured for thread mode
processing.
2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
I am not doing any restores
please help
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
> ERROR.LOG contains something? Event Viewer?
>
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable to
>>start
>> The error is
>> the mssql server started and then stopped. All mssql service is started
>> with the local system account
>>
>> any idea?
>|||Hi
Peraphs it got corrupted.Do you have a backup?
/*
Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
*/
"nobody" <nobody@.nobody.com> wrote in message
news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
> didnt see anything in event viewer but error.log in mssql\log shows this
>
> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-11-13 06:40:43.76 server All rights reserved.
> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
> 2007-11-13 06:40:43.77 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).
> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
> processing.
> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500] Lock
> Blocks, [1000] Lock Owner Blocks.
> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in the middle of a restore.
>
> I am not doing any restores
> please help
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable to
>>start
>> The error is
>> the mssql server started and then stopped. All mssql service is started
>> with the local system account
>>
>> any idea?
>>
>|||the thing is several mssql on the same domain is failing to start. I think
it might have to do with backup exec backups failed last night.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
> Hi
> Peraphs it got corrupted.Do you have a backup?
> /*
> Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in
> the middle of a restore.
> */
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>> didnt see anything in event viewer but error.log in mssql\log shows this
>>
>> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2007-11-13 06:40:43.76 server All rights reserved.
>> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
>> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
>> 2007-11-13 06:40:43.77 server SQL Server is starting at priority class
>> 'normal'(1 CPU detected).
>> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
>> processing.
>> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
>> Lock Blocks, [1000] Lock Owner Blocks.
>> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
>> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
>> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
>> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
>> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
>> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
>> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
>> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
>> in the middle of a restore.
>>
>> I am not doing any restores
>> please help
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable to
>>start
>> The error is
>> the mssql server started and then stopped. All mssql service is
>> started with the local system account
>>
>> any idea?
>>
>>
>|||Also, there is a KB about this problem, you may want to read it.
http://support.microsoft.com/kb/822852
--
Ekrem Önsoy
"nobody" <nobody@.nobody.com> wrote in message
news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
> the thing is several mssql on the same domain is failing to start. I think
> it might have to do with backup exec backups failed last night.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> Peraphs it got corrupted.Do you have a backup?
>> /*
>> Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
>> in
>> the middle of a restore.
>> */
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>> didnt see anything in event viewer but error.log in mssql\log shows this
>>
>> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2007-11-13 06:40:43.76 server All rights reserved.
>> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
>> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
>> 2007-11-13 06:40:43.77 server SQL Server is starting at priority
>> class 'normal'(1 CPU detected).
>> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
>> processing.
>> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
>> Lock Blocks, [1000] Lock Owner Blocks.
>> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
>> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
>> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
>> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
>> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1:
>> 1310.
>> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
>> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
>> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in the middle of a restore.
>>
>> I am not doing any restores
>> please help
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable to
>>start
>> The error is
>> the mssql server started and then stopped. All mssql service is
>> started with the local system account
>>
>> any idea?
>>
>>
>>
>|||The problem is I did not do any restores. In backup exec I backed up the
databases but selected the option (continue backup if consistency check
fails)
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
> Also, there is a KB about this problem, you may want to read it.
> http://support.microsoft.com/kb/822852
> --
> Ekrem Önsoy
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
>> the thing is several mssql on the same domain is failing to start. I
>> think it might have to do with backup exec backups failed last night.
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> Peraphs it got corrupted.Do you have a backup?
>> /*
>> Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in
>> the middle of a restore.
>> */
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>> didnt see anything in event viewer but error.log in mssql\log shows
>> this
>>
>> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2007-11-13 06:40:43.76 server All rights reserved.
>> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
>> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
>> 2007-11-13 06:40:43.77 server SQL Server is starting at priority
>> class 'normal'(1 CPU detected).
>> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
>> processing.
>> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
>> Lock Blocks, [1000] Lock Owner Blocks.
>> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
>> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version
>> '8.0.760'.
>> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
>> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
>> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1:
>> 1310.
>> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 4
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 6
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 7
>> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
>> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database
>> 'model' because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in the middle of a restore.
>>
>> I am not doing any restores
>> please help
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable
>>to start
>> The error is
>> the mssql server started and then stopped. All mssql service is
>> started with the local system account
>>
>> any idea?
>>
>>
>>
>>
>|||how do I run dbcc from query analyzer? I have another machine failed to
start sql. I believe this had to do with backup exec
"nobody" <nobody@.nobody.com> wrote in message
news:uFm1nphJIHA.5208@.TK2MSFTNGP04.phx.gbl...
> The problem is I did not do any restores. In backup exec I backed up the
> databases but selected the option (continue backup if consistency check
> fails)
>
> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
> news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
>> Also, there is a KB about this problem, you may want to read it.
>> http://support.microsoft.com/kb/822852
>> --
>> Ekrem Önsoy
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
>> the thing is several mssql on the same domain is failing to start. I
>> think it might have to do with backup exec backups failed last night.
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> Peraphs it got corrupted.Do you have a backup?
>> /*
>> Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in
>> the middle of a restore.
>> */
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>> didnt see anything in event viewer but error.log in mssql\log shows
>> this
>>
>> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2007-11-13 06:40:43.76 server All rights reserved.
>> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
>> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
>> 2007-11-13 06:40:43.77 server SQL Server is starting at priority
>> class 'normal'(1 CPU detected).
>> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
>> processing.
>> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
>> Lock Blocks, [1000] Lock Owner Blocks.
>> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
>> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version
>> '8.0.760'.
>> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
>> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x:
>> 1310.
>> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1:
>> 1310.
>> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 4
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 6
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 7
>> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
>> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database
>> 'model' because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in the middle of a restore.
>>
>> I am not doing any restores
>> please help
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>>I have a problem with all mssql servers in the domain that is unable
>>>to start
>>>
>>> The error is
>>>
>>> the mssql server started and then stopped. All mssql service is
>>> started with the local system account
>>>
>>>
>>> any idea?
>>>
>>
>>
>>
>>
>

mssql server started and then stopped

I have a problem with all mssql servers in the domain that is unable to
start
The error is
the mssql server started and then stopped. All mssql service is started
with the local system account
any idea?ERROR.LOG contains something? Event Viewer?
"nobody" <nobody@.nobody.com> wrote in message
news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>I have a problem with all mssql servers in the domain that is unable to
>start
> The error is
> the mssql server started and then stopped. All mssql service is started
> with the local system account
>
> any idea?
>|||didnt see anything in event viewer but error.log in mssql\log shows this
2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-11-13 06:40:43.76 server All rights reserved.
2007-11-13 06:40:43.76 server Server Process ID is 2448.
2007-11-13 06:40:43.76 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
2007-11-13 06:40:43.77 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2007-11-13 06:40:43.81 server SQL Server configured for thread mode
processing.
2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500] Lo
ck
Blocks, [1000] Lock Owner Blocks.
2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
I am not doing any restores
please help
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
> ERROR.LOG contains something? Event Viewer?
>
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>|||Hi
Peraphs it got corrupted.Do you have a backup?
/*
Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
*/
"nobody" <nobody@.nobody.com> wrote in message
news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
> didnt see anything in event viewer but error.log in mssql\log shows this
>
> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-11-13 06:40:43.76 server All rights reserved.
> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
> 2007-11-13 06:40:43.77 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).
> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
> processing.
> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
Lock
> Blocks, [1000] Lock Owner Blocks.
> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in the middle of a restore.
>
> I am not doing any restores
> please help
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>|||the thing is several mssql on the same domain is failing to start. I think
it might have to do with backup exec backups failed last night.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
> Hi
> Peraphs it got corrupted.Do you have a backup?
> /*
> Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in
> the middle of a restore.
> */
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>|||Also, there is a KB about this problem, you may want to read it.
http://support.microsoft.com/kb/822852
Ekrem nsoy
"nobody" <nobody@.nobody.com> wrote in message
news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
> the thing is several mssql on the same domain is failing to start. I think
> it might have to do with backup exec backups failed last night.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
>|||The problem is I did not do any restores. In backup exec I backed up the
databases but selected the option (continue backup if consistency check
fails)
"Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
> Also, there is a KB about this problem, you may want to read it.
> http://support.microsoft.com/kb/822852
> --
> Ekrem nsoy
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
>|||how do I run dbcc from query analyzer? I have another machine failed to
start sql. I believe this had to do with backup exec
"nobody" <nobody@.nobody.com> wrote in message
news:uFm1nphJIHA.5208@.TK2MSFTNGP04.phx.gbl...
> The problem is I did not do any restores. In backup exec I backed up the
> databases but selected the option (continue backup if consistency check
> fails)
>
> "Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
> news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
>

MSSQL Server Recovery

Can you give us some indication on the status of your
server i.e. is it accessable.
Can you also give us some indication of your backups and
any replication.
Peter
"It's true hard work never killed anybody, but I figure,
why take the chance?"
Ronald Reagan

>--Original Message--
>Hi,
>The Windows 2000 Server (that has MSSQL Server
installed) is corrupted.
>Can anybody tell me how I can make the existing SQL data
files work in
>another Windows 2000 Server?
>What should I do?
>Thanks & Regards,
>KS
>
>.
>
Hi,
Due to I cannot log into Windows 2000 Server (installed by
ex-administrator),
I need to install a new Windows 2000 Server.
And transfer the existing data files to the new machine.
Regards,
KS
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:136701c48c22$49618100$a501280a@.phx.gbl...[vbcol=seagreen]
> Can you give us some indication on the status of your
> server i.e. is it accessable.
> Can you also give us some indication of your backups and
> any replication.
> Peter
> "It's true hard work never killed anybody, but I figure,
> why take the chance?"
> Ronald Reagan
>
> installed) is corrupted.
> files work in

MSSQL Server Recovery

Hi,
The Windows 2000 Server (that has MSSQL Server installed) is corrupted.
Can anybody tell me how I can make the existing SQL data files work in
another Windows 2000 Server?
What should I do?
Thanks & Regards,
KS
Hi KS !
You've got the data and log file ?
I've got the german EM, so don't know the exact names
of the menu items in english version of EM, but i'll try.
On your new SQL-Server EM:
Right-Click on Databases -> All Tasks -> Attach DB
then choose your mdf-file, and that's it. (Hope so!)
Hope these instructions help.
Let me know about it.
Best regards,
|||Smuddi wrote:
> Hi KS !
> You've got the data and log file ?
> I've got the german EM, so don't know the exact names
> of the menu items in english version of EM, but i'll try.
> On your new SQL-Server EM:
> Right-Click on Databases -> All Tasks -> Attach DB
> then choose your mdf-file, and that's it. (Hope so!)
> Hope these instructions help.
> Let me know about it.
> Best regards,
hi,
That's ok but you'll still have orfan users. Drop and create database users
again!
regards,
Zarko
|||Hello KS
Assuming you have all database files (including system databases - master,
msdb), you should follow the steps below :
1. Install SQL Server to the same location on the second server (as your
old server)
2. Apply the same service pack and/or hotfix that you had on your old
server.
3. Stop SQL Server services and replace all database files with the ones
that you had from your old server.
Remember the above step may not work correctly if you do not have the
system database file level backups. If this condition was a result of file
system corruption and the database files were copied after the corruption,
its possible that they may be corrupted too. So the above steps may not
work.
If you only have the user database files, follow the step in the article
below :
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
There is also a section in the above article regarding recovering orphaned
logins.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

MSSQL Server Recovery

Can you give us some indication on the status of your
server i.e. is it accessable.
Can you also give us some indication of your backups and
any replication.
Peter
"It's true hard work never killed anybody, but I figure,
why take the chance?"
Ronald Reagan

>--Original Message--
>Hi,
>The Windows 2000 Server (that has MSSQL Server
installed) is corrupted.
>Can anybody tell me how I can make the existing SQL data
files work in
>another Windows 2000 Server?
>What should I do?
>Thanks & Regards,
>KS
>
>.
>Hi,
Due to I cannot log into Windows 2000 Server (installed by
ex-administrator),
I need to install a new Windows 2000 Server.
And transfer the existing data files to the new machine.
Regards,
KS
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:136701c48c22$49618100$a501280a@.phx.gbl...[vbcol=seagreen]
> Can you give us some indication on the status of your
> server i.e. is it accessable.
> Can you also give us some indication of your backups and
> any replication.
> Peter
> "It's true hard work never killed anybody, but I figure,
> why take the chance?"
> Ronald Reagan
>
> installed) is corrupted.
> files work in

MSSQL Server Recovery

Hi,
The Windows 2000 Server (that has MSSQL Server installed) is corrupted.
Can anybody tell me how I can make the existing SQL data files work in
another Windows 2000 Server?
What should I do?
Thanks & Regards,
KSHi KS !
You've got the data and log file ?
I've got the german EM, so don't know the exact names
of the menu items in english version of EM, but i'll try.
On your new SQL-Server EM:
Right-Click on Databases -> All Tasks -> Attach DB
then choose your mdf-file, and that's it. (Hope so!)
Hope these instructions help.
Let me know about it.
Best regards,|||Smuddi wrote:
> Hi KS !
> You've got the data and log file ?
> I've got the german EM, so don't know the exact names
> of the menu items in english version of EM, but i'll try.
> On your new SQL-Server EM:
> Right-Click on Databases -> All Tasks -> Attach DB
> then choose your mdf-file, and that's it. (Hope so!)
> Hope these instructions help.
> Let me know about it.
> Best regards,
hi,
That's ok but you'll still have orfan users. Drop and create database users
again!
regards,
Zarko|||Hello KS
Assuming you have all database files (including system databases - master,
msdb), you should follow the steps below :
1. Install SQL Server to the same location on the second server (as your
old server)
2. Apply the same service pack and/or hotfix that you had on your old
server.
3. Stop SQL Server services and replace all database files with the ones
that you had from your old server.
Remember the above step may not work correctly if you do not have the
system database file level backups. If this condition was a result of file
system corruption and the database files were copied after the corruption,
its possible that they may be corrupted too. So the above steps may not
work.
If you only have the user database files, follow the step in the article
below :
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
There is also a section in the above article regarding recovering orphaned
logins.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

MSSQL Server Recovery

Hi,
The Windows 2000 Server (that has MSSQL Server installed) is corrupted.
Can anybody tell me how I can make the existing SQL data files work in
another Windows 2000 Server?
What should I do?
Thanks & Regards,
KSHi KS !
You've got the data and log file ?
I've got the german EM, so don't know the exact names
of the menu items in english version of EM, but i'll try.
On your new SQL-Server EM:
Right-Click on Databases -> All Tasks -> Attach DB
then choose your mdf-file, and that's it. (Hope so!)
Hope these instructions help.
Let me know about it.
Best regards,|||Can you give us some indication on the status of your
server i.e. is it accessable.
Can you also give us some indication of your backups and
any replication.
Peter
"It's true hard work never killed anybody, but I figure,
why take the chance?"
Ronald Reagan
>--Original Message--
>Hi,
>The Windows 2000 Server (that has MSSQL Server
installed) is corrupted.
>Can anybody tell me how I can make the existing SQL data
files work in
>another Windows 2000 Server?
>What should I do?
>Thanks & Regards,
>KS
>
>.
>|||Smuddi wrote:
> Hi KS !
> You've got the data and log file ?
> I've got the german EM, so don't know the exact names
> of the menu items in english version of EM, but i'll try.
> On your new SQL-Server EM:
> Right-Click on Databases -> All Tasks -> Attach DB
> then choose your mdf-file, and that's it. (Hope so!)
> Hope these instructions help.
> Let me know about it.
> Best regards,
hi,
That's ok but you'll still have orfan users. Drop and create database users
again!
regards,
Zarko|||Hello KS
Assuming you have all database files (including system databases - master,
msdb), you should follow the steps below :
1. Install SQL Server to the same location on the second server (as your
old server)
2. Apply the same service pack and/or hotfix that you had on your old
server.
3. Stop SQL Server services and replace all database files with the ones
that you had from your old server.
Remember the above step may not work correctly if you do not have the
system database file level backups. If this condition was a result of file
system corruption and the database files were copied after the corruption,
its possible that they may be corrupted too. So the above steps may not
work.
If you only have the user database files, follow the step in the article
below :
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
There is also a section in the above article regarding recovering orphaned
logins.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hi,
Due to I cannot log into Windows 2000 Server (installed by
ex-administrator),
I need to install a new Windows 2000 Server.
And transfer the existing data files to the new machine.
Regards,
KS
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:136701c48c22$49618100$a501280a@.phx.gbl...
> Can you give us some indication on the status of your
> server i.e. is it accessable.
> Can you also give us some indication of your backups and
> any replication.
> Peter
> "It's true hard work never killed anybody, but I figure,
> why take the chance?"
> Ronald Reagan
>
> >--Original Message--
> >Hi,
> >
> >The Windows 2000 Server (that has MSSQL Server
> installed) is corrupted.
> >
> >Can anybody tell me how I can make the existing SQL data
> files work in
> >another Windows 2000 Server?
> >
> >What should I do?
> >
> >Thanks & Regards,
> >KS
> >
> >
> >.
> >

MS-SQL Server help me

hai, we r developing a application in VB6.0 with MS SQL Server as
backend. we are facing problem of SQL Server getting hanged after
running continously for more than 4 hrs. our application will be posting
and updating data continously to database. also we have client machines
were we can view these data(these are seperate machines).
we have SQL Server and our application running in seperate machines. SQL
Server is running in a server class machine PIII processor, 256 MB ram
and our application running on a PIV processor, 256 MB ram.
please help me to resolve the problem.
regards
Suriya.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Look lik you are stucking into a deadlock situation. If so, try to check the
activity in SQL Server EM for Deadlocking. If Deadlocks occur , try to use
another locking method in your programs and scripts, that´ll help.
Jens Süßmeyer.
"Suriya Narayanan Vadivel Murugan" <suriyasj@.rediffmail.com> schrieb im
Newsbeitrag news:ex5Z2VgZDHA.4020@.tk2msftngp13.phx.gbl...
> hai, we r developing a application in VB6.0 with MS SQL Server as
> backend. we are facing problem of SQL Server getting hanged after
> running continously for more than 4 hrs. our application will be posting
> and updating data continously to database. also we have client machines
> were we can view these data(these are seperate machines).
> we have SQL Server and our application running in seperate machines. SQL
> Server is running in a server class machine PIII processor, 256 MB ram
> and our application running on a PIV processor, 256 MB ram.
> please help me to resolve the problem.
> regards
> Suriya.
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

MS-SQL Server equivalent to Oracle 9i?

All,

Oracle 9i provides a "USING" clause option for inner joins, that
allows me to say:

SELECT * FROM TBL1 JOIN TBL2 USING KeyColumn

assuming KeyColumn is in both TBL1 and TBL2. This is HIGHLY desirable
for our software make use of, but we also support SQL Server. There
is no USING option available, and

SELECT * FROM TBL1 JOIN TBL2 ON TBL1.KeyColumn = TBL2.KeyColumn

causes an ambiguous column error on KeyColumn.

Is there any equivalent to this Oracle functionality on SQL Server?

KingGreg>> "SELECT * FROM TBL1 JOIN TBL2 ON TBL1.KeyColumn = TBL2.KeyColumn"
causes an ambiguous column error on KeyColumn <<

And the USING clause is limited to equi-joins. But the real problem is
that good SQL programmers do not use "SELECT *" in production code. It
changes at run time and is too unclear and dangerous.

NATURAL JOIN and USING were two of the worst ideas we put into SQL-92.
I hope they get deprecated soon.

--CELKO--
===========================
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
schema are.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||On 14 May 2004 13:02:13 -0700, KingGreg wrote:

>All,
>Oracle 9i provides a "USING" clause option for inner joins, that
>allows me to say:
>SELECT * FROM TBL1 JOIN TBL2 USING KeyColumn
>assuming KeyColumn is in both TBL1 and TBL2. This is HIGHLY desirable
>for our software make use of, but we also support SQL Server. There
>is no USING option available, and
>SELECT * FROM TBL1 JOIN TBL2 ON TBL1.KeyColumn = TBL2.KeyColumn
>causes an ambiguous column error on KeyColumn.

I can't reproduce this error:

create table TBL1 (KeyColumn int not null primary key)
create table TBL2 (KeyColumn int not null primary key)
insert TBL1 (KeyColumn)
values(1)
insert TBL1 (KeyColumn)
values(2)
insert TBL2 (KeyColumn)
values(1)
insert TBL2 (KeyColumn)
values(3)
SELECT * FROM TBL1 JOIN TBL2 ON TBL1.KeyColumn = TBL2.KeyColumn
drop table TBL1
drop table TBL2

KeyColumn KeyColumn
---- ----
1 1

(1 row(s) affected)

Can you post the actual SQL that returns this error, as I assume there is
an error somewhere in the query.

>Is there any equivalent to this Oracle functionality on SQL Server?

No, there isn't.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)|||I understand that I was not clear because you have to be using derived
table. See below:

> create table TBL1 (KeyColumn int not null primary key)
> create table TBL2 (KeyColumn int not null primary key)
> insert TBL1 (KeyColumn)
> values(1)
> insert TBL1 (KeyColumn)
> values(2)
> insert TBL2 (KeyColumn)
> values(1)
> insert TBL2 (KeyColumn)
> values(3)
> SELECT * FROM TBL1 JOIN TBL2 ON TBL1.KeyColumn = TBL2.KeyColumn
> drop table TBL1
> drop table TBL2
>
> KeyColumn KeyColumn
> ---- ----
> 1 1
> (1 row(s) affected)

Try :

1 SELECT KeyColumn
2 FROM (
3 SELECT * FROM TBL1 JOIN TBL2 ON TBL1.KeyColumn = TBL2.KeyColumn
4 ) TBL

Gives error : Column 'KeyColumn' specified multiple times for TBL

As you noted it does not fail when running line 3 by itself.

I guess I must be a bad SQL programmer, but this is nonetheless the
direction I am pursuing because of numerous other limitations in SQL
Server or Oracle that prevents using some other solution.

KingGreg|||Can you be more specific?
I agree with Joe that USING and NATURAL JOIN are undesiravel features,
especially since their only purpose in life seems to be to add convenience.
Obviously you are of a different opinion. As a developer I (and quite
likely MS folks listening in) am curious to learn where you see the
value ad.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab|||KingGreg wrote:
> I understand that I was not clear because you have to be using derived
> table. See below:
>
>>create table TBL1 (KeyColumn int not null primary key)
>>create table TBL2 (KeyColumn int not null primary key)
>>insert TBL1 (KeyColumn)
>>values(1)
>>insert TBL1 (KeyColumn)
>>values(2)
>>insert TBL2 (KeyColumn)
>>values(1)
>>insert TBL2 (KeyColumn)
>>values(3)
>>SELECT * FROM TBL1 JOIN TBL2 ON TBL1.KeyColumn = TBL2.KeyColumn
>>drop table TBL1
>>drop table TBL2
>>
>>
>>KeyColumn KeyColumn
>>---- ----
>>1 1
>>
>>(1 row(s) affected)
>>
>
> Try :
> 1 SELECT KeyColumn
> 2 FROM (
> 3 SELECT * FROM TBL1 JOIN TBL2 ON TBL1.KeyColumn = TBL2.KeyColumn
> 4 ) TBL
> Gives error : Column 'KeyColumn' specified multiple times for TBL
> As you noted it does not fail when running line 3 by itself.
> I guess I must be a bad SQL programmer, but this is nonetheless the
> direction I am pursuing because of numerous other limitations in SQL
> Server or Oracle that prevents using some other solution.
> KingGreg

If in Oracle ... I suspect what you are trying to do is:

SELECT KeyColumn
FROM (
SELECT *
FROM TBL1
WHERE TBL1.KeyColumn = TBL2.KeyColumn);

Using ISO standard syntax. If in 9i or above you could also use
ANSI standard syntax.

--
Daniel Morgan
http://www.outreach.washington.edu/...oad/oad_crs.asp
http://www.outreach.washington.edu/...aoa/aoa_crs.asp
damorgan@.x.washington.edu
(replace 'x' with a 'u' to reply)|||As you have an INNER JOIN it doesn't matter which value of keycolumn you
reference as long as you specify an alias. It's best to avoid using SELECT *
in production code anyway (except in an EXISTS subquery). Try this:

SELECT keycolumn
FROM
(SELECT Tbl1.keycolumn
FROM Tbl1 JOIN Tbl2
ON Tbl1.keycolumn = Tbl2.keycolumn) TBL

--
David Portas
SQL Server MVP
--|||Joe Celko wrote:

>>>"SELECT * FROM TBL1 JOIN TBL2 ON TBL1.KeyColumn = TBL2.KeyColumn"
> causes an ambiguous column error on KeyColumn <<
> And the USING clause is limited to equi-joins. But the real problem is
> that good SQL programmers do not use "SELECT *" in production code. It
> changes at run time and is too unclear and dangerous.

It's not dangerous if your client code accesses the return fields by
name, and not by number. It is, however, generally returning more
data than you need, so it's a waster of resources, and you still
shouldn't do it.

Bill

MSSQL Server connectivity

Hi,

I have two Windows machines in the Local Area Network. One of the machines has MSSQL Enterprise Server 8.0 installed whereas the other has MSSQL Server 2005 installed. When I try to establish the connectivity between these two servers, I can not do so. When I try to look up Network servers, the two machines can't see each other. How can I make them talk to each other? Is there some type of driver or some such thing to be installed which can help the matter?

Please let me know.

Need a bit more information to help you:

Are the instances default or named?
Do you have any firewall software running on either server?
What is the error msg you're getting?
Can you use SQLCMD to connect to the remote server?

|||

Thanks for the response.

Answers to your questions:

1. The MSSQL Server instances are the default ones.

2. I don't think I have a firewall running on the servers.

3. When I go to SQL Server Management Studio and try to register the server by looking on the network, I can not find my other machine with Enterprise Manager 8.0. So I don't get any error, but I can not see the machine either.

4. Login failed for user 'xyz'.
HResult 0x2746, Level 16, State 1
TCP Provider: An existing connection was forcibly closed by the remote host.

Sqlcmd: Error: Microsoft SQL Native Client : Communication link failure.

This is the error that I see on the command prompt.

Here's what I suggest: You may want to go through my answers above, but I think I don't know much about this new SQL version? Can you quickly list a set of steps I can follow to connect from SQL Server 2005 to another machine having SQL Enterprise Manager 8.0 running on it? Thanks in advance.

|||

Enterprise Manager has nothing to do with remote connectivity. This is what I understand you're doing:

Machine 1: Running SQL Server 2000, default instance

Machine 2: Running SQL Server 2005, default instance

From Machine 2 running SQL Server Management Studio you want to connect to Machine 1.

First, make sure that Machine 1 is setup to accept remote connections. This is documented in Books Online for SQL Server 2000.

You'll want to make sure you're providing the correct credentials: Windows or SQL Server depending on how the instance is configured.

|||

Hi Dan,

Thanks for the response. However, we somehow managed to do the connectivity between the 2 servers. Apparently, the SQL user which we were using to establish the connectivity did not work initially. We dropped and recreated the user and then it went through fine. Don't know why it did not connect initially.

I have another problem though. And I would really appreciate if someone could help with this real quick.

So, there's this MSSQL 2005 installed on a new machine, which has 40 G on C Drive and 250+ G on a D Drive. But all of my C Drive has been taken up by "tempdb.mdf". It has taken up nearly 26 G of space on this drive. Why should that be the case? I know that this is a System database that gets created when one installs MSSQL Server, but I have never seen it this big. Is there a problem with the installation that I can fix? Please let me know.

Thanks.

|||This is certainly suspicious. I'm not expert on tempdb so I recommend you post this issue to http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=93&SiteID=1. Someone there will certainly be able to help you.