Warning: Fatal error 7987 occurred at Apr 10 2006 9:18AM猠楡⹤䄠牰汩椠⁳敤楳湧瑡摥愠⁳慎楴湯. Note the error and time, and contact your system administrator.
And upon checking the SQL logs we are seeing everytime a specific simple query is run:
A possible database consistency problem has been detected on database 'allscoopdb'. DBCC CHECKDB and DBCC CHECKCATALOG should be run on database 'allscoopdb'..
We had this problem once last week, and a reboot fixed it. The error is coming up everytime we run a specific sql query against the allscoopdb database. We have been running this query for over a year with no problems.
I've run the DBCC CHECKDB and it has returned no errors. Do you think there could be some kind of hardware problem? Or what else can I do to figure out what the problem is?
We are running MSSQL 2k on a big box. It's a quad box with 16 gigs of RAM with a SAN device. We are using managed hosting at RackSpace.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…