SQL Problem

[Duss]

Hi Every one,
I am having problem with my SQL server,Every day i have to restar the service for the SQl,I i dont my users cannot work,can anyone pls help me on thise,and what can i do too fix the problem?I dont know if i have to detached the databes,i dont want to try,just want some idea.pls

Thanks.

 

[SQLDenis]

What's the problem can you be more specific?


“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[nomadicalloy]

Need more info on your problem. Do you any kind of optimization on the server?

SQL Help Blog

http://www.xpherion.com/blog.asp

 

[Duss]

Ok,
I have a windows 2000 server,i have differnt applications on the server,but somehow i have to stop and start the sql service every morning,if i dont,then the users that are useing applications that work with sql will get a error,and the only solution is for me to stop and start the service.

hope thise help.

thx

 

[SQLDenis]

What is the exact error message?

“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/