|
|
|
|
|
| | Total Hits: 92 | Today: 0 | | Rating:  |
| | 
This article provides information on the different versions of SQL Server and the Windows operating system versions on which they run.
MORE INFORMATION
You can determine the version of SQL Server by executing the following
query:
select @@version The version of SQL Server is also reported in the first line of the error log.
... |
| | Total Hits: 742 | Today: 0 | | 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:...
|
| | Total Hits: 114 | Today: 0 | | Rating: |
| |
Microsoft now distributes SQL Server security fixes as one download file. Because the security fixes are cumulative, each new release contains all of the security fixes that were included with the previous SQL Server security fix release. This Microsoft Knowledge Base article contains a list of all the security fixes that are available for SQL Server 2000 Service Pack 1 (SP1).
MORE INFORMATION
SQL Server Security Fixes ...
|
| | Total Hits: 137 | Today: 0 | | Rating: |
| |
This article details the steps required for setting up SQL Server to listen on Banyan VINES server-side net-library:
- 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."
...
|
| | Total Hits: 155 | Today: 0 | | 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.... |
| | Total Hits: 301 | Today: 0 | | 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.''... |
| | Total Hits: 127 | Today: 0 | | 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... |
| | Total Hits: 190 | Today: 0 | | Rating: |
| |
This article provides information about the bugs fixed by SQL Server 2000 Windows CE Edition 1.1 service packs. Because service packs are cumulative, subsequent service packs also fix the bugs fixed by previous service packs.
... |
| | Total Hits: 84 | Today: 0 | | 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... |
| | Total Hits: 669 | Today: 0 | | Rating: |
| |
If you use the Data Transformation Services (DTS) Delimited option to import a text file with double-byte character set (DBCS) characters, DTS may erroneously parse the columns at trailing bytes of DBCS characters.This problem occurs when all of the following conditions are true:
- The encoding of the text file is either ANSI or OEM.
- You use a single-byte character set (SBCS) character as a column delimiter. For example: vertical bar ( 0x7c )
- The trailing byte of...
|
| | Total Hits: 707 | Today: 0 | | Rating: |
| |
SQL Server 2000 returns a non-null value when it calls the Transact-SQL SUBSTRING function if the value of the second parameter, the starting position, is less than one. Prior versions of SQL Server consider such a starting position as an out-of-range condition and return a NULL.... |
| | Total Hits: 677 | Today: 0 | | 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.
... |
| | Total Hits: 160 | Today: 0 | | 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.... |
| | Total Hits: 452 | Today: 0 | | 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.
... |
| | Total Hits: 191 | Today: 0 | | Rating:  |
| |
The following is a list of fixes and various other improvements that have been made in Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0. For more information, contact your primary support provider. To determine which Service Pack level your SQL Server is currently running, execute the following statement from a Query Analyzer window..... |
| | Total Hits: 285 | Today: 0 | | 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.
... |
| | Total Hits: 529 | Today: 0 | | 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.... |
| | Total Hits: 578 | Today: 0 | | 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.... |
| | Total Hits: 344 | Today: 0 | | Rating: |
| |
ActiveX Data Objects (ADO) may return no data with the SQLOLEDB provided under the following conditions:
- The Prepared property on the command object is set to TRUE.
- The query has a parameterized LIKE clause.
- The column included with the LIKE clause is defined as CHAR (and not as VARCHAR) at the back end.
- The parameter value has fewer characters than the back-end column size.
- You are connecting to either a Microsoft SQL Server 7.0 or SQL Server 2000 database. If it is a SQL Server 2000 database, the Defer Prepare property is set to FALS..Read More..
|
| | Total Hits: 430 | Today: 0 | | Rating: |
| |
ChgDimDataSource.exe is a sample file that shows you how to change the data source for dimensions.
MORE INFORMATIONIn 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.. |
|
|
|
|
|
|
|
|
|
|
|
|
|