Colin is right. Check what about users are complain. When instead of graphs I suggest to check the report. Sometimes graphs and reports are not the same.

If users complain...

It depends of the number of user connecting to the server. Every open document keep an open connection (network), saving and reading large document keep the disk busy.

Printing cause last...

If you are using SQL 2005 you my try with a snapshot on a daily basis.

Moreno

Hi Ivan

I have not installed SP2 yet. According to Microsoft 931820 should not be included in SP2. They advice me to install the hotfix again in case I'm going to...

Write you statement as store procedure and pass parameters with asp. If it still not works, you have probably a permission problem.

If it works review your code one again....

Try also a connection with osql through command prompt, just to verify that everything with EM ist OK

Hi guys

from Microsoft I got the same hotfix like Edward, but it worked on one node of my cluster only.....

Finally I got from Microsoft an other Hotfix. This is still...

Source=MYIP: May I suggest to use for instance a DNS Alias instead of IP hard coding

Stuck in restore mode: It looks like you have choosen the NORECOVERY Option.....or not ?

I am not sure that I got your problem, anyway if the problem is caused by...

Use sp_help_revlogin, see also http://www.sqlservercentral.com/columnists/glarsen/migratingloginstoanotherserver.asp.

It works for sql2k to sql2005 as far as I know.

Can you start the msdtc service now ? Is SSIS installed on both nodes and if yes, is the service starting correctly then you move the group ?

If I understand...

What a mess...Again, if you move to sql 2005, try to push mirroring. In my opinion more safe way you can go with such a db.

Good luck

Arethe servers connected to a SAN or NAS ? If yes clustering will be the best solution. How are the clients switching from one server to the other ? In...

#9 It means the registry application tab of the cluster resources. You should add the registry path

#14 you store the xml config file under a cluster resource. You should change...

Hi there

first at all, thanks for the replies...it seems that I have posted an interesting problem :-))

I analyzed the problem further finding out (thank you Ben) that just one thread...