May 15, 2008 at 1:48 am
Hi,
For one particular server when we try to open the list of tables, sp from the management studio the left panel is not showing anything and throws this error "Error in xp_regread: couldn't alloc 212 bytes" but the right window shows the tables, Programma... Any clue about this issue? If i connect to this server from some other servers management studio also the same issue. Anything to do with RAM Capacity or any issue with registry?
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
May 15, 2008 at 2:28 am
[font="Verdana"]Ensure that you have applied Sql Server 2005 SP2 for management studio as well.
Open SSMS
Goto Help-->About in SSMS
There you can get the version of "Microsoft SQL Server Management Studio", you can see the detail as below
Microsoft SQL Server Management Studio 9.00.3042.00
Where 3042 represents SP2!!
[/font]
[font="Verdana"]- Deepak[/font]
August 31, 2008 at 9:01 am
Hi All,
Incase even after having 2005SP2 and still if you facing this issue then it shows that there is no enough Memory for SQLServer. How you can confirm this is...
Run below code
SELECT @@Version[/CODE]
You will get proper output. Then run the below command
BACKUP DATABASE master TO DISK='C:\master.bak'[/CODE]
Now you will get the message as error which I'm talking about... 🙁
So increase your RAM Capacity or allocate more RAM to SQLServer
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
August 31, 2008 at 9:14 am
It sounds like a tool corruption issue or perhaps memory on the workstation. Are you opening SSMS from the console or your workstation?
August 31, 2008 at 10:45 am
Hi Steve,
It is happening when opening SSMS when inside server itself... But If you restart SQL Instance the functionality will be normal and in due course it will start giving this error... I'm not sure that it will be a tool corruption..
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
November 17, 2008 at 9:53 am
I received the same error message and by restarting SQL Server (MSSQLSERVER) service I was then able to open up the left side panel and expand it out without getting the error message.:)
November 17, 2008 at 9:49 pm
Hi,
When you restart your SQL Server then memory will be flushed so it will work perfectly but gradually you will get this error once memory bottleneck comes again..
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply