Viewing 15 posts - 1,996 through 2,010 (of 2,387 total)
In most situation, The memory should be configured dynamically to allow SQL Server to adjust memeory allocation as it needs. But if you have large amount memory in your machine,...
April 16, 2003 at 6:53 am
Which version of SQL Server you are running? If it is 7.0, check KB http://support.microsoft.com/default.aspx?scid=kb;en-us;196292
April 15, 2003 at 2:54 pm
I would ask NT / network administrator to monitor the network connection between your SQL Server and the server that keeps your database backups during your monthly backup jobs run...
April 15, 2003 at 2:38 pm
isqlw takes only few MBs memory and it releases it once you close the QA. You have to check other processes/services that might hold your machine memory. Check the memory...
April 15, 2003 at 2:33 pm
Have you tried to setup SQL Server Agent Proxy account for those users who do not have 'sa' right to execute CMDExec job step? Grant user with 'sa' previlege is...
April 15, 2003 at 10:01 am
Run dbcc sqlperf(logspace) to see how large TEMPDB transaction log is and spaces used.
TEMPDB should be in "simple" recovery mode.
You should allocate more spaces for both TEMPDB data and log...
April 15, 2003 at 9:53 am
Can you select those records with statement like
select * FROM JDSPWPDTA.MWRA.JDSPWPDTA.F3460
WHERE MFUSER = 'FRCURFLOW' AND MFJOBN = 'FRCURFLOW' AND MFPID = 'FRCURFLOW'
Do you setup linked server with Microsoft Host...
April 15, 2003 at 9:20 am
I think srvid = 0 and isremote = 0 are sufficient.
April 15, 2003 at 8:11 am
Which SQL Server version do you run in this PC? MSDE? When you quit QA, you shouldn't see process "isqlw" in task manager unless you have multiple QA running. I...
April 15, 2003 at 8:07 am
I think you are right by using srvid = 0 and isremote = 0 to identify the local server.
Why you can't use @@servername?
April 15, 2003 at 7:58 am
Run server network utility --> highlight TCP/IP network library --> click EDIT button --> verify "Proxy Address" is empty or not. I think a Proxy Address is set to the...
April 15, 2003 at 7:50 am
Was this SQL Server upgrade from SQL Server 6.5 to 7.0? Following KB articles may help.
http://support.microsoft.com/default.aspx?scid=kb;en-us;293107
http://support.microsoft.com/default.aspx?scid=kb;en-us;329878
What is the MDAC version? Have you considered apply latest service pack?
April 14, 2003 at 2:56 pm
Do your DTS packages send SQL Mail / access network files? Any changes in SQL Server Agent service and proxy accounts? Were both steps failed and can you run them...
April 14, 2003 at 2:39 pm
Did you alrady run dbcc checkdb before rebuild the indexes?
April 14, 2003 at 2:30 pm
Do you see an entry "Using 'SSMSSO70.DLL' version '7.0.xxx' to listen on '1433'" in SQL Server errorlog? Or any error messages?
April 14, 2003 at 2:26 pm
Viewing 15 posts - 1,996 through 2,010 (of 2,387 total)