March 30, 2005 at 3:56 am
Hai,
I am having a view which is a union of two other views. When i executed this view for the first time, i got the following error:
Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
Then i executed the statement,
SET NUMERIC_ROUNDABORT OFF GO SET ANSI_PADDING,ANSI_WARNINGS,CONCAT_NULL_YIELDS_NULL ,ARITHABORT,QUOTED_IDENTIFIER,ANSI_NULLS ON GO
and recreated the view.
But now i get the following error:
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 52 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
After two or three days this view works fine. Could anyone let me know why this problem comes
Thanks & Regards,
K. Sripriya
March 30, 2005 at 5:24 am
Unfortunately, I don't think we can add much without seeing the view(s) to help diagnose your problem..
Good Hunting!
AJ Ahrens
webmaster@kritter.net
March 31, 2005 at 4:11 am
Creating view on top of view is inherently ineffecient. You are better off creating a new view referencing the underlying tables. Also be aware of broken object ownership chains.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply