I want to schedule a Microsoft Visual Basic® 6.0 executable (.exe) program by using the SQLAgentCMDExec account to create a job through SQL Server 7.0 Enterprise Manager. The .exe program should use universal naming convention (UNC) paths to create a file on a shared directory on the SQL Server 7.0

By Heather Clancy & Paula Rooney – Microsoft is slashing the price of its forthcoming entry-level Windows Small Business Server 2003 to $599 and will hike the head count limit on both the Standard and Premium editions to 75, Microsoft executives said at the XChange Conference 2003 Monday.

Text, ntext, and image data have been around a long time, but their nuances can be easy to overlook. In this tutorial, Joseph Gama provides a quick overview of the implementation and usage of these special data types.

This code will generate code to do a column-by-column comparison against a table, assuming that you are joining the inserted table (aliased as “i”) with the deleted table (aliased as “d”) in a trigger:

By Lisa Vaas – A worm code-named “Voyager Alpha Force” that targets Microsoft Corp. SQL Server databases is roaming the Internet, trying to turn insecure database servers into launching pads for applications running out of FTP sites in the Philippines.

by Sayed Geneidy – Learn the basics of how to use Performance Monitor to optimize your SQL Server hardware.

Unchecked Buffer in MDAC Function Could Enable System Compromise (823718)Who should read this bulletin: Customers using Microsoft® Windows® Impact of vulnerability: Run code of the attacker’s choiceMaximum Severity Rating: Important Recommendation: Users should apply th

Learn how you and your users can use ASP.NET and the free Microsoft Visio Viewer to search an online SQL Server data dictionary.

Setup for a Microsoft SQL Server 2000 virtual server may fail and you receive the following error message: Only one usage of each socket address (protocol/network address/port) is normally permitted.

By Brian Moran – When you look at how few changes have been made to the MCDBA program, you have to assume that Microsoft prefers a certification program that boasts a large number of minimally trained individuals rather than a lower number of highly skilled professionals.