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
Search:
What's New - What's Hot
Listings for Administration Administration (6)
Listings for Articles Articles (54)
More Categories for Bugs and Fixes Bugs and Fixes (111)
Listings for Data Provider Data Provider (6)
Listings for Encryption Encryption (1)
Listings for Errors Errors (27)
Listings for Import & Export Import & Export (3)
Listings for Information Information (44)
Listings for Installation Installation (3)
Listings for Security & Login Security & Login (7)
Listings for SQL Mail SQL Mail (3)
Listings for SQL Server 2005 SQL Server 2005 (8)
Listings for SQLXML SQLXML (5)
Listings for Stored Procedure Stored Procedure (9)
Listings for Virtual Instance Virtual Instance (0)
Listings for Windows XP Windows XP (2)


PRB: Error Message 3266 Occurs When Microsoft Tape Backup Format Cannot be Read (Q290787)     
Total Hits: 1231  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you perform a database backup to disk or tape, or a restore from disk or tape, the following error message may occur:SQL Server 7.0 Server: Msg 3266, Level 16, State 1, Line 1 The Microsoft Tape Format (MTF) soft filemark database on backup device ''devicename'' cannot be read, inhibiting random access. Server: Msg 3013, Level 16, State 1, Line 1 Backup or restore operation terminating abnormally. SQL Server 2000 Server: Msg 3266, Level 16, State 1, Line 1 The backup data in ...

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....

FILE: ChgDimDataSource.exe Sample to Change the Data Source for a Dimension (Q306328)     
Total Hits: 438  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

ChgDimDataSource.exe is a sample file that shows you how to change the data source for dimensions.


MORE INFORMATION

In Analysis Manager, the data source for a dimension is read-only and there is a good reason for not allowing you to change the data source name through the Dimension Editor. If you are not careful, you can easily corrupt the cube definitions. Sometimes, when you develop your Analysis Services databases, you may use simple names like "MyDatasource." When you prepare to move your cubes and databases to a production environment, you need to change the data s..Read More..


FIX: SQL Server Driver Fails to Connect over TCP/IP Using Three Parameters in Address Keyword (Q311836)     
Total Hits: 2164  |  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: 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....

PRB: Subscriptions in System Databases Not Supported (Q317832)     
Total Hits: 161  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

You may see unexpected behavior during a setup or upgrade, as well as during the normal course of operation, when you create subscriptions to SQL Server replication publications in the master database. Microsoft does not support the creation of subscriptions in the master database, or any other system database (such as tempdb, model, or msdb).For example, if you create a push subscription in the master database, the SQL Server service pack Setup does not upgrade any replication objects in system...

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. ...

FIX: Synchronization May Fail After You Use Large Text or Image Data (Q304072)     
Total Hits: 243  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you use text or image data in a Microsoft SQL Server 2000 Windows CE edition version 1.1 (SQL Server CE) database, the following error message may occur when you use the merge replication object: Source: Microsoft SQL Server 2000 Windows CE Edition Error Number: 80072F7F Native Number: 28032 Error Description: Run Failure initializing internet functionality SSCE_M_FAILUREINITIALIZINGINTERNET...

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....

PRB: Windows NT Account Lockout with SQL Server CE Replication and Invalid Password (Q313153)     
Total Hits: 140  |  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: 96  |  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...

FIX: SQL Server CE eVB CompactDatabase Unable to Fix Corrupted Database (Q306452)     
Total Hits: 594  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

A corrupted database may produce the following error message in the Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) Query Analyzer if you attempt to open a connection: Error: 0x80004005 E_FAIL Minor Error: (25017) Description: Unspecified Error The error code is SSCE_M_DATABASECORRUPTED (Non-database file or database file corrupted). A Microsoft embedded Visual Basic (eVB) application that uses the CompactDatabase method is not able to compact a corrupted SQL Server CE database. An ...

PRB: IIS Lock Down Tool May Break RDA or Replication That Uses Anonymous Authentication (Q310654)     
Total Hits: 725  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you install the Microsoft Internet Information Server (IIS) Lock Down Tool with all the default options, it may break a working Microsoft SQL Server 2000 Windows CE (SQL Server CE) Remote Data Access (RDA) or Replication application that uses Anonymous authentication....

INF: How to Grant Access to SQL Logins on a Standby Database When "guest" User Is Disabled (Q303722)     
Total Hits: 691  |  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.
...

INF: How SQL Server Compares Strings with Trailing Spaces (Q316626)     
Total Hits: 757  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server follows the ANSI/ISO SQL-92 specification (Section 8.2, , General rules #3) on how to compare strings with spaces. The ANSI standard requires padding for the character strings used in comparisons so that their lengths match before comparing them. The padding directly affects the semantics of WHERE and HAVING clause predicates and other Transact-SQL string comparisons. For example, Transact-SQL considers the strings ''abc'' and ''abc '' to be equivalent for most c...

HOW TO: Change the SQL Server Service Account Through Control Panel in SQL Server (Q283811)     
Total Hits: 459  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

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 you change the startup account for SQL Server (MSSQLServer service) by using SQL Enterprise Manager (SEM), SEM automatically sets all the required permissions.
...

HOW TO: Obtain the Current Day with a MDX Query or Expression in SQL Server 2000 Analysis Services (Q301537)     
Total Hits: 169  |  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: 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....



Disclaimer - Privacy
© 2002-2017 DevASP.net