Stored Procedure Invalid Column Errors (12/14/2005)
I am having a weird error with this stored procedure. I got this code from an associate who claims that this executes on his system with no errors. When executed on my system I get the following error...
Stored Procedure Invalid Column Errors (reply) (12/14/2005)
"Look closely at the step that is updating the current records in the FinancialCSV table. The column names in the update and the following insert seem to differ."
Sometimes it takes someone else to...
Unwanted Activity on SQL (12/16/2004)
I am running w2k server and sql2k. Here is the issue I am having. This is some line from a command prompt, netstat -a command:
TCP sql1:ms-sql-s 210.116.119.132:5388 TIME_WAIT
...
SQL Server Profiler Optimization Tips (4/14/2004)
SQL Server Profiler Optimization Tips
Run SQL Server Profiler during periods of low database access. Because SQL Server Profiler puts a large load on SQL Server, try to run it during CPU idle ...
Troubleshooting SQL Server Agent Procedures (7/12/2006)
Troubleshooting SQL Server Agent Procedures
This article describes the problems you can have with SQL Server 7.0 and SQL Server 2000 Agent stored procedures.
1. Check that you use the latest S...
Troubleshooting SQL Server Query Analyzer (6/23/2004)
Troubleshooting SQL Server Query Analyzer
1. Check that you use the latest SQL Server service pack.
Because many SQL Server Query Analyzer bugs were fixed in SQL Server service packs, you sho...
Troubleshooting SQL Server Upgrade Wizard (3/2/2005)
Troubleshooting SQL Server Upgrade Wizard
1. Check that you use the latest SQL Server service pack.
Because many SQL Server Upgrade Wizard bugs were fixed in SQL Server service packs, you sho...
Tips for using SQL Server 2005 Profiler (5/16/2007)
Tips for using SQL Server 2005 Profiler
Use SQL Server 2005 Profiler to capture events raised by Analysis Services and
Integration Services.
Using SQL Server Profiler to monitor Analysis Ser...
Known SQL Server service packs problems (8/17/2005)
Known SQL Server service packs problems
Usually SQL Server service pack fixes all known bugs, but sometimes it can produce new bugs, which fixed by next service pack, and so on. In this article, y...
Troubleshooting Upgrading to SQL Server 2005 (1/17/2007)
Troubleshooting Upgrading to SQL Server 2005
Should you have problems during upgrading to SQL Server 2005, review this troubleshooting checklist to find potential solutions.
1. Check the hardw...
SQL Server connection over WAN (9/9/2005)
Hello together
If problems connecting to a SQL Cluster Server named instance running on Windows 2003 Server over a WAN link - From Europe to Sao Palo. The application and SQL Enterprise Manager ...
ErrorLogs (10/5/2005)
3 question
------------------------------------------------------------------
First question
I have 3 jobs scheduled in maintenance plan.
1. Optimizations (DBCC ) - every sunday at 12:00am
2....
Using SQL Server 2008 Extended Events (6/10/2009)
(Jonathan Kehayias) As SQL Server matures with time, the diagnostics tools available to administrators to troubleshoot problems when they arise have also matured. SQL Server 2000 had very limited diag...
Troubleshooting SQL Server Enterprise Manager (7/7/2004)
Troubleshooting SQL Server Enterprise Manager
1. Check that you use the latest SQL Server service pack.
Because many SQL Server Enterprise Manager bugs were fixed in SQL Server service packs,...