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 2005 Forums
 Transact-SQL (2005)
 Dynamic Query Problem

Author  Topic 

malaytech2008
Yak Posting Veteran

95 Posts

Posted - 2008-10-29 : 13:50:28
Hi,
I have written a dynamic query to filter out some records from database.But after excuting query few minutes later it shows this error.

SqlDumpExceptionHandler: Process 94 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
[DBNETLIB]ConnectionCheckForData (CheckforData()).
[DBNETLIB]General network error. Check your network documentation.

I m not able figure out why this error is showing.
your help is always appreciated.
Thanks in Advance.

malay

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-10-29 : 15:25:43
Can you move this thread to another location - maybe "New TO SQL Server" or TransacT SQL 2000 or 2005?

Do you have reexecuted that statement. It could be a temp. network problem...

Webfred


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

malaytech2008
Yak Posting Veteran

95 Posts

Posted - 2008-10-30 : 02:11:09
quote:
Originally posted by webfred

Can you move this thread to another location - maybe "New TO SQL Server" or TransacT SQL 2000 or 2005?

Do you have reexecuted that statement. It could be a temp. network problem...

Webfred


No, you're never too old to Yak'n'Roll if you're too young to die.



How can I move to other forums?
Do u have any idea why above error occurs.
plz can u help on this?

malay
Go to Top of Page

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2008-10-30 : 05:20:31
1 Quick google brings up this:

http://www.egilh.com/blog/archive/2004/10/29/292.aspx

Looks like they tried changing datatypes and then there is a link to changing some settings for multi processor systems.

Have you checked this out all-ready?

-------------
Charlie
Go to Top of Page
   

- Advertisement -