Did you ask other users to leave away from the database?

net start mssql

If the server is running, you will get an error: the server has been already started. You may start from there.

It might be the memory leak, a problem Microsoft is facing for a long time. Here are some links for your references.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=372940&SiteID=1

http://support.microsoft.com/kb/918643

It seems that Microsoft does not have...

I think so. I post this question because I do not know the configuration, neither do most network engineers here. I do not expect exact answers but possible solutions.

Thank you...

Just my penny.

Are you familiar with MS VB? It is pretty much similar to VBScript. If so, you can write code to link SQL Server, retrieve data from there, and...

Did you check the program, wintime32?

Thank you all for your input.

The solution was found. Some people changed the master database. The errors were gone after restoring master database.

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

You can use SQL Server profiler for sure. But it is also a performance killer unless you can well define your problem.

You can also use the store procedure, sp_who or...

Did you try this article?

http://knowledgebase.datadirect.com/kbase.nsf/SupportLink+Online/2475396BD?OpenDocument

How about

master..xp_cmdshell 'copy \\171.186.147.94\Apps\MTX\JRun\logs\default-out.log \\171.186.147.94\Apps\MTX\JRun\'

Your script may be ok to your current situation, but it not enough to include all other situations. You need to use status > 511 and status <1024 instead instead...

Could you think in the way?

528 = 512 (Offline) + 16 (Torn Page Detection)

536 = 512 (Offline) + 16 (Torn Page Detection) + 8 (Trunc. Log on Chkpt)

To avoid all...

Did you refresh your GUI?

Do you want to try this one:

CREATE TABLE #tmp (strData VARCHAR(1000))

INSERT INTO #tmp EXEC xp_cmdshell 'dir c:\myFile'

SELECT * FROM #tmp WHERE strData LIKE '%/%/%'

DROP TABLE #tmp