.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

Debug SQL 2000 mini dump file

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :Sql Server
Hello, Lately i inherited a sql 2000 sp3a  server with issues (server hangs).On checking the logs i found the non yielding scheduler error(17883) in SQL logs during backups. So i applied SP4 and security patch KB948111 but i still see the non yielding scheduler error in our logs while backing up 2 of our production databases. Process 93:1 (1498) UMS Context 0x064C8888 appears to be non-yielding on Scheduler 7. SQL Version: Microsoft SQL Server  2000 - 8.00.2273 (Intel X86)   Mar  7 2008 22:19:58   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) I debug the dump file with windbg but could not understand what it means. 000af5d4 7c827789 77e418b6 00000098 00000000 ntdll!KiFastSystemCallRet 000af5d8 77e418b6 00000098 00000000 00000000 ntdll!ZwReadFile+0xc 000af640 7d1f5edb 00000098 000af704 0000021a kernel32!ReadFile+0x16c 000af66c 7d1f5f82 00000098 000af704 0000021a advapi32!ScGetPipeInput+0x2a 000af6e0 7d247667 00000098 000af704 0000021a advapi32!ScDispatcherLoop+0x51 000af924 006ebec2 000af93c 00000000 00000000 advapi32!StartServiceCtrlDispatcherA+0x93 000aff60 0058bf6e 00000001 002a44a8 002a29e8 sqlservr!main+0x31d 000affc0 77e6f23b 00000000 00000000 7ffd5000 sqlservr!mainCRTStartup+0x143 000afff0 00000000 0058be46 00000000 78746341 kernel32

View Complete Post

More Related Resource Links

Bugslayer: Mini Dump Snapshots and the New SOS


In debugging some large Microsoft® . NET Framework-based ap-plications over the last few months, I've been spending more time looking at mini dumps than at live processes. This is mainly because in those large applications problems surface when the apps are running in production and not on test systems.

John Robbins

MSDN Magazine March 2005

Fax Services: Send Any Printable File From Your Program in Windows 2000


All versions of Windows 2000 have fax services built in, so sending faxes manually is as easy as setting fax options from the control panel. Faxes can also be sent programmatically in Windows 2000 using either COM Automation or the standard C API. The example in this article uses COM Automation with Visual Basic and MFC to programmatically manage faxing. The objects used for fax transmission, such as the FaxServer and FaxDoc objects, as well as their properties and methods, are explained. Because faxing of files you can't print can be problematic, this process is explained. Finally, this article implements a fax routing extension-a plug-in that exports standard functions and implements routing methods for processing received faxes.

Marcin Kaluza

MSDN Magazine August 2001

.Net 4 - Generate dump file, improved debuging

Hi, For the system we are developing, we need to be able to generate a crash dump file in case things go bad. The application is being implemented using .Net 4 C# WPF. In the past (.Net 3.5) we were using a number of methods from the "dbghelp.dll" and "kernel32.dll" unmanaged dlls in order to generate a crash dump and WinDbg in order to investigate it. I was wondering if .Net 4 (and Visual Studio 2010) brought anything that would help us stay away from unmanaged code and make the dump file investigation easier (especially when multithreading operations are involved). Any suggestions and links would be appreciated. Thank you for your time, Cristian

Inserting a Binary file in SQL Server 2000

Hi all, I want to store a native binary file into the DB having the column datatype as 'image', in SQL Server 2000, through SQL Query. I have found the solution for the case of 2005, thet is using the OPENROWSET and BULK. Can you please help me out in constructing the SQL or TSQL Query for performing that operation? Thanks a Bunch in Advance :)

Insertion of a Binary File in SQL Server 2000

Hi all, I want to insert a binary file into the SQL Server 2000. The type of the column reserved for the file is of 'image' datatype. I have found the solution for the SQL Server 2005 and later, using the open rowset. Can you please give me a SQL/T-SQL Query for the operation? Thanks a bunch in advance :)

Need help with SQL 2005 Dump file.


Hi Everyone,

Last night non- yielding scheduler error was logged in one of our production SQL databases during backup. SQL version is SQL 2005 standard edition(32 bit) SP3.

I debug the dump file but couldn't interpret it.

Could this issue be fixed by applying Cumulative update 1 for SQL 2005 SP3?




2010-09-21 20:46:49.13 Server      ***Unable to get thread context - no pss
2010-09-21 20:46:49.13 Server      * ******************

reading text file using sql server 2000 , 2008



can any one tell me how to read the data's in the text file using sql server 2000 and 2008.

i have a text file in a server and it contains one column name with the multiple column values i need to read that informations and i need to update in a table in the database.

how can we do this.



how to send the dump file to Microsoft, is this a pay service?


Since my SQL2000 server has the "insufficient memory error 701" when doing tlog backup, it happens randomly, I applied the hotfix, increased physical memory from 2GB to 8GB with awe enabled, max server memory 6GB, it still happens sometimes when backup less than 100MB log (active log should be less than it). I tried incrase memtoleave g512 and .... whatever suggested on the forums etc. the problem still not fixed permanently.

I was suggested to dump the sql and send microsoft, but how and is there a charge?


web.debug.config file are gone



When I want to build my website it complains the web.debug.config file cannot be copied.

I can't find this file, how can I restore it?
I do have a web.config file!



Unable to copy file "obj\Debug\Project.dll" to "bin\Project.dll"


Hi. This is really flustrating. When i compile my WebApplication, it works normally. But when i do refresh in browser, than IIS somehow "locks" that dll file and another compilation ends with this error:

Unable to copy file "obj\Debug\Project.dll" to "bin\Project.dll". The process cannot access the file 'bin\Project.dll' because it is being used by another process.

After restarting application pool in IIS, it's released and i can compile in standard way. I tried use handler.exe from sysinternals and it shows, that w3wp.exe process is using that dll. It's very time consuming before every compilation restart IIS. Any ideas where can be a problem please ?

Microsoft Windows Server 2003 Standard Edition SP2
IIS 6.0 

Microsoft Visual Studio 2005 Professional
Version 8.0.50727.762  (SP.050727-7600)
Microsoft .NET Framework
Version 2.0.50727 SP1
Microsoft Web Application Projects 2005
Version 8.0.50727.762
Microsoft Visual Studio 2005 Professional Edition - ENU Service Pack 1 (KB926601)

How to debug into dll source file from web project


I have web project and window project.Web project reference from window project and I want to debug from web project to source code in window project. Where do I setup to look for debug source code in window project.

I copied all source code from another computer. but on another computer can debug just fine.All that different is where the source file is located. so I think it should have some config in studio that tell where the source file is.

Need to verify inital file sizes SQL 2000


Hello  I need to verify the initial file sizes on the DB  and TX   files in a SQL server 2000 Database...any clues ?




Problem redirect debug output to a file using trace listener


I have created a debug listener to redirect the output from the Debug/Console window to a file(with a call stack), using the following code:

void SomeMethod()
    // Create a file for output .txt.
    Stream debugFile = File.Create(fileName);

    // create TextWriterTraceListener named "file"
    TextWriterTraceListener debugWriter = new TextWriterTraceListener(debugFile, "file");

    // add to debug listeners
    // set callstack to be shown
    Debug.Listeners["file"].TraceOutputOptions |= TraceOptions.Callstack;
    // set auto-flush
    Debug.AutoFlush = true;

but the output won't redirect to the file I specified, it is always empty. I am calling this from the constructor in my main form. Is the place where I'm calling it from a problem?

What I am trying to achieve here is to have the exceptions from the Debug output window placed in a file with a call stack, so that I can find them and correct them.

Anyone have any ideas?

Bojan Skr

How to recover from mdf file (SQL Server 2000)



My database corrupted because when I was running an update query, there is a power failure. After the computer booted, I cannot open the database anymore, it just not responding. Then I stop the sql server service, and tried to rename the .mdf and .ldf. After that it worked normally, but I need the data from the corrupted mdf file, I tried to attach the database but it just hanged. I even tried to attach without the .ldf file but it didn't work either, so I concluded that the problem is with the mdf file.

Is there any way to recover my data ??

Thanks in advance



unable to open file Obj/debug/application.g.resources


When I started a new WPF Application and build it without modifying anything on it  I am getting an error BC31027

Unable to Open file WPFApplication1/obj/Debug/wpfApplication.g.resources : System Error &H80070002&

When I build an existing application which was working fine it thows the same exception 

But when I start a new windows application and build it , it just works fine

Restoring a SQL Server 2000 database having only the .mdf file


Hi all,

SQL Server 2000, I need to restore a database, I've only the .mdf file, note that the database was not gracefully detached, so the sp_attach_single_file_db fails. Is there any other way?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend