1171) 10/1/2007 Q307487 HOW TO: Shrink the Tempdb Database in SQL Server (Q307487)
This article discusses three methods you can use to shrink the 1172) 9/30/2007 Q294209 HOWTO: Rebuild or Move MSDTC Used With a SQL Fail-Over Cluster (Q294209)
This article describes how to rebuild a broken MSDTC installation for use with a failover clustered SQL installation and how to move the MSDTC clustered resource to a new group. 1173) 9/16/2007 Q254321 INF: Clustered SQL Server Do's, Don'ts and Basic Warnings (Q254321)
This article provides you with some basic guidelines regarding: 1174) 9/23/2007 Q199037 INF: Trapping Error Messages Sent to Clients from a SQL Server (Q199037)
The opportunity to trap error and warning messages sent to a client from the SQL Server can provide powerful information when you are tracking down a problem. 1175) 9/20/2007 Q246133 INF: How To Transfer Logins and Passwords Between SQL Servers (Q246133)
After you move databases to a new server, users may not be able to log in to the new server: 1176) 9/29/2007 Q243589 INF: Troubleshooting Slow-Running Queries on SQL Server 7.0 or Later (Q243589)
This article deals with one specific type of performance issue that applications may experience with Microsoft SQL Server: slow performance of a specific query or group of queries. If you are troubleshooting a performance issue, but have no 1177) 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 1178) 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 1179) 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. 1180) 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 1181) 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 1182) 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. 1183) 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 1184) 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: 1185) 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
1
2
.... .... 72
73
74
75
76
77
78
[ 79 ]
80
Previous Page
Page 79 of 80
Next Page
|