December 2, 2008 at 10:02 pm
Hi all,
When i am openning my table in design view in enterprise Manager i am getting this error.
Table could not be loaded ODBC Error[Microsoft][ODBC SQL SERVER][DBNetLIB] connection read(rec()).
[Microsoft][ODBC SQL SERVER][DBNetLIB] Genral Network error. Check your network documentation.
It meght be simple only,
Please help
Thanks
Syed Sanaulla Khadri
DBA
December 3, 2008 at 4:32 am
Any one who can help me Please
December 3, 2008 at 7:55 am
Are you getting this error in any other place?
Check the windows logs over and speak with your network team.
December 3, 2008 at 10:07 pm
Yes ,
When i am running any query on query analyzer i am getting the same error. We have a junior in network department. I dont thing he will solve this problem can u helpme.
Thanks
Syed Sanaullah Khadri
December 3, 2008 at 10:35 pm
Sanaullah (12/2/2008)
Hi all,When i am openning my table in design view in enterprise Manager i am getting this error.
Table could not be loaded ODBC Error[Microsoft][ODBC SQL SERVER][DBNetLIB] connection read(rec()).
[Microsoft][ODBC SQL SERVER][DBNetLIB] Genral Network error. Check your network documentation.
It meght be simple only,
Please help
Thanks
Syed Sanaulla Khadri
DBA
where is the database located. on the same computer or anywhere in remote
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
December 3, 2008 at 10:46 pm
its located on the remote computer and i am accessing this using linked server
December 3, 2008 at 10:50 pm
Sanaullah (12/3/2008)
its located on the remote computer and i am accessing this using linked server
may be it is due to that you dont have permissions to create the table or there may be the network failure.
why dont you test it by creating a temp table or by executing any select statement on that dB
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
December 3, 2008 at 10:57 pm
I am having the sysadmin privileges, ok can be a network problem. Just now i saw my logs an i got this message
The SQL Server has been optimized for 8 concurrent query. This Limit has been exceededby 1 query and performance might be adversely affected.
December 3, 2008 at 11:13 pm
Using this command you can check how many transaction are currently open.
--This command gets you the spid of open transactions.
DBCC opentran
Check how many open transactions are there on the server.
December 3, 2008 at 11:15 pm
Gauthama Kolivad (12/3/2008)
Using this command you can check how many transaction are currently open.--This command gets you the spid of open transactions.
DBCC opentran
Check how many open transactions are there on the server.
how
DBCC opentran will help for such error
"Genral Network error. Check your network documentation"
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
December 3, 2008 at 11:44 pm
I am having the sysadmin privileges, ok can be a network problem. Just now i saw my logs an i got this message
The SQL Server has been optimized for 8 concurrent query. This Limit has been exceededby 1 query and performance might be adversely affected.
DBCC opentran
will help to get the no of open transactions. Since its related concurrent query .... check the above message.
To check this it will help.
But if you are getting any network error as you mentioned it will not help.
December 3, 2008 at 11:48 pm
No active open transactions
December 3, 2008 at 11:49 pm
Gauthama Kolivad (12/3/2008)
I am having the sysadmin privileges, ok can be a network problem. Just now i saw my logs an i got this message
The SQL Server has been optimized for 8 concurrent query. This Limit has been exceededby 1 query and performance might be adversely affected.
DBCC opentran
will help to get the no of open transactions. Since its related concurrent query .... check the above message.
To check this it will help.
But if you are getting any network error as you mentioned it will not help.
do you think that while creating a table the open transactions matters, and if yes . how??
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
December 3, 2008 at 11:50 pm
No active open transactions
I dont have any open transaction.
December 3, 2008 at 11:59 pm
No active open transactions
I dont have any open transaction.
Then it is not due to concurrent query issue.... but why it is showing that message.
as
The SQL Server has been optimized for 8 concurrent query. This Limit has been exceededby 1 query and performance might be adversely affected.
What you can do is try to connect to the server from different machine and check.
Viewing 15 posts - 1 through 15 (of 21 total)
You must be logged in to reply to this topic. Login to reply