|
|
|
|
|
Total Hits: 143 | Today: 0
|
Author: Harish
|
Rating:
|
|
In continuation to Part I of this article, we will examine how we can load the XML Fragment returned by the SQL FOR XML query, into a DataSet, to form a Well Formed XML Document....
|
|
|
|
Total Hits: 212 | 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: 2007 | Today: 0
|
|
Rating:
|
|
When you enable a SQL Server application role on a Microsoft ActiveX Data Objects (ADO) connection to SQL Server, you may receive the following error message when you connect to SQL Server 7.0: sp_setapprole was not invoked correctly. Refer to the documentation for more information.When you connect to SQL Server 2000, the error may appear as follows:[DBNETLIB][ConnectionRead (WrapperRead()).]General network error. Check your network documentation This error occurs when sp_setapprole is called on...
|
|
|
|
Total Hits: 1213 | Today: 0
|
|
Rating:
|
|
When you perform a query against a linked server, this error message may occur:Server: Msg 8624, Level 16, State 25, Line 7 Internal SQL Server error....
|
|
|
|
Total Hits: 340 | Today: 0
|
|
Rating:
|
|
When you use the msdb..sp_add_jobstep stored procedure to add a job
step, if the server name (NetBIOS name + \Instance name) exceeds 30
characters, msdb..sp_add_jobstep may fail with the following error: Error 14234: The specified ''@server'' is invalid" (valid values are returned by sp_helpserver).For example, this error may be returned when you configure a replication distribution server or when you run the Create Job Wizard on a server with a name that exceeds 30 characters....
|
|
|
|
Total Hits: 278 | Today: 0
|
|
Rating:
|
|
MSSQLServerADHelper is a service installed by the SQL Server Setup program that handles the Active Directory objects for all instances of the SQL Server relational database engine and all Analysis Manager applications that are running on the computer. There is only one MSSQLServerADHelper service on a computer for all of the instances of Microsoft SQL Server 2000.On computers that are running SQL Server 2000 Service Pack 1 (SP1), uninstalling all the instances of Microsoft SQL Server 2000 does n...
|
|
|
|
Total Hits: 142 | Today: 0
|
Author: Harish
|
Rating:
|
|
In Part II, we examined how we can utilize the DataSet's intelligence to handle XML Format to overcome the "Document Element" issue while reading XML Data from SQL Server using FOR XML queries. We will examine a much more efficient way of handling SQL XML using the SQL XML Managed classes provided with the Microsoft SQL XML Managed Provider (Available for free download from Microsoft). Microsoft SQL XML introduces powerful set of Properties/Methods to manipulate XML Data from SQL Server FOR XML ...
|
|
|
|
Total Hits: 325 | 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: 697 | Today: 0
|
|
Rating:
|
|
A Microsoft SQL Server™ 2000 Windows® CE Edition Subscriber produces the following error messages when you invoke the merge process:
RESULT:NUMBER = 80040E14 NATIVE_ERROR = 25501, SSCE_M_QP_BADPARSE
You may also receive the following additional native error messages:
28557 (SSCE_M_UNUSABLEDATABASE):
"The database is in an unusable state. Delete it and recreate it.
"28560 (SSCE_M_EXECUTEFAILED):
"OLE DB Execute Method failed; bad or invalid SQL statement"...
|
|
|
|
Total Hits: 1107 | 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: 446 | Today: 0
|
|
Rating:
|
|
When you submit a query to a remote data source and the query contains a string longer than what is expected, the buffer could be overwritten. If you submit a query that has a string longer than expected, the query may cause a handled exception of this SQL Server thread, or may allow an attacker to run arbitrary code under the security context in which the SQL Server service is running....
|
|
|
|
Total Hits: 561 | Today: 0
|
|
Rating:
|
|
You may encounter the following error message when you execute a SELECT query that joins multiple tables:
Error: 0x8007000e E_OUTOFMEMORY Minor Error: (0)
Description: Interface defining error: IID_ICommand
...
|
|
|
|
Total Hits: 430 | Today: 0
|
|
Rating:
|
|
Applications built with Microsoft Embedded SQL for C (ESQL/C) may go into an infinite loop when a KEYSET cursor opens and another connection modifies the first row on the server before the row is fetched....
|
|
|
|
Total Hits: 1151 | Today: 0
|
|
Rating:
|
|
When you try to install Microsoft SQL Server 2000 on a computer that has certificates, installation can fail and you may receive the following error message:
[Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (SECDoClientHandshake()).SQL Server configuration failed.
-or-
When you add certificates to a server that already has SQL Server installed, local connections fail....
|
|
|
|
Total Hits: 245 | Today: 0
|
|
Rating:
|
|
Under the following conditions, a client application cannot connect to SQL Server:
- The client uses the client components of SQL Server 7.0 (MDAC 2.1), or later.
- The client wants to connect through Multiprotocol (Remote Procedure Call [RPC]).
- The server is configured to use "Windows only" authentication.
...
|
|
|
|
Total Hits: 234 | Today: 0
|
|
Rating:
|
|
The following error may be generated by the Microsoft SQL Server ODBC driver, especially when you are using the ODBC driver in connection-pooled environments such as Internet Information Server (IIS):
Error 0x8000FFFF Catastrophic failure
The typical symptoms are that the driver is used successfully for a varying amount of time, but the error then occurs when you attempt to open a connection object.
This problem occurs with the 3.70.0690 build of the Microsoft SQL Server ODBC driver (Sqlsrv32.dll) but does not occur with earlier builds. Also, the problem does not occur when..Read More..
|
|
|
|
Total Hits: 264 | Today: 0
|
Author: Teratrex
|
Rating:
|
|
Every day, more enterprises resort to the internet to provide their clients with access to their SQL Server 2000 databases, or to gain access to databases hosted at remote locations. This makes SQL Server 2000 increasingly prone to security attacks. As a result, Microsoft is constantly adding security features (like those added in Windows XP SP2) to prevent attacks and secure the popular database server. These features make connecting to SQL Server 2000 increasingly difficult to troubleshoot. On...
|
|
|
|
Total Hits: 167 | Today: 0
|
Author: Harish Ranganathan
|
Rating:
|
|
SQL Server 2000's FOR XML Clause provides great support in querying SQL Server Data and retrieving it in the form of XML. In other words, you can get an XML representation of the Result Set using the FOR XML Clause. So, if a select statement of select * from customers retrieves results in a sequential way, select * from customers FOR XML AUTO will retrieve the same in a XML Format. There are different methods to retrieve XML representation of Data using SQL Server 2000's FOR XML clause which is ...
|
|
|
|
Total Hits: 476 | Today: 0
|
|
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 ...
|
|
|
|
Total Hits: 244 | Today: 0
|
|
Rating:
|
|
When you view a log shipping monitor for a log shipping pair, the Last file copied and Last file loaded values may continuously show "first_file_000000000000.trn", even though the copy and load jobs on the secondary server are executing correctly without any errors. If the values remain the same over an extended period of time, log shipping thresholds could be crossed and alerts could be fired....
|
|
|
|
|
|
