|Total Hits: 291 | Today: 0|| Rating: |
In SQL Server 2000, for merge publications with dynamic filters, you can create dynamic snapshot jobs for improved performance. However, if the snapshot job has either the @pre_snapshot_command or @post_snapshot_command parameter set, and you execute the dynamic snapshot job more than once, the job might fail and the following error message occurs
Could not copy script file '\\shiloh2\repldata\unc\scripts\script1.sql' to the snapshot generation folder....
|Total Hits: 530 | Today: 0|| Rating: |
When using the MDAC 2.1 or later version of the SQL Server ODBC driver (version 3.70.0623 or later) or the OLEDB provider (version 7.01.0623 or later), under some circumstances you may experience translation of character data from the client code page to the server code page, even when Autotranslation is disabled for the connection.
|Total Hits: 1972 | Today: 0||Author: MSDN|| Rating: |
When you use Microsoft OLE DB Provider for SQL Server (OLEDBSQL) in ADO.NET, if you try to start more than one transaction in a session, you receive the following error message:
System.Data.OleDb.OleDbException: Cannot start more transactions on this session...
|Total Hits: 1273 | Today: 0||Author: MSDN|| Rating: |
Microsoft SQL Server .NET data provider (SqlClient) is slower than OLE DB .NET data provider (OleDb) when you use connection pooling with integrated security....
|Total Hits: 1371 | Today: 0|| Rating: |
If you run the Data Transformation Services (DTS) Wizard and you specify a database that contains a period in the name as either the source or destination, the following error message appear:
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description: Unspecified Error
Could not find server ''%1%'' in sysservers. Execute sp_addlinkedserver to add the server to sysservers....
|Total Hits: 1250 | Today: 0|| Rating: |
When you apply the initial snapshot of a SQL Server 2000 replication publication, the distribution agent (for snapshot or transactional publications) or merge agent (for merge publications) may fail with the following error message:
Message: Invalid object name ''V2''.
Message: Unable to replicate a view or function because the referenced objects or columns are not present on the Subscriber...Read More..
|Total Hits: 893 | Today: 0|| Rating: |
When you attach database files, you can specify a different name for the database other than the original name. To specify a different name for the database, use the Attach Database dialog box in the SQL Enterprise Manager and specify the new name in the Attach As option....
|Total Hits: 382 | Today: 0|| Rating: |
When you run a SQL Profiler trace, you may occasionally experience both of these problems when you save the output file to a remote location:
Any attempt to connect to a computer that is running SQL Server from within SQL Profiler fails with this error message:
Server does not exist or access denied.
Any attempt to write to an output file fails with this error message:
The specified network name is no longer available.
|Total Hits: 789 | Today: 0|| Rating: |
Using the SQL Distributed Management Objects (DMO) BulkCopy object to
import data into a SQL Server table that contains a column with a space embedded in the column name may fail with no rows copied.
|Total Hits: 2044 | Today: 0|| Rating: |
If you run a query that contains an aggregate function in the subquery, and if the subquery returns a non-NULL column, it may be possible for the query as a whole to generate the following warning message:Msg 8153 Warning: Null value is eliminated by an aggregate or other SET operation....
|Total Hits: 273 | Today: 0|| Rating: |
An attempt to use a Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) provider specific property in a Microsoft embedded Visual C++ OLE DB program causes a compilation error. For example, if you try to create a password-protected database through OLE DB, and you pass the DBPROP_SSCEOLEDB_DBPASSWORD provider-specific property, the following error message occurs:
error C2065: ''DBPROP_SSCEOLEDB_DBPASSWORD'' : undeclared identifier...
|Total Hits: 634 | Today: 0|| Rating: |
A Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) Delete query, with a subquery over a large table, may appear to stop responding (hang). For example, a query similar to the following may take a long time to return if the tables t1 and t2 are large:
delete from t1 where col1 in (select t2.col1 from t2 where t2.col2="something")The creation of indexes on the relevant columns of the tables may not solve the problem for this particular query....
|Total Hits: 391 | Today: 0|| Rating: |
The Queue Reader Agent may fail with an error message similar to the following:
Failed while applying queued message to publisher
Server: PUBLISHER, Database QueuedPublisher : ODBC Error:Invalid cursor state
Worker Thread 556 : Aborted Queue Transaction...
|Total Hits: 849 | Today: 0|| Rating: |
With a large database that has 6,000 tables and 15,000 views, the
sysdepends system table may have close to 500,000 rows. An attempt to script 10 tables by using only DROP and CREATE table statements took several minutes on an 8-processor computer. The most time was spent on sp_MSdependencies stored procedure, which does not seem necessary because the dependency objects were not requested. According to this speed, to script all the tables and views may take over 10 days, which is a serious p...
|Total Hits: 515 | Today: 0|| Rating: |
During a Log Shipping role change an attempt to execute the
sp_resolve_logins stored procedure fails. The following error message occurs when you execute the
sp_resolve_logins stored procedure from a recently recovered secondary database:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name ''syslogins''....
|Total Hits: 224 | Today: 0|| Rating: |
If SQL Server is in the process of a shut down, and you attempt to commit a Distributed Transaction Coordinator (DTC) transaction, the DTC transaction is successfully committed instead of rolling back....
|Total Hits: 1847 | 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: 307 | Today: 0|| Rating: |
When you use Microsoft Access 97 and the SQL Server ODBC driver version 2.65.xx to link a table on a SQL Server specifically configured as follows:
Character Set: 850 (MultiLingual)
Sort Order: Binary Order (bin_cp850)
Unicode Collation: Binary Unicode Collation (ID = 33280)
the linked table shows valid data rows. After you upgrade to Microsoft Access 2000, which uses the SQL Server ODBC driver version 3.70.06.23, the linked table data is incorrectly shown as #DELETED....
|Total Hits: 368 | 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: 2162 | 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..