Error while running this query

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Error while running this query

Author

Topic

magictech
Starting Member

44 Posts

Posted - 2004-10-05 : 11:37:44

I’m getting the following error message when I run this query.

Query

INSERT INDEXTSV_BW
EXEC sp_MSforeachtable @command1 = " sp_spaceused '?'"
SELECT * FROM TABLE_SPACE_BW

Error Message

[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

Here is the table structure
CREATE TABLE TABLE_SPACE_BW (TABLE_NAME VARCHAR (15), ROW_COUNT INT,
SPACE_RESERVED VARCHAR (10),
DATA_SIZE VARCHAR (10), INDEX_SIZE VARCHAR (10), UNUSED_SPACE VARCHAR (10), DATE_EXECUTED DATETIME DEFAULT (GETDATE()))

Basically, I’m trying to populate a table with the output of sp_spaceused through a view. My query works fine if I run it on Pubs database. However, I’m getting this error message if I run the same query on any other databases on the same server. I’ve checked the databases options on all the other databases and compare them to that of pubs database and they all the same.

I’ve search the net for possible solution but nothing seems to make sense. Dose anyone knows what could be causing this problem? Please any information would be highly appreciated.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources