-
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
Hi,
I ran this below query in my server in 2 different database. I'm getting the below error in one of our database. And also we are having same tables in both database.
I checked 5 times and keep on getting this same error.
Any body can give any suggestion regarding this.
---Error
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
---Query
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TempTable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TempTable]
DECLARE @cmdstr varchar(100)
DECLARE @Sort bit
SELECT @Sort = 0
CREATE TABLE dbo.TempTable
( [Table_Name] varchar(50),
Row_Count int,
Table_Size varchar(50),
Data_Space_Used varchar(50),
Index_Space_Used varchar(50),
Unused_Space varchar(50)
)
--Create Stored Procedure String
SELECT @cmdstr = 'sp_msforeachtable ''sp_spaceused "?"'''
INSERT INTO TempTable EXEC(@cmdstr)
SELECT Table_Name,Row_Count FROM TempTable ORDER BY Table_Name
DROP TABLE TempTable
-
Add the servername or the IP address (with alias name) in the client network utility on your machine and then try it.
-
Mak,
Thanks for quick reply.
The same sarver I'm getting this error for 2nd database which is copied from 1st database.
I just switching the database in
Qeury analayser and running this qeury.
Do I need to compare any database config ?.
thanks,
Ravi
-
how did you copy the database? backup and restore?
just refresh the "databases" on the object browser and try or else run DBCC checkdb on that database
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|