If you check out this link http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B196909 it states thet the configure option is on 2000 EM. For SQL7 you have to create the following key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\NumErrorLogs Since the question did not specify a version of SQL and I am on SQL7, technically none of the answers are correct (unless answer 4 is a typo?)
2003-06-13
Inside Microsoft SQL Server 2000 by the folk at redmond explicitly states answer 3 as being the way to do it. => It should be marked as correct for those that got it. boy is my head hurting this morning
2003-06-13
Kraks, Here are some of the most common sql-related perfmon monitors: Memory: Pages/Sec Memory: Available Bytes Physical Disk: % Disk Time Physical Disk: Avg. Disk Queue Length Processor: % Processor Time System: Processor Queue Length SQL Server Buffer: Buffer Cache Hit Ratio SQL Server General: User Connections If you suspect the disk subsystem is the […]
2003-06-11
2 reads
hmmmm....always worked fine for me...just rechecked it and it worked - what I used was sp_Compare2Tables 'WADemo.wa.TabCompare1','WALive.wa.TabCompare2',1,0 and the stored proc is created in WADemo database... <Debug mode on> the script uses PARSENAME to get the server,DB,schema and table names....and the error you specified occurs in the following block of code in the SP : […]
2003-06-11
Aggree with Pitiyar and all you who say that changing HOLDLOCK to UPDLOCK would be the most appropriate measure.
2003-06-11
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-06
How you are connecting to the server? Terminal server? Remote Desktop? Is the tools installed on the server? Also if yes try changing the protocol
2003-06-03
quote: Does the Index Tuning wixard effect performance whilst you are running it? or should I wait until out of hours to run it ? It does put a load on the system so I would suggest an after hours approach.
2003-06-03
1 reads
2003-06-02
Not sure if I understand you problem, but a good starting point as ever is Books Online. for more advanced examples try any SQL book or have a look at the scripts on this site.
2003-05-30
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers