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
Search:
What's New - What's Hot
More Categories for .NET Framework .NET Framework (376)
Listings for .Net Framework 2.0 .Net Framework 2.0 (9)
More Categories for ASP.Net ASP.Net (385)
More Categories for ASP.Net 2.0 ASP.Net 2.0 (42)
More Categories for C-Sharp C-Sharp (234)
More Categories for SQL Server SQL Server (289)
More Categories for Visual Basic.Net Visual Basic.Net (498)
More Categories for Visual C# .NET Visual C# .NET (44)
More Categories for Visual C++ .NET Visual C++ .NET (71)
More Categories for Visual SourceSafe Visual SourceSafe (17)
More Categories for Visual Studio 2005 Visual Studio 2005 (10)
More Categories for Visual Studio.Net Visual Studio.Net (130)
More Categories for Windows Windows (203)
More Categories for XML XML (15)
More Categories for XML and .NET XML and .NET (71)
 


How To Use the Analysis Services Processing Task in SSIS 2005     
Total Hits: 370  |  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 debug managed-client applications that are started by using a URL in Visual Studio .NET or in Visual Studio 2005     
Total Hits: 219  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes how to use the IEExec.exe application to debug managed-client applications that you start by using a URL in Microsoft Visual Studio .NET or in Microsoft Visual Studio 2005....

How to trace and debug in Visual C++ .NET and in Visual C++ 2005     
Total Hits: 190  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes how to use the Debug class and the Trace class. These classes are available in the Microsoft .NET Framework. You can use these classes to provide information about the performance of an application during application development, or after deployment to production. These classes are only one part of the instrumentation features that are available in the .NET Framework....

How to call a managed DLL from native Visual C++ code in Visual Studio.NET or in Visual Studio 2005     
Total Hits: 429  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to call a managed DLL from native C++ code. To do this, create a simple managed DLL by using Microsoft Visual C# .NET or Microsoft Visual C# 2005, and then call this managed DLL from native C++ code....

How to drag forms by using the client area with Visual C++ 2005 or with Visual C++ .NET     
Total Hits: 185  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to permit a user to move a form by dragging the client area of the form. This article describes how to override the WndProc method of the form to enable the client area dragging....

PRB: Compiler Errors When You Use #import with XML in Visual C++ .NET     
Total Hits: 200  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you use MSXML parser dynamic-link libraries (DLLs) such as Msxml.dll, Msxml2.dll, Msxml3.dll, or Msxml4.dll to compile a Visual C++ .NET project with #import, you may receive the following compiler error messages:
c:\sample\test.cpp(12) : error C2872: 'IXMLDOMDocumentPtr' : ambiguous symbol

could be 'c:\Program Files\Microsoft Visual Studio .NET\Vc7\include\comdefsp.h(1228) : _com_ptr_t<_IIID> IXMLDOMDocumentPtr' with [ _IIID=_com_IIID

FIX: AUTO-SHRINK Option or DBCC SHRINKDATABASE May Slow Down SQL Server 2000 Performance (Q296386)     
Total Hits: 1849  |  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)....

HOW TO: Plan SQL Server CE Security for Mobile Devices in IIS and SQL Server 2000 Windows CE Edition (Q314783)     
Total Hits: 299  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

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 security. The article examines various authentication methods for IIS and SQL Server. Because SQL Server CE connects to SQL Server through IIS, this article discusses both security environments for mobile SQL Server applications.
...

HOW TO: Synchronize Mobile Databases by Using SQL Server CE Relay (Q314514)     
Total Hits: 568  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This guide is for users of Microsoft SQL Server 2000 Windows CE Edition version 1.1 (SQL Server CE) who want to use SQL Server CE Relay to synchronize their mobile database. Relay enables mobile users to update their SQL Server CE data without the use of a network connection on their device. You can communicate with a remote SQL Server system by connecting through a serial, IR, or USB connection to a networked desktop....

INF: Windows Authentication is the Default Security Mode After a SQL Server 2000 Typical Installation (Q269587)     
Total Hits: 755  |  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:...

INF: How to Change the Default Login Authentication Mode to SQL While Installing SQL Server 2000 Desktop Engine by Using Windows Installer (Q285097)     
Total Hits: 591  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When using SQL Server 2000 Desktop Engine Windows Installer Merge Modules, an option named SECURITYMODE can be used to change the default login authentication mode from Windows NT authentication to SQL authentication....

FIX: Log Reader Agent Fails with 18767 and 18762 Error Messages (Q316783)     
Total Hits: 461  |  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)...

HOW TO: Change the Temp Database Location in SQL Server CE (Q317032)     
Total Hits: 266  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server 2000 Windows CE Edition version 1.1 (SQL Server CE) creates a temporary database that it uses for storing temporary data such as:...

HOW TO: Enable Replication Agents for Logging to Output Files in SQL Server (Q312292)     
Total Hits: 280  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

You can configure the SQL Server replication agents (that is, the Snapshot Agent, Log Reader Agent, Queue Reader Agent, Distribution Agent, and Merge Agent) to capture more information about error messages and procedure calls to a text file. For instance, you can capture the additional information about error messages and procedure calls to troubleshoot agent failures....

INF: Setting Up SQL Srv to Listen on Banyan VINES Net-Library (Q142584)     
Total Hits: 153  |  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: 170  |  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....

INF: Troubleshooting Stored Procedure Recompilation     
Total Hits: 444  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your 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:
...

HOW TO: Configure Memory for More Than 2 GB in SQL Server     
Total Hits: 329  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your 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....

INF: Common SQL Mail Problems (Q315886)     
Total Hits: 242  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your 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,...

How To Handle Errors in DTS Package and Step Objects     
Total Hits: 3063  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your 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....



Disclaimer - Privacy
© 2002-2017 DevASP.net