SQL Server, urgent...need expert's help.

microsoft.public.sqlserver.server - Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.


SQL Server >> urgent...need expert's help.

by Utada P.W. SIU » Sat, 11 Sep 2004 20:28:02 GMT

Dear all experts

My SQL server have some problems. I am running SQL 2000 on my server. It
have no problem before, howevre, it have problems recently.
The machine can run smoothly, however, the database services is out of
service, I have checked the application log and system log but there haven't
show any problem, and I have checked the services status from "Start" -->
'Control Panel' --> "Administrator Tools" --> "Services", and check the
MSSQLSERVER is started, but my application cannot connect it, ther response
it that "Connection fail, server not found", so I have stopped it and
restart services again, but it cannot, too. So, I need restart my machine,
and after eerything started, my application can connect it again.

All experts, I would like to know why this problem occurs??? Thanks you.



Top

SQL Server >> RE: urgent...need expert's help.

by SnVsaWE » Sat, 11 Sep 2004 21:07:08 GMT


Any error in errorlog for SQL server? Which Service Pack you are using?Run
"select @@version" to get the version number to see whether you need to apply
updated service pack.

Julia





Top

SQL Server >> urgent...need expert's help.

by Adam Machanic » Sun, 12 Sep 2004 00:35:07 GMT

You haven't just upgraded to XP SP2, by any chance, have you? If so, you
may be seeing the effects of the new firewall. Unfortunately, I can't tell
you how to turn it off, as I haven't installed that service pack yet.




haven't
response



Top

RE: urgent...need expert's help.

by U2FsZWVtIEhha2FuaQ » Sun, 12 Sep 2004 15:19:01 GMT

Please provide the exact error.






Top
Similar Threads

1. COM conflict resolver EXPERT idea needed(urgent) 

Hi,

In COM conflict resolver, let's say, subscriber tries to upload an
INSERTED row to the publisher. By setting
rct = REPOLEAllChanges 
in the IVBCustomResolver_GetHandledStates COM function I can catch all
the changes not only conflicts.

And in IVBCustomResolver_Reconcile function of the COM resolver, I
want to manipulate the INSERTED row from the source and eventually
insert that manipulated row to the destination. I tried

rrc.InsertRow
rrc.CopyRowFromSource
rrc.UpdateRow
but they did not work. 

What is missing? What should I do to get an inserted row(Not updated
one, update works without any problem)  from source in COM resolver
and manipulate it and INSERT it to the destination.

Any help would be greatly appreciated.
Thanks,
Nury SWORD

2. need expert's opinions... - SQL Server

3. Need expert's opinion on table schema... 

Hello,

I have seen different types of table schemas employed in 
applications and I would like to get the opinions of the 
SQL experts...

First some definitions:

LU = Lookup 
IP = Index Person
IA = Index Account

Background sample info:
Fred has two accounts number 9999 and 8888
Joe has one account 7777


I can represent these accounts in the following
table examples: 
(probably lots more ways to do this, but I am interested 
in these two architectures, but would be willing to 
entertain other schemas)


Example 1:
Person         LU       Account
IP  Name     IP IA      IA  Num
1   Fred      1  1       1   9999
2   Joe       1  2       2   8888
              2  3       3   7777


Example 2:
Person         Account
IP Name        IA  IP  Num
1  Fred         1  1   9999
2  Joe          2  1   8888
                3  2   7777


My questions to the people who live and breath SQL,
What are the pros and cons to the above table schemas?
Please be specific and if necessary write me in a 
separate email :   XXXX@XXXXX.COM 


Thanks
Mike

4. EXPERT MS SQL SERVER HELP NEEDED

5. Need Help From SQL Experts 

Hi there,

we are having an application running on sql server. on client side there is
an a setting for the internet (to run internet on each machine) in which
they have assigned the ip address in the gateways. this setting creating
problem in which application not going on local server it goes on internet
to search the server because of this connection time expires and application
terminates.


Plz reply me the proper solution. it's urgent.

thanks

6. Need help with my concepts - Question for experts

7. Expert help needed 

table 1

APP_ID 
1	
3	



table 2

APP_ID  Profile_NUM  
1	001AAA
2	001AAA
3	001AAA
1	000A223
2	000A223
1	01A345
2	01A345
1	0909
3	0909
5	BASS1
6	BASS1
7	BASS1




I would Like to perform the following:
	. read table 1
	. match table 1 against table 2, using App_ID column, and return 
	  the following Profile_Num from table 2:
		. 0909 - exact match 
		. 011AAA - close matches
		. 000A223 - close match
		. 01A345 -  close match

8. Replication topology - need expert help - SQL Server Replication