|
|
|
|
|
|
| | Total Hits: 321 | Today: 0 | | Rating:  |
| | 
This step-by-step article describes how to identify the cause of recompilation in an SP:Recompile event.... |
| | Total Hits: 970 | Today: 1 | | Rating:  |
| |
When you connect to Microsoft SQL Server from the Active Server Pages (ASP) using ActiveX Data Objects via named pipes, the client computer must be validated by SQL Server to use the named pipe. If SQL Server is on a different physical computer than the ASP files, the Active Server Pages might fail. By default, Internet Information Server (IIS) attempts to connect to the SQL Server anonymously. To do this, it uses the anonymous logon information provided in Internet Service Manager (Inetmgr.exe)... |
| | Total Hits: 269 | Today: 0 | | Rating: |
| |
An APPC transaction program may cause Host Integration Server 2000 to log multiple Event ID 8 messages and cause CPU utilization to reach 100 percent.
Details of the Event ID 8
Event Type: Warning
Event Source: SNA Server
Event Category: None
Event ID: 8
Description:
(1174) Internal Protocol Violation
EXPLANATION
A protocol violation has occurred at the interface between the SNA
Service and another SNA component (for example, the emulator or link
service).
SUBCODE INFORMATION
X'1105' Insufficient space to copy data into node buf..Read More.. |
| | Total Hits: 393 | Today: 0 | | Rating: |
| |
The rebuilding of the Pubs database requires Instpubs.sql to be executed. This script file rebuilds the database and the objects in the database. However, the data loading is not complete until Pubimage.bat and Pubtext.bat files are executed. These two files complete the text and image data load into the Pub_info table (which is new in SQL Server 6.0). All the files are located in the \Install directory. The rebuilding of the Pubs database requires Instpubs.sql to be executed. This s... |
| | Total Hits: 5467 | Today: 0 | | Rating: |
| |
This article demonstrates three methods of calling a stored procedure from Active Server Pages using ActiveX Data Objects (ADO).... |
| | Total Hits: 316 | Today: 0 | | Rating: |
| |
When you use the SUM or AVG aggregate function with division, the
result loses precision. The loss of precision occurs regardless of
whether you use a numeric or decimal datatype.... |
| | Total Hits: 112 | Today: 0 | | Rating:  |
| |
A loss of INSERT commands into child tables at a subscriber may occur under the following conditions:
- The merge replication topology is hierarchical, with a publisher, one or more republishers, and one or more subscribers.
- One or more parent and child articles exist in a merge replication publication, with a join filter defined between them.
- A NOT FOR REPLICATION foreign key constraint exists at the republisher and subscriber for the relationship betwee...
|
| | Total Hits: 935 | Today: 0 | | Rating:  |
| |
This article explains and illustrates the use of the following Linear Regression functions in a calculated member:
- LinRegIntercept
- LinRegPoint
- LinRegR2
- LinRegSlope
- LinRegVariance
MORE INFORMATION
Linear Regression is a statistical method that predicts the value of one variable, based on knowledge of another variable and the statistical relationship between the two. The Linear Regression functions use the...
|
| | Total Hits: 588 | Today: 0 | | Rating: |
| |
This step-by-step article describes how to move SQL Server user databases and most common SQL Server components between computers that are running SQL Server.... |
| | Total Hits: 366 | Today: 0 | | Rating: |
| |
This article deals with one specific type of performance issue that applications may experience with Microsoft SQL Server: the run-time recompilation of stored procedures. If you are troubleshooting a performance issue, but you have not determined that this is the precise source of your problem, refer to the following article in the Microsoft Knowledge Base before proceeding:
... |
| | Total Hits: 247 | Today: 0 | | Rating: |
| |
This article describes how to configure SQL Server to use more than 2 GB of physical memory. Microsoft SQL Server 7.0 and Microsoft SQL Server 2000 dynamically acquire and free memory as needed. When you run multiple instances of SQL Server on a computer, each instance dynamically acquires and frees memory to adjust for changes in the workload of the instance.... |
| | Total Hits: 157 | Today: 1 | | Rating: |
| |
This article uses a question and answer format to identify common problems you may encounter when you work with SQL Mail and provides you with some tips on how to correct or troubleshoot these problems. The vast majority of SQL Mail related problems are due to an improper configuration. For additional information on how to correctly configure SQL Mail,... |
| | Total Hits: 349 | Today: 0 | | Rating: |
| |
If SQL Server is hit with multiple and simultaneous TCP/IP connection requests, such as the case with World Wide Web servers, the requests are quickly rejected by responding with a TCP/IP Reset Frame.... |
| | Total Hits: 2983 | Today: 0 | | Rating: |
| |
This article describes how to handle errors in DTS Package and Step objects by using the GetExecutionErrorInfo method call, OnError event and Visual Basic Err object.... |
| | Total Hits: 414 | Today: 0 | | Rating: |
| |
The impact of logging Internet Information Server (IIS) activity to disk is minimal compared to logging it to a SQL Server database. The performance impact of logging to SQL Server is greater and depends on the SQL Server implementation and the hardware you use. See your SQL Server documentation for more information on increasing performance.... |
| | Total Hits: 418 | Today: 1 | | Rating: |
| |
SQL Server allows you to choose from a number of different network libraries that you can use when connecting. You can configure these network libraries when you create a data source name (DSN) for your data source. However, an alternative way to specify the DSN is to pass in the network library, which you want to use, with the connection string. This article describes how to specify the network library that you want to use for connecting to SQL Server when connecting from a Visual Basic applica... |
| | Total Hits: 459 | Today: 1 | | Rating: |
| |
The SQL Server Data Transformation Services (DTS) packages may need to be executed from remote locations. Using Active Server Pages (ASP), you can execute from remote locations over the intranet or Internet, because ASP is an automation client for the Component Object Model (COM) components and can be executed from the browser.... |
| | Total Hits: 288 | Today: 0 | | Rating: |
| |
Special considerations must be made for performance optimization of queries built on attached SQL database tables. An SQL database, for this article, is defined as any client/server database that supports some level of ANSI SQL as an intrinsic part of the database's programming language. Optimal query strategy for these queries is to ensure that all query operations are performed on the server. This article outlines tips on how to ensure that queries against attached SQL database tables are..... |
| | Total Hits: 329 | Today: 0 | | Rating: |
| |
This article demonstrates how to perform a SQL Server distributed query to retrieve data from an OLAP Services cube.... |
| | Total Hits: 1217 | Today: 0 | | Rating:  |
| |
This article describes how to obtain Service Pack 4 for Microsoft SQL Server version 6.5. To see a complete list of bugs that are fixed by this update, see the Fixlist.txt file that accompanies the Service Pack.... |
|
|
|
|
|
|