1276) 9/17/2007 Q243588 INF: Troubleshooting Performance of Ad-Hoc Queries (Q243588)
This article deals with one specific type of performance issue that applications may experience with Microsoft SQL Server -- slow performance of a large number of concurrent ad hoc queries. If you are troubleshooting a performance issue, bu 1277) 9/28/2007 Q198891 INF: Enabling DLL-Based COM Object Execution Outside SQL Server (Q198891)
Microsoft SQL Server 6.5 or later provides the capability to load and run custom Component Object Model (COM) objects through a set of OLE Automation stored procedures or through extended stored procedures. By default, DLL-based COM objects 1278) 9/26/2007 Q224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach (Q224071)
This article describes how to change the location of the data and log files for any SQL Server 7.0 or SQL Server 2000 database. 1279) 9/30/2007 Q234748 PRB: SQL Server ODBC Driver Converts Language Events to Unicode (Q234748)
When using the MDAC 2.1 or later version of the SQL Server ODBC driver (version 3.70.0623 or later) or the OLEDB provider (version 7.01.0623 or later), under some circumstances you may experience translation of character data from the client code page 1280) 9/30/2007 Q283811 HOW TO: Change the SQL Server Service Account Through Control Panel (Q283811)
When you set up SQL Server to run under a Microsoft Windows NT account and you grant permissions to the selected service account through the operating system, SQL Server sets permissions on certain files, directories and registry keys. If y 1281) 10/1/2007 Q274750 HOW TO: Configure SQL Server Memory for More Than 2 GB (Q274750)
This article describes how to configure SQL Server to use more than 2 GB of physical memory. 1282) 9/27/2007 Q303722 INF: How to Grant Access to SQL Logins on a Standby Database When "guest" User Is Disabled (Q303722)
This article describes the procedure to grant access to a database that has been loaded in STANDBY state from another server when the "guest" user is disabled because of security reasons. The information in this article applies only to SQL 1283) 9/27/2007 Q195565 INF: How SQL Server 7.0 and SQL Server 2000 Autostats Work (Q195565)
The newly-introduced statistical maintenance functionality, AutoStat, may generate unwanted overhead on a production system by performing one of the following actions: 1284) 9/29/2007 Q168001 PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
If a dump of a SQL Server user database is restored to a different SQL Server (such as a hot backup server) or to the same SQL Server after either rebuilding or reloading an old version of the master database, user logons and permissions on 1285) 8/9/2004 Q200967 SMS: How to Troubleshoot Advertisements That Are Not Seen by Clients (Q200967)
If an advertisement does not appear on the client or if the advertisement does not run properly, first review the following Troubleshooting Software Distribution steps, as outlined in the Systems Management Server 2.0 Administrators Guide: 1286) 9/30/2007 Q316005 HOW TO: Import XML into SQL Server with the XML Bulk Load Component (Q316005)
Data that is expressed in XML can be loaded into a SQL Server 2000 database by using the XML Bulk Load component. This article outlines the steps that you need to follow to load XML data into a table that already exists in the database. 1287) 9/23/2007 Q269587 INF: Windows Authentication is the Default Security Mode After a SQL Server 2000 Typical Installation (Q269587)
After a 1288) 9/23/2007 Q314783 HOW TO: Plan SQL Server CE Security for Mobile Devices (Q314783)
This guide assists you in developing your Microsoft Internet Information Server (IIS) and SQL Server security plan for mobile devices. As mobile applications begin to increase in number, a solid plan can help avoid some of the pitfalls in s
1
2
.... .... 78
79
80
81
82
83
84
85
[ 86 ]
Previous Page
Page 86 of 86
|