Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Knowledge Base > SQL Server > Articles


Search:
What's New - What's Hot
HOWTO: SQL Server 7 Distributed Query with OLAP Server (Q218592)     
Total Hits: 439  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how to perform a SQL Server distributed query to retrieve data from an OLAP Services cube....

Q178295 - How to Obtain SQL Server 6.5 Service Pack 4     
Total Hits: 1360  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your 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....

Q251004 How to Monitor SQL Server 2000 Blocking     
Total Hits: 370  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article documents the usage and design of a stored procedure that you can use to diagnose blocking and performance issues. For a description of how to understand and resolve blocking...

How To Use the Analysis Services Processing Task in SSIS 2005     
Total Hits: 373  |  Today: 0Author: Ray Barley      Rating:  
Read Reviews | Write Review |  Your Rating: 

We are looking to automate the processing of our SQL Server Analysis Services dimensions and cubes. We'd like to add this processing to our existing SQL Server Integration Services (SSIS) packages which periodically update our data warehouse from our OLTP systems. Can you give us the details on how the Analysis Services Processing Task can be used in an SSIS package?...

HOW TO: Connect to the Microsoft SQL Server Through the Use of Named Pipes (Q159976)     
Total Hits: 1066  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your 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)...

HOWTO: Call SQL Server Stored Procedures from ASP     
Total Hits: 5591  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates three methods of calling a stored procedure from Active Server Pages using ActiveX Data Objects (ADO)....

FIX: AUTO-SHRINK Option or DBCC SHRINKDATABASE May Slow Down SQL Server 2000 Performance (Q296386)     
Total Hits: 1857  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

If a database is full or nearly full, and a large number of the tables in the database do not have clustered indexes, the AUTO-SHRINK database option or DBCC SHRINKDATABASE command may cause severe performance degradation for SQL Server 2000. The performance may degrade to the point where queries do not return results in a timely fashion. It takes longer for new connections to connect, resulting in connection timeouts. SQL Server 2000 may appear to stop responding (hang)....

INF: Windows Authentication is the Default Security Mode After a SQL Server 2000 Typical Installation (Q269587)     
Total Hits: 759  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

After a Typical installation of Microsoft SQL Server 2000, Windows Authentication is the default security mode. Therefore, after you install SQL Server 2000 and you attempt to connect to the SQL Server server by using a standard login like system administrator (SA), you may receive the following error message:
Unable to connect to server SERVER_NAME:...

FIX: SQL Server Driver Fails to Connect over TCP/IP Using Three Parameters in Address Keyword (Q311836)     
Total Hits: 2171  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

A connection to a back-end SQL Server database may fail with the following error:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. This error occurs under the following conditions:
  • You are using the Microsoft ODBC Driver for SQL Server 2000 that comes with Microsoft Data Access Components (MDAC) version 2.6, 2.6 SP1, 2.6 SP2, or 2.7.

  • The TCP/IP protocol is used; in other words, the Network keyword is set to DBMSSOCN.

  • The Address keyword ..Read More..

FIX: Log Reader Agent Fails with 18767 and 18762 Error Messages (Q316783)     
Total Hits: 465  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

The Log Reader Agent may fail with the following error messages: The specified begin LSN (%ls) for replication log scan occurs before replbeginlsn (%ls). (Source: (Data source); Error number: 18767)-or-Invalid begin LSN (%ls) for commit record (%ls). Check DBTABLE. (Source: (Data source); Error number: 18762)...

INF: Setting Up SQL Srv to Listen on Banyan VINES Net-Library (Q142584)     
Total Hits: 156  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article details the steps required for setting up SQL Server to listen on Banyan VINES server-side net-library:

  1. Determine what Banyan StreetTalk group you would like to use with SQL Server. This can be an existing group or a new group. For a new group,use the MGROUP program included with VINES software to add a new group for your organization. Let''s say you have decided to use "SQL" as your group and the organization is "MICROSOFT."
  2. ...

INF: Examples of Sp_OA Procedure Use and SQLOLE.Transfer Object (Q152801)     
Total Hits: 173  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

The following Transact-SQL sample code transfers an entire database. It is a simplified example of how to use the Sp_OA procedures and the SQLOLE.Transfer object. For detailed documentation of the procedures and objects, query in SQL Server 6.50 Books Online....

PRB: Upgrade Wizard Fails with "Logins ID unable to open registry on the target computer." Error Message (Q310542)     
Total Hits: 312  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you perform an in-place or "one computer" upgrade from Microsoft SQL Server 6.5 to SQL Server 7.0 or SQL Server 2000 on a Microsoft Windows 2000-based computer, the Upgrade Wizard may fail with the following error message: The Upgrade wizard is failing to export the logins from SQL Server 6.5. ''Logins ID unable to open registry on the target computer.''...

PRB: Windows NT Account Lockout with SQL Server CE Replication and Invalid Password (Q313153)     
Total Hits: 143  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you use an application based on Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) Replication or Remote Data Access (RDA), you may receive an error message similar to the following when you use an invalid password for use with Microsoft Internet Information Server (IIS) servers that are set to use Basic or Integrated Windows authentication: 401.1 Unauthorized: Logon Failed after three logon attempts...

INF: How to Obtain the Latest SQL Server 2000 Windows CE Edition 1.1 Service Pack (Q316498)     
Total Hits: 99  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Service packs are the means by which Microsoft distributes bug fixes. Service packs keep a product current. Service packs include updates and may include system administration tools, drivers, and additional components, which are conveniently bundled for easy downloading. Service packs are cumulative; each new service pack contains all the fixes that are in previous service packs, as well as any new fixes. You do not need to install a previous service pack before you install the latest one...

INF: How to Grant Access to SQL Logins on a Standby Database When "guest" User Is Disabled (Q303722)     
Total Hits: 693  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

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 Server logins, and therefore, to a server configured to use "SQL Server and Windows Authentication." This procedure cannot be used for Microsoft Windows NT logins or Windows NT groups.
...

HOW TO: Remove a SQL Server Service Pack (Q314823)     
Total Hits: 275  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article will explain the steps required to remove a SQL Server service pack and will expand on the information contained in the Readme.txt file for each service pack. When you install a new service pack, the service pack makes changes to the system tables for maintenance reasons, and upgrades user and distribution databases that are members of a replication topology. Due to these changes, you cannot easily remove service packs. There is no automated way to remove a service pack, and the pro...

HOW TO: Obtain the Current Day with a MDX Query or Expression in SQL Server 2000 Analysis Services (Q301537)     
Total Hits: 170  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

For a number of reasons, you may want to create a Calculated Member or a Multidimensional expression (MDX) that returns the current date. This article explains how to use the Microsoft Visual Basic NOW function in a MDX statement and a MDX expression to return the current date. The article also explains how to use the Microsoft Visual Basic DAY, MONTH, and YEAR functions in a MDX expression to return the Day, Month, and Year values of a date....

HOW TO: Cluster SQL Server 2000 Analysis Services in Windows 2000 (Q308023)     
Total Hits: 136  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article provides step-by-step instructions on how to set up SQL Server Analysis Services 2000 as a clustered service. Although Analysis Services is not a cluster aware application, you can install and configure Analysis Services as a generic service on a cluster....

HOW TO: Archive and Restore an Analysis Services Database from the Command Prompt in SQL Server 2000 Analysis Services (Q312399)     
Total Hits: 486  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes the use of the msmdarch command to archive and restore an Analysis Services database from the command prompt. A member of the administrators group performs all the procedures for a pre-existing database.
...


1  2  3  Next >> 


Disclaimer - Privacy
© 2002-2017 DevASP.net