Related posts about sql-server-2000

• sql server 2000 error, error trying to connect to sql server 2005

  as seen on Stack Overflow - Search for 'Stack Overflow'
  i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More

• SQLAuthority News – 2 Security Updates for SQL Server 2000 SP 4 Users

  as seen on SQL Authority - Search for 'SQL Authority'
  If you are using SQL Server 2000 still today my very first recommendation to you is to upgrade to SQL Server 2012. SQL Server 2000 is now 12 years old product and since then many new enhancements as well features which are relevant to current growth and progress in Informational Industry. Now is the… >>> More

• Syncsort's Backup Express Supports SQL Server 2000 and DB2-UDB in SAP Solution Environments

  as seen on Internet.com - Search for 'Internet.com'
  A SQL Server 2000 and a DB2-UDB SAP Solution Environment Integration Assessment of Syncsort Incorporated's enterprise data backup and restore product, Backup Express, asserted that Backup Express provides high value to SAP customers. >>> More

• SQL Server 2000 (8.0) SP 4 crash after load Linked Servers

  as seen on Server Fault - Search for 'Server Fault'
  Hello I configured one Oracle 10g Linked Server on my SQL Server 2000, so two days ago I can view the tables and views, today when I try to check it again I get an connection error, something with latency and time out operation "readsni" in the process of login the sa user. Then I lost all connections… >>> More

• SQL Server 2000 incorrect message: duplicate key with unique index

  as seen on Stack Overflow - Search for 'Stack Overflow'
  Database server: SQL Server 2000 - 8.00.760 - SP3 - Standard Edition I have a table with 5 columns, in which I want to add a large (300.000) number of records. There is a unique index on the combination of two columns. If I add the records with this unique index in place, SQL Server gives this error… >>> More

Related posts about sql-server-agent

• SQL Server Agent Job - Schedule daily except 1 day per month

  as seen on Super User - Search for 'Super User'
  We need to run a daily job using SQL Server Agent (SQL 2000) but we don't want it to run on the 22nd of each month as there are other processes which only run on that day which will clash. The recurring settings in Agent do not provide any exclusion options - is there any way to achieve this? >>> More

• SQL Server Agent Job - Schedule daily except 1 day per month

  as seen on Server Fault - Search for 'Server Fault'
  We need to run a daily job using SQL Server Agent (SQL 2000) but we don't want it to run on the 22nd of each month as there are other processes which only run on that day which will clash. The recurring settings in Agent do not provide any exclusion options, is there any way to achieve this? >>> More

• Auto-start the SQL Server Agent after a computer restart

  as seen on Server Fault - Search for 'Server Fault'
  I am using the SQL Server Agent to run some jobs every day, but the problem is that whenever the server (the machine itself) is restarted, the SQL Server Agent doesn't automatically start when the computer boots back up again...and I have to start it manually myself. How can I set the Server Agent… >>> More

• SQL Server Agent refuses to start

  as seen on Server Fault - Search for 'Server Fault'
  I'm having a problem with SQL Server 2005 where the SQL Server Agent suddenly refuses to start. If I attempt to start it through Services, I get the error "SQL Server Agent (MSSQLSERVER) service on Local Computer started and then stopped." In the Application log, I have the following entry: Event… >>> More

• Monitoring SQL Server Agent with Powershell

  as seen on SQL Team - Search for 'SQL Team'
  This article introduces the reader to Powershell. The application that it demonstrates is one that monitors SQL Server Agent to make sure it is running. >>> More