Search results for query: *

It is possible that the 2000 server has been set up to authenticate users by calling them back. For example for support purposes I will dial in from home to log in the server has my number as a registered administrator so the server will call me back to allow me access to the systems using...

how many times an hour are the pages hit i.e. is the asp doing an insert every time any page is hit which would cause each users to have multiple hits or not?

If this is UDB then i've seen something similar with the Fix pack on WIN 2K can i suggest you look at the Fixpack sometime IBM fix one thing using a Fixpack that actually breaks something else. Also which fixpack were you running on previously.

yes, yes, yes, yes, no reboot as system is critical to multiple applications and linked servers. The system was live when the problem occurred but nothing unusual was happening on SQL.

Hi, I've just had one of the strangest errors I've yet to encounter. On of our systems has about 2000 connections and yesterday the users reported that the system was running slow. Checked the DB no errors, DBCC check Table etc still no faults anywhere on the system. Admins checked server -...

Hi, Your first ratio is fine although your Cache Manager Cache Hit ratio is far too low. Ideally the hit ratio should be 90% or above if not try allocating more memory to SQL or if the system memory is maxed out for SQL add more ram to the machine.

your definately running SQL 2000? The reason I ask is microsoft report this error as a fault with SQL 7 see the following link for details. http://support.microsoft.com/default.aspx?scid=kb;en-us;232522

use SQL MAIL. Install Outlook on the SQL Server, Set up a new mail account e.g SVRXXMail, Configure SQL Mail on your server and hey presto. Look at the Books online for your version of SQL for more info.

As far as I recall, I think you need the ODBC driver for FOXPRO DBC installed on the SQL server. You should then be able to select this from the dropdown of connections.

SQL 7 and 2000 allow you to hide or show certain colums, by clicking on the column title you can sort by that column name and you can hide or show toolbars, view as detail, list etc (similar to Explorer). For your purposes clicking the column title will sort by that field.

Logic would dictate that as long as the jobs exists then if it does not have a status of 0,1,2 or 3 then it must be in status 4. I would suggest modifying your code so that if a sysjobs exists and does not have one of the first 4 status's then it is shown as having a staus 4. There is not...

below is an example of the backups we run on a daily and hourly basis. as you can see there are a few more steps involved. As you will see the hourly transaction log backup is the last step in the nightly job. Print '***Starting Nightly Routine***' select 'Time Now: ' + convert(varchar(20)...

This is a very open ended question. Every application, database and server are different. As an example I run one cluster of servers dedicated to a single Enterprise solution consisting of a C++ client running 2000 connections to a SQL 7 Server backend. On the other hand I administer a SQL...

As Microsoft mention as long as this is happening out of hours all you can really do is live with the problem. However, it may be worth checking when your nightly jobs run to ensure there is no outage caused by the problem i.e. allow an extra half hour for the job + this 'Feature' to run.

Found the Answer! FYI, Its to do with the version on Outlook on the machine and a Microsoft security patch. http://support.microsoft.com/default.aspx?scid=kb;en-us;263556 Outlook 2000 Client This client can be used with SQL Server 6.5, SQL Server 7.0, and SQL Server 2000. Microsoft Outlook...

Corran, tried that as well , no joy. TB, Successful, as i said notification can automatically send emails its just xp_sendmail etc that wont play ball.

Hi, Ive recently been trying to get SQLMAIL working on a SQL7 Server. I have successfully set it up to the point where i can notify administrator of failed jobs and alerts using notify so the SQL Agent mail seems to be working fine. However, if i run query analyzer and do a XP_SENDMAIL it...

change you lock setting back to the original setting and then gradually increase until you have a workable amount of memory. Bear in mind that the memory allocated to SQL should still leave 128mb for the operating system to run. The amount of memory that can be allocated to SQL varies depending...

The Windows NT Resource Kits, both NT4 and Windows 2000 Professional, include a remote kill process commandline utility rkill.exe . To be able to kill a process or processes running on a remote server, you must have admin privileges and the rkillsrv.exe service must be installed and running...

backup transaction dbname with no_log