|
|
|
|
|
| | Total Hits: 344 | Today: 0 | Author: Ray Barley | 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?... |
| | Total Hits: 1759 | Today: 0 | | 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).... |
| | 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.... |
| | Total Hits: 970 | Today: 0 | | 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: 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: 1218 | Today: 0 | | 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 ... |
| | 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: 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.. |
| | Total Hits: 2103 | Today: 0 | | 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..
|
| | Total Hits: 152 | Today: 0 | | 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... |
| | Total Hits: 136 | 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: 154 | 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: 300 | 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: 126 | 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: 83 | 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: 706 | 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: 747 | Today: 0 | | 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... |
| | Total Hits: 446 | 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: 157 | Today: 0 | | 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,... |
|
|
|
|
|
|
|
|
|
|
|
|
|