SEARCH RESULTS

Useful undocumented SQL Server 2008 distributed queries stored procedures SQL Server 2008 supports the following useful undocumented distributed queries stored procedures: - sp_catalogs_ro...

Introduction   All businesses small and large, must manage the company data in a fashion that allows the business to run smoothly. Some business might use filling cabinets to manage ...

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 SQL Server 2005 Management Studio If you have problems with SQL Server 2005 Management Studio, review this troubleshooting checklist to find potential solutions. 1. Insta...

Troubleshooting SQL Server Command Prompt Utilities If you have problems with SQL Server command prompt utilities, review this troubleshooting checklist to find potential solutions. This article c...

Guys, Pls, Kindly try this insert statement and tell me what's the problem. Everytime I insert this data it gave me an error message Server: Msg 511, Level 16, State 1, Line 1 Cannot create a row o...

Script from our Library

Troubleshooting SQL Server Network Libraries and Protocols 1. Check that you use the latest SQL Server service pack. Because many SQL Server network libraries and protocols bugs were fixed in...

Troubleshooting SQL Server 2005 installation Should you have problems installing SQL Server 2005, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requi...

Microsoft Announces Expanded SQL Server 2005 Product Line to Meet Customers' Growing Demands Microsoft Outlines Enhanced Product Line and Pricing for SQL Server 2005; Dell to Offer SQL Server ...

Security for Developers By: Chuck Urwiler, MCSD, MCDBA These days, some developers are also acting as SQL Server Administrators. Since security can be very complex in SQL Server, many tim...

Using SQL Server Alerts Introduction SQL Server writes the events to the Windows Application log. SQL Server Agent checks the Windows application log for SQL Server events. An alert is an autom...

Diagnosing Poor Data Access Code Using SQL Profiler by Dave Wentzel   I created this article to assist DBAs and application developers who need to optimize data access cod...

Troubleshooting error 17803 The error 17803 occurs when SQL Server cannot perform some operation because there is no memory available to perform this operation. This is the error message text: "I...

Creating a System Tray Application By: Mitchel Sellers - Personal Website/Blog Director of Development IowaComputerGurus L.L.P Many developers have wanted to create an application that r...

Written by: Jeremy Kadlec of Edgewood Solutions   This article is the second installment of a multi-part series detailing the SQL Server Upgrade process from the technical, logistical an...

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...

Heavy Duty LiteSpeed Log Shipping Part 5 Application Failover Strategies By Bill Wunder   In most cases, the reward for a nicely running log shipping configuration ...

Troubleshooting SQL Server Data Types Problems 1. Check that you use the latest SQL Server service pack. Because many SQL Server data types bugs were fixed in SQL Server service packs, you sh...

Troubleshooting SQL Server 2005 Beta 2 installation Should you have problems installing SQL Server 2005 Beta 2, review this troubleshooting checklist to find potential solutions. This article i...