Frequency of witness pings to partners
Does anyone know how often the witness instance pings the partners? I am aware of the timeout setting but want to know exactly how often the ping is initiated. Is it the same or different from the timeout value. Thanks in advance for your reply.

Answer Question   |  May 4, 2011  6:59 PM
Network Timeout, SQL Connection Timeout, SQL Server 2005 SP3, SQL Server 2008 R2

How do you set a SQL Server job step status?
I am running SQL Server 2005. I have a job that has six steps to load a database table from an external source. The external source is required to send the file nightly. In system testing I found this is not always the case. I created a batch ‘step’ (Step 3) to check if the [...]

Answer Question   |  January 17, 2011  11:28 PM
SQL Jobs, SQL Server 2005, SQL Server 2005 SP3, SQL Server database

Cannot forward events from SQL Server 2005
I’m trying to forward events from SQL Server 2005 SP3 to a different server, but the only server I can select is the local server.  What must I do to see other servers in the Event Forwarding Server drop-down box?

Answer Question   |  November 1, 2010  4:03 PM
SQL, SQL Server 2005, SQL Server 2005 SP3, SQL Server Agent

SQL Server 2005 Enterprise Edition SP3 Performance
We have SQL SERVER 2005 SP3 Enterprise 32-bit running on a windows server 2003 Enterprise 32-bit with 32GB of RAM and 8 dual core processors. Our CPU, RAM, and I/O are always through the roof and the application is always running slow. We use AWE for buffer cache the maximum memory is 28GB, the PAGEIOLATCH_SH [...]

Answer Question   |  January 31, 2011  3:27 AM
SQL, SQL performance, SQL Server, SQL Server 2005, SQL Server 2005 SP3, SQL Server Enterprise Edition

Sharepoint 2010 x64 central administration problem http error:503. The service is unavible
Hi. I installed Sharepoint 2010 x 64 version. My sql server is Sqlserver 2005 + Sp3+ hotfix. I confingured sharepoint central administration with NTLM. When i tryed open central administration it gives me Service Unavailable   HTTP Error 503> the service is Unavailable . My operating System is windows 2008 server enterprise edition x 64 I did [...]

Answer Question   |  August 1, 2011  8:13 AM
Sharepoint 2010, SharePoint 2010 deployment, SQL Server 2005 SP3, VMware ESX 4.0, Windows Server 2008 Enterprise x64 Edition

SQL server SP3
Security Update for SQL Server 2005 Service Pack 3 (KB970892) .. i cant get this update to work on my comp..soemthing about hotfix.exe error

Answer Question   |  July 13, 2010  12:21 AM
SQL Server 2005, SQL Server 2005 Service Pack 3, SQL Server 2005 SP3, SQL Server Updates

How to find who called a stored procedure
I would like to know what process or stored procedure called one of my stored procedures. Is there any way of getting this information from SQL Server 2005? Thanks in advance, Ed

Answer Question   |  May 28, 2010  2:37 PM
SQL Server, SQL Server 2005, SQL Server 2005 SP3, Stored Procedures

SQL Server 2005 SP3 installation on Vista – error message
A user recently submitted this question via e-mail: This Program has known compatibility issues. Check Online to see if solutions are available from the Microsoft website. If solutions are found, Windows will automatically display a website that lists steps you can take. Program: Visual Studio 2005 Publisher: Microsoft Visual Studio 2005 has a known compatibility [...]

Answer Question   |  March 17, 2009  7:25 PM
SQL Server 2005, SQL Server 2005 SP3, SQL Server on Vista, SQL Server upgrades, Vista