Browse the core documentation for Microsoft SQL Server 2000 Windows CE Edition version 2.0, the compact database for rapidly developing applications that extend enterprise data management capabilities to mobile devices.

By Mark Vorholt – In today’s ever-changing marketplace, companies are facing a barrage of conditions challenging their traditional database management strategies already in place. Smaller DBA staffs, complex database technologies, tighter budgets, 24 X 365 operating requirements, and a burgeoning DB

Alexzander Nepomnjashiy continues his new series that focuses on SQL Server alerts and errors with a guide to creating new SQL Server alert definitions.

By Sara Cushman – Bob Lawrence knows the pain that comes with accidentally deleting several production IMS databases while they are online in a CICS production system. Now 20 years older and somewhat wiser, Lawrence recalled the scenario, and his recovery from the trauma, for SearchDatabase.com’s Tr

By Michael Otey – Here’s a quick introduction to fixed server roles in SQL Server 2000 and 7.0.

I tried to back up my databases to a file on a network share and restore the databases on the secondary server. I tried to use the net use command to create the share on the target server, but I keep getting the message “There are no available drive letters left.” However, SQL Server Enterprise Mana

SQL Profiler is a great SQL Server tool that can help you reach your database optimization goals. This 10-Minute Solution presents a few preparatory steps to start using Profiler for monitoring performance problems. It discusses some techniques, tools, and commands that reveal information about serv

by Randy Dyess – At one point in time I was tasked with running over 70 databases on more than a dozen servers without any of the costly third-party tools that exist to accomplish such tasks, and I often get asked how can you handle such large numbers of databases. This is a short article that will

This procedure will backup every database on the server including any new ones. It will also delete any old backups after a defined retention period. It differs from production versions in that it will automatically back up any new databases.

Who should read this bulletin: Database administrators using Microsoft® SQL Server™.