Not Seeing your article?

Try pressing F5 on your Internet Explorer or do a refresh on your Netscape.

Microsoft SQL Server Kb Articles

This WebPage links to Microsoft's Database. It is dynamically generated by J&K Page Generator. With the same technology, you post thousands of Résumés, Human Resources Document, Banking Document, etc on your Intranet or Internet as easy as drag and drop. We can add security to protect sensitive document for you as well. For technical consultation, please contact us at this e-mail address: jnkc@msn.com

1981 total items under the Microsoft SQL Server Kb Articles's page.

00001 Q36929 INF: Invoking an Editor from ISQL

00002 Q36963 INF: SQL Server Disk-Space Management

00003 Q37667 PRB: Cannot Use /Zp Compiler Option With DB-Library

00004 Q38035 PRB: ErrMsg: kistartup: No Memory Available for Threads

00005 Q38193 PRB: Setup Fails While Creating Master Database

00006 Q38695 PRB: Cannot Connect to SQL Server Using ISQL/SAF/SQLTEST(R/P)

00007 Q38831 INF: DB-LIB and Floating Point

00008 Q39084 INF: Using dbdata() Versus dbbind()

00009 Q39113 PRB: DBCC Reports Page Count Discrepancy on SYSLOGS Table

00010 Q39124 INF: Interrupting the Display of SQL Server Output

00011 Q39138 INF: How to Calculate the Virtual Device Number

00012 Q40807 PRB: SQL Server Msg 4002: Login Failed; Login Incorrect

00013 Q40808 INF: Disk Dump Device Size in SYSDEVICES

00014 Q40913 PRB: BCP Ignores Rules and Triggers

00015 Q40919 INF: How to Start SQL Server

00016 Q41328 INF: Cannot Add the "Guest" Username

00017 Q41720 INF: Open Failed on Network Pipe on Connect to SQL Server

00018 Q42303 INF: Using Browse Mode in DB-Library

00019 Q42417 PRB: CREATE TABLE Appears to Ignore IF Statements

00020 Q42624 PRB: Error Creating Stored Procedure

00021 Q42627 PRB: MS-DOS Workstation Fails to Connect with SQL and SQLTESTR

00022 Q42745 INF: SQL Row Size Limited to 1962 Characters

00023 Q43199 INF: Concurrency and Consistency and SQL Server Alternatives

00024 Q44415 INF: Timestamps and Their Uses

00025 Q44519 INF: Error Handling in Transact-SQL

00026 Q44730 INF: Using Windows Global Heap Buffers

00027 Q45137 INF: Creating Stored Procedures That Modify System Tables

00028 Q45147 INF: Issuing an Update in Browse Mode

00029 Q45233 INF: WAITFOR ERROREXIT/PROCESSEXIT Wake-Up Conditions

00030 Q45253 INF: Using Separate Connections for Update in Browse Mode

00031 Q45254 INF: Use of Timestamps in Browse Mode

00032 Q45255 INF: Use of Multiple Unique Indexes by dbqual in Browse Mode

00033 Q45256 INF: Updating Values in Columns Used by dbqual in Browse Mode

00034 Q45257 INF: Updating a Row a Second Time in Browse Mode

00035 Q45259 INF: Determining If a Row Has Been Changed in Browse Mode

00036 Q45260 INF: Retrieving Current Timestamp from Data Row

00037 Q45261 INF: No Timestamp Is Returned by dbtsnewval() If Update Fails

00038 Q45262 INF: Forcing Update by Overriding Timestamp Protection

00039 Q45263 INF: Why dbqual() Returns Null WHERE Clause in Browse Mode

00040 Q45264 INF: Views Cannot Be Used in Browse Mode

00041 Q45301 INF: Restrictions for Multi-Table Outer Joins

00042 Q45493 PRB: Using a Self-Join to Produce a Cartesian Product

00043 Q45542 INF: Shared Access to Modified Data

00044 Q45547 INF: Waiting for Access to Modified Data

00045 Q45548 INF: Detecting Deadlocks

00046 Q45581 INF: Rollback from Within Triggers

00047 Q45585 INF: Locking Multiple Tables in SQL Server

00048 Q45589 INF: Temporary Tables and Logging

00049 Q45590 INF: Purpose of TRUNCATE TABLE

00050 Q45643 INF: Table Locking De-Escalation

00051 Q45644 INF: Fixed-Length Versus Variable-Length Index Entries

00052 Q45660 INF: Data Page Cache Management in SQL Server

00053 Q45661 INF: Sorting Data Out of SQL Server

00054 Q45667 INF: SQL Clustered and Non-Clustered Index Sort Work Area

00055 Q45917 INF: Handling of NULLs, Null Strings, and Blanks in SQL Server

00056 Q46086 INF: Partitioning Logical Disks for Use with SQL Server

00057 Q46091 INF: Using Hard Disk Controller Caching with SQL Server

00058 Q46168 INF: Effect of SET ROWCOUNT on SELECT with ORDER BY

00059 Q46170 INF: Support of Page and Table Locking in SQL Server

00060 Q46356 INF: BCP and Transaction Logging

00061 Q46424 INF: Copying SQL Database Files for Backup/Restore Purposes

00062 Q46434 INF: Writing Efficient Queries and Stored Procedures

00063 Q46435 INF: Deadlocks and Timeouts

00064 Q46438 PRB: Improving Response Time When Communicating over Network

00065 Q46468 PRB: Using DISK REFIT Versus DBCC DROPDB on Damaged Databases

00066 Q46476 INF: Selectively Disabling Logging

00067 Q46479 INF: Recovering from Media Failure in SQL Server

00068 Q46783 INF: Updating Column in One Table w/ Column from Another Table

00069 Q47048 PRB: DATEADD Doesn't Work When Using a Variable as a Date

00070 Q47050 PRB: DATALENGTH Function NULL Argument Documentation Error

00071 Q47162 INF: Deadlock Scenarios and Avoidance in SQL

00072 Q47180 PRB: CONVERTing Character to an Integer Causes Syntax Error

00073 Q47249 INF: Sp_foreignkey Does Not Automatically Create a Common Key

00074 Q47270 INF: SQL Access Permissions and Trigger Execution

00075 Q47271 INF: Starting SQL Server Remotely

00076 Q47295 INF: Deadlocks and Two-Phase Commit

00077 Q47465 INF: Stored Procedures Can Be Nested 16 Levels Deep

00078 Q47496 INF: Purpose of PROBE.EXE

00079 Q47602 INF: Effect of Permissions Additions/Deletions on SYSPROTECTS

00080 Q47603 PRB: Locks and Timeouts

00081 Q47605 INF: Collisions During Multiple-User Updates

00082 Q48711 INF: Finding Names of Columns That Comprise the Key of a Table

00083 Q48712 INF: Handling Timeouts Correctly in DB-Library

00084 Q50636 INF: Using BCP & .FMT File to Read in Only Specified Columns

00085 Q52201 INF: Modifying BCP Format File to Load into Specific Columns

00086 Q58087 INF: SQL Server Use of Math Coprocessor

00087 Q58534 INF: Specifying Priority for Deadlock Victim Selection

00088 Q59024 PRB: Number of User Connections Has Been Exceeded Error

00089 Q59461 PRB: Zero Rows Returned from SQL SELECT Statement

00090 Q59462 INF: Cannot Turn Off Transaction Logging

00091 Q59627 INF: Numbers Reported by sp_monitor for cpu_busy

00092 Q59902 INF: SQL Server Shuts Down When Master Database Is Reloaded

00093 Q60053 INF: Size Considerations for Database and Log Devices

00094 Q60054 INF: Restoration of a Database from Transaction Dumps

00095 Q60055 INF: Altering Database to Add Multiple Log Devices

00096 Q60058 INF: Creating a Log Device If "Log Full" Error Occurs

00097 Q61038 PRB: Using BldMastr to Reset System Configuration

00098 Q61653 INF: Two-Phase and Three-Phase Commit Information

00099 Q61654 INF: Administering a Server from a Remote Location

00100 Q61792 INF: sp_configure Parameters Affect Memory Usage by SQL Server

00101 Q61793 INF: Creating & Filling a Table with Sample Data in SQL Server

00102 Q61795 INF: SQL Server Extent Allocation Information

00103 Q62059 INF: SQL Server Performance Analysis

00104 Q62854 INF: Size Restrictions for dbsqlexec(), dbcmd(), and dbfcmd()

00105 Q62859 INF: SQL Server SELECT with HOLDLOCK Transaction Information

00106 Q62860 INF: Conditions When Stored Procedures Are Recompiled by SQL

00107 Q62864 INF: SQL Server Compatibility with OS/2 LAN Manager

00108 Q62866 INF: Reasons Why SQL Transaction Log Is Not Being Truncated

00109 Q62873 INF: Backing Up and Recovering Databases

00110 Q63212 PRB: Assignment of NULL Value to Local Variable in SQL

00111 Q63238 INF: Creating NOT NULL Character Fields Without Padded Blanks

00112 Q63605 INF: Finding Length of SQL IMAGE Fields While Using DB-Library

00113 Q63869 PRB: No Error If UPDATE or DELETE Processes 0 Rows

00114 Q63929 INF: SYSPROCESSES Table to Display Resource Information

00115 Q63932 INF: Processing Time for Update/Delete Transactions

00116 Q64176 INF: Dynamically Altering Table Definitions in SQL Server

00117 Q64229 INF: Using a Stored DATETIME Key for Data Retrieval

00118 Q64238 PRB: IF UPDATE Trigger with No Rows Changed

00119 Q64241 PRB: Errors Creating Recursive Stored Procedures

00120 Q64259 PRB: Use of Clustered Index Improves Self-Join Performance

00121 Q64559 INF: MIN and MAX Should Not Be Used on Timestamp Column

00122 Q64605 INF: Exceptions in SQL Server to ANSI X3.135-1986 Level 1

00123 Q64608 INF: SQL Server NetWare Named Pipes Information

00124 Q64610 INF: Disk Space Allocated for and Used by the Master Database

00125 Q64794 INF: Differentiating Between Timestamp and Varbinary Types

00126 Q64842 INF: Global Variable @@error Checks for Successful Completion

00127 Q65181 INF: Interpretation of SET STATISTICS TIME ON Results

00128 Q65466 INF: Object Names Cannot be Variables in TRANSACT-SQL

00129 Q65467 INF: DB2 Gateway for SQL Server

00130 Q65756 INF: Using Temporary Tables with Stored Procedures/Triggers

00131 Q65962 INF: SQL Server Net-Library (Open Architecture) Information

00132 Q65963 INF: Calculating Space for the Storage of NULL Values

00133 Q66057 PRB: Running Out of Log Space When Running Large Bulk Loads

00134 Q66472 INF: Using SQL Db-Lib Calls in Multithreaded Programming

00135 Q66677 INF: How to Determine if DBNMPIPE.EXE Is Loaded from C Program

00136 Q66678 INF: Providing Application Security Through Triggers in SQL

00137 Q66681 INF: Using BCP to Import NULL Values into Datetime Columns

00138 Q66748 INF: Invoking Stored Procedures from Embedded SQL for COBOL

00139 Q66749 INF: Using Cursors to Return Results in Embedded SQL for COBOL

00140 Q66750 INF: Using a Prepared Cursor in Embedded SQL for COBOL

00141 Q66751 INF: Branching Within Static Batch in Embedded SQL for COBOL

00142 Q66752 INF: Data Conversion Sample Program in Embedded SQL for COBOL

00143 Q66753 INF: SQL Server Does Use Floating Point Math Coprocessor

00144 Q66872 PRB: Error 7129 If Concurrent Processes Update Same Text Page

00145 Q66936 PRB: SQL Server Error 1608 in Errorlog

00146 Q66938 INF: What Happens When UPDATE Performs INSERT/DELETE

00147 Q67059 INF: Recommended File System Setup for SQL Server

00148 Q67172 INF: Using a Stored Procedure in a Cursor Definition

00149 Q67174 INF: SQL Server Update Transaction Log Information

00150 Q67303 PRB: Rolling Back Individual Rows from an INSERT Trigger

End of Page 1. There are 150 items in this page.

1981 total items under the Microsoft SQL Server Kb Articles's page.