Post reply

Select on base table ok but view fails - Shared Memory

  • September 22, 2004 at 10:41 am

    #89372

    We made a copy of our database.  Now we have issues in query analyzer running queries against our views.  The base table queries are fine.    These are partitioned tables. 

    Error:  [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionCheckForData (CheckforData()).

    Server: Msg 11, Level 16, State 1, Line 0

    General network error. Check your network documentation.

    Connection Broken

    Any idea what is going on.

  • September 22, 2004 at 12:20 pm

    #524044

    Running a DBCC my databases are hosed.  

    Server: Msg 7995, Level 16, State 1, Line 1 Database 'My DB' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing. DBCC execution completed. If DBCC printed error messages, contact your system administrator

    We had one server with the system databases locally and user databases on emc.   The system databases we get to the new servers C: with backup / restore.  The user database we get to the new server EMC with a SNAP backup.    This will be a process done weekly.  We're trying to get the fist copy of the data moved and working.

    Any idea what is wrong.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply