Attempt to fetch logical page...error printing

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

General SQL Server Forums

New to SQL Server Programming

Attempt to fetch logical page...error printing

Author

Topic

HolmesChiro
Starting Member

9 Posts

Posted - 2009-11-16 : 13:31:27

Hello,

I hope this is the right place to post. I have zero experience with SQL and I googled my work's program error and found this place.

My work is running Lytec 2007. It's unsupported by the Lytec Tech people because they want us to buy their new version. So anyway, we have the Multi User program and Lytec is installed on 3 computers. My computer is also the server.

A few days ago I tried to print something in Lytec. I got this error:

Attempt to fetch logical page (1:138440) in database 'Holmes Chiropractic' belongs to object 'syscomments', not to object 'Billing Detail'.

I restarted the computer, but still got the error. Nothing has changed or been updated in Lytec. The weird thing is computer #3 prints just fine, but my computer and computer #2 get this error. Occasionally, if we try printing 5+ times, we get lucky and the document will print despite the error.

Can anyone help me fix this?

Here is the full report:

An error has occurred.  If you need to report this error, please be sure to include all information in this dialog.

Time of Error: 11/16/2009 10:17:28 AM
Program Version: Multi User
Server: SERVER\LYTEC_SQL
Client: server
Client OS: 5.1.2600, SP 3.0 (Service Pack 3), Product Type 1, Platform 2, Suite: 256
Client Processor: Intel  15 r-0x00000303 (Count/Active 2/0x00000003)
Connection: Holmes Chiropractic
Table: Billing Detail
Operation: Open Table
Error Numbers: 0x80040E14, 0x00000C14, 0x0000025D
Error Code: 42000

Short Error:
Attempt to fetch logical page (1:138440) in database 'Holmes Chiropractic' belongs to object 'syscomments', not to object 'Billing Detail'.

Error:
Source: Microsoft OLE DB Provider for SQL Server
Description: Attempt to fetch logical page (1:138440) in database 'Holmes Chiropractic' belongs to object 'syscomments', not to object 'Billing Detail'.
Error Message: IDispatch error #3092

Loaded Modules:
Exception 1: 0
Exception 1 Flag: 0
Exception 1 Address: 0x7C812AFB

Modules in Stack:
    Module: Lytec.exe
        Base: 0x00400000
        Size: 8077312
        Path: C:\Lytec 2007\Lytec.exe
        Version: 13.3.2.1
    Module: ntdll.dll
        Base: 0x7C900000
        Size: 729088
        Path: C:\WINDOWS\system32\ntdll.dll
        Version: 5.1.2600.5755
    Module: kernel32.dll
        Base: 0x7C800000
        Size: 1007616
        Path: C:\WINDOWS\system32\kernel32.dll
        Version: 5.1.2600.5781
    Module: Secur32.dll
        Base: 0x77FE0000
        Size: 69632
        Path: C:\WINDOWS\system32\Secur32.dll
        Version: 5.1.2600.5834
    Module: ADVAPI32.dll
        Base: 0x77DD0000
        Size: 634880
        Path: C:\WINDOWS\system32\ADVAPI32.dll
        Version: 5.1.2600.5755
    Module: RPCRT4.dll
        Base: 0x77E70000
        Size: 598016
        Path: C:\WINDOWS\system32\RPCRT4.dll
        Version: 5.1.2600.5795
    Module: WININET.dll
        Base: 0x771B0000
        Size: 696320
        Path: C:\WINDOWS\system32\WININET.dll
        Version: 6.0.2900.5880
    Module: CRYPT32.dll
        Base: 0x77A80000
        Size: 610304
        Path: C:\WINDOWS\system32\CRYPT32.dll
        Version: 5.131.2600.5512
    Module: MSASN1.dll
        Base: 0x77B20000
        Size: 73728
        Path: C:\WINDOWS\system32\MSASN1.dll
        Version: 5.1.2600.5875
    Module: msvcrt.dll
        Base: 0x77C10000
        Size: 360448
        Path: C:\WINDOWS\system32\msvcrt.dll
        Version: 7.0.2600.5512
    Module: USER32.dll
        Base: 0x7E410000
        Size: 593920
        Path: C:\WINDOWS\system32\USER32.dll
        Version: 5.1.2600.5512
    Module: GDI32.dll
        Base: 0x77F10000
        Size: 299008
        Path: C:\WINDOWS\system32\GDI32.dll
        Version: 5.1.2600.5698
    Module: OLEAUT32.dll
        Base: 0x77120000
        Size: 569344
        Path: C:\WINDOWS\system32\OLEAUT32.dll
        Version: 5.1.2600.5512
    Module: ole32.dll
        Base: 0x774E0000
        Size: 1298432
        Path: C:\WINDOWS\system32\ole32.dll
        Version: 5.1.2600.5512
    Module: SHLWAPI.dll
        Base: 0x77F60000
        Size: 483328
        Path: C:\WINDOWS\system32\SHLWAPI.dll
        Version: 6.0.2900.5512
    Module: MPR.dll
        Base: 0x71B20000
        Size: 73728
        Path: C:\WINDOWS\system32\MPR.dll
        Version: 5.1.2600.5512
    Module: VERSION.dll
        Base: 0x77C00000
        Size: 32768
        Path: C:\WINDOWS\system32\VERSION.dll
        Version: 5.1.2600.5512
    Module: MFC80.DLL
        Base: 0x781D0000
        Size: 1110016
        Path: C:\WINDOWS\WinSxS\x86_Microsoft.VC80.MFC_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_3bf8fa05\MFC80.DLL
        Version: 8.0.50727.762
    Module: MSVCR80.dll
        Base: 0x78130000
        Size: 634880
        Path: C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.3053_x-ww_b80fa8ca\MSVCR80.dll
        Version: 8.0.50727.3053
    Module: comdlg32.dll
        Base: 0x763B0000
        Size: 299008
        Path: C:\WINDOWS\system32\comdlg32.dll
        Version: 6.0.2900.5512
    Module: COMCTL32.dll
        Base: 0x5D090000
        Size: 630784
        Path: C:\WINDOWS\system32\COMCTL32.dll
        Version: 5.82.2900.5512
    Module: SHELL32.dll
        Base: 0x7C9C0000
        Size: 8482816
        Path: C:\WINDOWS\system32\SHELL32.dll
        Version: 6.0.2900.5622
    Module: WINSPOOL.DRV
        Base: 0x73000000
        Size: 155648
        Path: C:\WINDOWS\system32\WINSPOOL.DRV
        Version: 5.1.2600.5512
    Module: WS2_32.dll
        Base: 0x71AB0000
        Size: 94208
        Path: C:\WINDOWS\system32\WS2_32.dll
        Version: 5.1.2600.5512
    Module: WS2HELP.dll
        Base: 0x71AA0000
        Size: 32768
        Path: C:\WINDOWS\system32\WS2HELP.dll
        Version: 5.1.2600.5512
    Module: MSVCP80.dll
        Base: 0x7C420000
        Size: 552960
        Path: C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.3053_x-ww_b80fa8ca\MSVCP80.dll
        Version: 8.0.50727.3053
    Module: comctl32.dll
        Base: 0x773D0000
        Size: 1060864
        Path: C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.5512_x-ww_35d4ce83\comctl32.dll
        Version: 6.0.2900.5512
    Module: MFC80ENU.DLL
        Base: 0x5D360000
        Size: 57344
        Path: C:\WINDOWS\WinSxS\x86_Microsoft.VC80.MFCLOC_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_91481303\MFC80ENU.DLL
        Version: 8.0.50727.762
    Module: DatabaseInterface 2007.dll
        Base: 0x10000000
        Size: 2236416
        Path: C:\Lytec 2007\DatabaseInterface 2007.dll
        Version: 2.0.0.1
    Module: ODBC32.dll
        Base: 0x74320000
        Size: 249856
        Path: C:\WINDOWS\system32\ODBC32.dll
        Version: 3.525.1132.0
    Module: odbcint.dll
        Base: 0x012B0000
        Size: 94208
        Path: C:\WINDOWS\system32\odbcint.dll
        Version: 3.525.1132.0
    Module: uxtheme.dll
        Base: 0x5AD70000
        Size: 229376
        Path: C:\WINDOWS\system32\uxtheme.dll
        Version: 6.0.2900.5512
    Module: CLBCATQ.DLL
        Base: 0x76FD0000
        Size: 520192
        Path: C:\WINDOWS\system32\CLBCATQ.DLL
        Version: 2001.12.4414.700
    Module: COMRes.dll
        Base: 0x77050000
        Size: 806912
        Path: C:\WINDOWS\system32\COMRes.dll
        Version: 2001.12.4414.700
    Module: msado15.dll
        Base: 0x4DE10000
        Size: 536576
        Path: C:\Program Files\Common Files\System\ado\msado15.dll
        Version: 2.81.1132.0
    Module: MSDART.DLL
        Base: 0x765B0000
        Size: 151552
        Path: C:\WINDOWS\system32\MSDART.DLL
        Version: 2.81.1132.0
    Module: xpsp2res.dll
        Base: 0x016D0000
        Size: 2904064
        Path: C:\WINDOWS\system32\xpsp2res.dll
        Version: 5.1.2600.5512
    Module: OLEDB32.DLL
        Base: 0x73160000
        Size: 487424
        Path: C:\Program Files\Common Files\System\OLE DB\OLEDB32.DLL
        Version: 2.81.1132.0
    Module: OLEDB32R.DLL
        Base: 0x75350000
        Size: 69632
        Path: C:\Program Files\Common Files\System\OLE DB\OLEDB32R.DLL
        Version: 2.81.1132.0
    Module: sqloledb.dll
        Base: 0x4DD00000
        Size: 528384
        Path: C:\Program Files\Common Files\System\Ole DB\sqloledb.dll
        Version: 2000.85.1132.0
    Module: MSDATL3.dll
        Base: 0x60E30000
        Size: 94208
        Path: C:\Program Files\Common Files\System\Ole DB\MSDATL3.dll
        Version: 2.81.1132.0
    Module: NETAPI32.dll
        Base: 0x5B860000
        Size: 348160
        Path: C:\WINDOWS\system32\NETAPI32.dll
        Version: 5.1.2600.5694
    Module: comsvcs.dll
        Base: 0x76620000
        Size: 1294336
        Path: C:\WINDOWS\system32\comsvcs.dll
        Version: 2001.12.4414.702
    Module: colbact.DLL
        Base: 0x75130000
        Size: 81920
        Path: C:\WINDOWS\system32\colbact.DLL
        Version: 2001.12.4414.700
    Module: MTXCLU.DLL
        Base: 0x750F0000
        Size: 77824
        Path: C:\WINDOWS\system32\MTXCLU.DLL
        Version: 2001.12.4414.706
    Module: WSOCK32.dll
        Base: 0x71AD0000
        Size: 36864
        Path: C:\WINDOWS\system32\WSOCK32.dll
        Version: 5.1.2600.5512
    Module: CLUSAPI.DLL
        Base: 0x76D10000
        Size: 73728
        Path: C:\WINDOWS\system32\CLUSAPI.DLL
        Version: 5.1.2600.5512
    Module: RESUTILS.DLL
        Base: 0x750B0000
        Size: 73728
        Path: C:\WINDOWS\system32\RESUTILS.DLL
        Version: 5.1.2600.5512
    Module: USERENV.dll
        Base: 0x769C0000
        Size: 737280
        Path: C:\WINDOWS\system32\USERENV.dll
        Version: 5.1.2600.5512
    Module: DBNETLIB.DLL
        Base: 0x6D4F0000
        Size: 110592
        Path: C:\WINDOWS\system32\DBNETLIB.DLL
        Version: 2000.85.1132.0
    Module: security.dll
        Base: 0x71F80000
        Size: 16384
        Path: C:\WINDOWS\system32\security.dll
        Version: 5.1.2600.5512
    Module: msv1_0.dll
        Base: 0x77C70000
        Size: 151552
        Path: C:\WINDOWS\system32\msv1_0.dll
        Version: 5.1.2600.5876
    Module: cryptdll.dll
        Base: 0x76790000
        Size: 49152
        Path: C:\WINDOWS\system32\cryptdll.dll
        Version: 5.1.2600.5512
    Module: iphlpapi.dll
        Base: 0x76D60000
        Size: 102400
        Path: C:\WINDOWS\system32\iphlpapi.dll
        Version: 5.1.2600.5512
    Module: ntdsapi.dll
        Base: 0x767A0000
        Size: 77824
        Path: C:\WINDOWS\system32\ntdsapi.dll
        Version: 5.1.2600.5512
    Module: DNSAPI.dll
        Base: 0x76F20000
        Size: 159744
        Path: C:\WINDOWS\system32\DNSAPI.dll
        Version: 5.1.2600.5625
    Module: WLDAP32.dll
        Base: 0x76F60000
        Size: 180224
        Path: C:\WINDOWS\system32\WLDAP32.dll
        Version: 5.1.2600.5512
    Module: DBmsLPCn.dll
        Base: 0x74CD0000
        Size: 32768
        Path: C:\WINDOWS\system32\DBmsLPCn.dll
        Version: 2000.80.2039.0
    Module: MSVCR71.dll
        Base: 0x7C340000
        Size: 352256
        Path: C:\Lytec 2007\MSVCR71.dll
        Version: 7.10.3052.4
    Module: SQLOLEDB.RLL
        Base: 0x01CD0000
        Size: 61440
        Path: C:\Program Files\Common Files\System\Ole DB\SQLOLEDB.RLL
        Version: 2000.85.1132.0
    Module: msadrh15.dll
        Base: 0x4CA30000
        Size: 57344
        Path: C:\Program Files\Common Files\System\ado\msadrh15.dll
        Version: 2.81.1132.0
    Module: mrscn.dll
        Base: 0x01F80000
        Size: 1961984
        Path: C:\Lytec 2007\mrscn.dll
    Module: ACE32.DLL
        Base: 0x12170000
        Size: 856064
        Path: C:\Lytec 2007\ACE32.DLL
        Version: 7.10.0.11
    Module: oledlg.dll
        Base: 0x7DF70000
        Size: 139264
        Path: C:\WINDOWS\system32\oledlg.dll
        Version: 5.1.2600.5512
    Module: RICHED20.DLL
        Base: 0x74E30000
        Size: 446464
        Path: C:\WINDOWS\system32\RICHED20.DLL
        Version: 5.30.23.1230
    Module: HHCTRL.OCX
        Base: 0x7E4B0000
        Size: 561152
        Path: C:\WINDOWS\System32\HHCTRL.OCX
        Version: 5.2.3790.4110
    Module: crheapalloc.dll
        Base: 0x026E0000
        Size: 151552
        Path: C:\Program Files\Common Files\Crystal Decisions\2.5\bin\crheapalloc.dll
        Version: 9.2.0.3
    Module: cxlibw-1-6.dll
        Base: 0x49450000
        Size: 1253376
        Path: C:\WINDOWS\system32\cxlibw-1-6.dll
        Version: 10.0.5.871
    Module: MSVCP60.dll
        Base: 0x76080000
        Size: 413696
        Path: C:\WINDOWS\system32\MSVCP60.dll
        Version: 6.2.3104.0
    Module: DBGHELP.dll
        Base: 0x59A60000
        Size: 659456
        Path: C:\WINDOWS\system32\DBGHELP.dll
        Version: 5.1.2600.5512
    Module: msi.dll
        Base: 0x7D1E0000
        Size: 2867200
        Path: C:\WINDOWS\system32\msi.dll
        Version: 3.1.4001.5512
    Module: SXS.DLL
        Base: 0x7E720000
        Size: 720896
        Path: C:\WINDOWS\system32\SXS.DLL
        Version: 5.1.2600.5512
    Module: crdb_ado.dll
        Base: 0x4EAF0000
        Size: 405504
        Path: C:\Program Files\Common Files\Crystal Decisions\2.5\bin\crdb_ado.dll
        Version: 10.0.5.660
    Module: BROHL07A.DLL
        Base: 0x03210000
        Size: 372736
        Path: C:\WINDOWS\System32\spool\DRIVERS\W32X86\3\BROHL07A.DLL
        Version: 0.3.0.0
    Module: BRUHL07A.DLL
        Base: 0x6A900000
        Size: 1081344
        Path: C:\WINDOWS\System32\spool\DRIVERS\W32X86\3\BRUHL07A.DLL
        Version: 0.3.0.0
    Module: SPOOLSS.DLL
        Base: 0x742E0000
        Size: 86016
        Path: C:\WINDOWS\system32\SPOOLSS.DLL
        Version: 5.1.2600.5512
    Module: BRLHL07A.DLL
        Base: 0x03270000
        Size: 86016
        Path: C:\WINDOWS\System32\spool\DRIVERS\W32X86\3\BRLHL07A.DLL
        Version: 0.3.0.0
    Module: u35dtEN.dll
        Base: 0x03B40000
        Size: 20480
        Path: C:\Program Files\Common Files\Crystal Decisions\2.5\bin\u35dtEN.dll
        Version: 10.0.5.14
    Module: mswsock.dll
        Base: 0x71A50000
        Size: 258048
        Path: C:\WINDOWS\System32\mswsock.dll
        Version: 5.1.2600.5625
    Module: winrnr.dll
        Base: 0x76FB0000
        Size: 32768
        Path: C:\WINDOWS\System32\winrnr.dll
        Version: 5.1.2600.5512
    Module: onup.dll
        Base: 0x043E0000
        Size: 851968
        Path: C:\Lytec 2007\onup.dll
        Version: 1.0.9.9
    Module: Wship6.dll
        Base: 0x58D40000
        Size: 28672
        Path: C:\WINDOWS\system32\Wship6.dll
        Version: 5.1.2600.5512
    Module: olepro32.dll
        Base: 0x5EDD0000
        Size: 94208
        Path: C:\WINDOWS\system32\olepro32.dll
        Version: 5.1.2600.5512
    Module: eliver.dll
        Base: 0x045B0000
        Size: 3043328
        Path: C:\Lytec 2007\eliver.dll
        Version: 3.0.1.6
    Module: hnetcfg.dll
        Base: 0x662B0000
        Size: 360448
        Path: C:\WINDOWS\system32\hnetcfg.dll
        Version: 5.1.2600.5512
    Module: wshtcpip.dll
        Base: 0x71A90000
        Size: 32768
        Path: C:\WINDOWS\System32\wshtcpip.dll
        Version: 5.1.2600.5512
    Module: rasadhlp.dll
        Base: 0x76FC0000
        Size: 24576
        Path: C:\WINDOWS\system32\rasadhlp.dll
        Version: 5.1.2600.5512
    Module: appHelp.dll
        Base: 0x77B40000
        Size: 139264
        Path: C:\WINDOWS\system32\appHelp.dll
        Version: 5.1.2600.5512
    Module: SETUPAPI.dll
        Base: 0x77920000
        Size: 995328
        Path: C:\WINDOWS\system32\SETUPAPI.dll
        Version: 5.1.2600.5512
    Module: ntshrui.dll
        Base: 0x76990000
        Size: 151552
        Path: C:\WINDOWS\system32\ntshrui.dll
        Version: 5.1.2600.5512
    Module: ATL.DLL
        Base: 0x76B20000
        Size: 69632
        Path: C:\WINDOWS\system32\ATL.DLL
        Version: 3.5.2284.2
    Module: browseui.dll
        Base: 0x75F80000
        Size: 1036288
        Path: C:\WINDOWS\System32\browseui.dll
        Version: 6.0.2900.5512
    Module: SHDOCVW.dll
        Base: 0x7E290000
        Size: 1519616
        Path: C:\WINDOWS\system32\SHDOCVW.dll
        Version: 6.0.2900.5880
    Module: CRYPTUI.dll
        Base: 0x754D0000
        Size: 524288
        Path: C:\WINDOWS\system32\CRYPTUI.dll
        Version: 5.131.2600.5512
    Module: WINTRUST.dll
        Base: 0x76C30000
        Size: 188416
        Path: C:\WINDOWS\system32\WINTRUST.dll
        Version: 5.131.2600.5512
    Module: IMAGEHLP.dll
        Base: 0x76C90000
        Size: 163840
        Path: C:\WINDOWS\system32\IMAGEHLP.dll
        Version: 5.1.2600.5512
    Module: msadce.dll
        Base: 0x74060000
        Size: 331776
        Path: C:\Program Files\Common Files\System\msadc\msadce.dll
        Version: 2.81.3002.0
    Module: msadcer.dll
        Base: 0x02870000
        Size: 20480
        Path: C:\Program Files\Common Files\System\msadc\msadcer.dll
        Version: 2.81.1132.0

X002548
Not Just a Number

15586 Posts

Posted - 2009-11-16 : 13:47:12

Are these the guys?

http://www.lytec.com/

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-16 : 13:48:02

DBCC CHECKDB(dbNameGoesHere) needs to be run against to check for data corruption as that error indicates you've got data corruption. Post the entire output of that command in the Data Corruption forum here. Hopefully you've got good backups in place so you can do a restore if needed.

Run DBCC CHECKDB inside Management Studio.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

HolmesChiro
Starting Member

9 Posts

Posted - 2009-11-16 : 14:08:35

quote:
Originally posted by X002548

Are these the guys?

http://www.lytec.com/

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

Yep, that's them.

I'm downloading Management Studio now and will try doing what tkizer said. We back up every day, but hopefully it wont come to that.

HolmesChiro
Starting Member

9 Posts

Posted - 2009-11-16 : 14:25:22

Ok so I downloaded Managment Studio and got the server connected. But I have no idea how to "run DBCC CheckDB." Is there a guide somewherE?

HolmesChiro
Starting Member

9 Posts

Posted - 2009-11-16 : 14:34:10

Ok I googled and I have no idea what I'm doing but I made a "new query" and pasted what I found:

declare database_cursor CURSOR for select name from master..sysdatabases
declare @database_name sysname

open database_cursor
fetch next from database_cursor into @database_name
while @@FETCH_STATUS=0
begin
print @database_name
dbcc checkdb(@database_name) with no_infomsgs
fetch next from database_cursor into @database_name
end

close database_cursor
deallocate database_cursor

and I got this error when I hit execute:

Holmes Chiropractic
Msg 916, Level 14, State 1, Line 9
Server user 'SERVER\Holmes Chiropractic' is not a valid user in database 'Holmes Chiropractic'.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-16 : 14:47:58

Just run DBCC CHECKDB(dbNameGoesHere) in a new query window and change dbNameGoesHere to whatever databse name your application is using.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

HolmesChiro
Starting Member

9 Posts

Posted - 2009-11-16 : 15:25:17

There are a few names listed, this is what I got for each:

DBCC CHECKDB(Holmes Chiropractic)
Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'Chiropractic'.

DBCC CHECKDB(Holmes Chiropractic1)
Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'Chiropractic1'.

DBCC CHECKDB(holmeschiropractic)
Msg 916, Level 14, State 1, Line 1
Server user 'SERVER\Holmes Chiropractic' is not a valid user in database 'holmeschiropractic'.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-11-16 : 15:52:36

DBCC CHECKDB([Holmes Chiropractic])

HolmesChiro
Starting Member

9 Posts

Posted - 2009-11-16 : 15:58:39

DBCC CHECKDB([Holmes Chiropractic])
Msg 916, Level 14, State 1, Line 1
Server user 'SERVER\Holmes Chiropractic' is not a valid user in database 'Holmes Chiropractic'.

:(

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-11-16 : 16:00:31

are you local admin on the box?

HolmesChiro
Starting Member

9 Posts

Posted - 2009-11-16 : 19:09:42

Ermm do you mean admin on the computer? If so, yes. Local admin for the server? I dunno. I just know that the server is on my computer.

HolmesChiro
Starting Member

9 Posts

Posted - 2009-11-16 : 19:10:12

Also I restarted my computer and now the printing works but still doesnt work on computer #2...

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-16 : 19:13:30

Do you have a DBA in your organization that can help you with this? You've definitely got data corruption happening which is not going to be easy to fix unless you have DBA skills.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-11-17 : 03:25:54

If you don't have a DBA, call Microsoft's customer support people and get them to help you through this. It will cost, but you've got serious problem there that needs to be resolved.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources