This is happening because Window Login user who owned the database being removed from windows domain account.

 This is a bug as Database withour any ownere being assigned.

from OSQL use the -h-1 switch

I tried that but the result coming with  like wraped. Like

1 | 121SAAABA |

151...

This problem occured in my case because of that Windows domain account which was owner of the database being removed.

Hi all,

 Now, I am getting this similar error message on 'sp_helpdb'

Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53

Cannot insert the value NULL into column '', table...

I could not found HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\80\Registration\CD_KEY Registry key either.

I also got the same errror 14274, when i migrated the databases from the current development box to the new development box.

I believe this error related the SQL Server name...

Hi Yelena,

I just tried from the command prompt "SQL Server Enterprise Manager.msc".

It works fine.

thanks

Have a look on this link.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q288577

Ensure the SQL Server Service account is  a domain account and has access on the both the nodes.

SQL Server Service account can be changed on Enterprise Manager.

-S SIVAPRASAD

I also faced this problem when i schedule a database optimization jon on SQL 7.0 with Sp2 box. Clueless about what cause the problem.

- S Sivaprasad

Hi Chris ,

So at any point of time 255 Worler Threads  =>  255*0.5 MB = 128 MB + each connection approx 0.5MB would be required on RAM aspect. Is that right?

On...

Hi Karl Grambow.,

    Your reply is splendid. I would be grateful if you could expalin the same with example for say client requesting configuration for box to support 100 concurrent...

 I rephrase my question,

How to measure how many transaction to a maximum per second a server would handle ?

David,

 Thanks for the advise. The question I posted is general only. I just like to know is there any thump rule exists?

  One more thing, say I have a box...

Vinit Jain,

 I am facing this similar problem.

 Could you please let me know how to resolve this?

Thanks