469 from %s..sysusers u,%s..sysusers u1,%s..sysobjects o where o.name like '%s' and u1.name like '%s' and charindex(substring(o.type,1,1),'%s')!=0 and u1.uid=o.uid and(u.suid=suser_id()or(suser_id()=1 and u.uid=1))
470 and(suser_id()=1 or o.uid=u.uid or((select max(((sign(uid)*abs(uid-16383))*2)+(protecttype&1))from %s..sysprotects p where p.id=*o.id and(p.uid=0 or p.uid=*u.uid or p.uid=*u.gid)and(action in (193,224)))&1)=1)union
471 order by table_type, table_qualifier, table_owner, table_name
472 'SYSTEM TABLE'
473 'TABLE'
474 'VIEW'
475 select '%s' from %s..sysusers where suid=suser_id()
476 select c.name from master.dbo.syscharsets c,master.dbo.syscharsets c1,master.dbo.sysconfigures f where f.config in(123,1123) and f.value=c1.id and c1.csid=c.id
478 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
479 SET TRANSACTION ISOLATION LEVEL READ COMMITTED
481 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
483 identity
484 , =
485 SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
486 char binary decimal integer smallint float real double varchar date time timestamp longvarchar varbinary longvarbinary tinyint bit numeric
1125 select substring('NY',status/1024&1+1,1) from master..sysdatabases where name=DB_NAME()
10110 21S01
10111 21S01
10121 07008
10122 07008
10169 22003
10207 22018
10208 42S22
10209 42S02
10211 22007
10212 22007
10214 21S01
10221 22003
10222 23000
10230 42000
10231 42000
10233 22003
10234 23000
10235 22003
10236 22018
10237 22003
10238 22003
10239 22003
10240 42S02
10241 22003
10242 22007
10243 22007
10245 22003
10246 22018
10247 22003
10248 22018
10249 22003
10250 22018
10257 22018
10267 25000
10268 42S02
10273 23000
10274 23000
10278 25000
10296 22007
10297 22007
10306 22018
10311 22025
10410 22018
10513 21000
10516 23000
10518 22007
10519 22018
10520 22003
10521 22003
10522 22003
10523 22003
10524 22003
10525 22003
10530 22018
10531 23000
10536 22003
10548 23000
10551 44000
10612 25000
10629 25000
10912 08004
10917 08004
10920 01000
10927 01000
11008 22003
11011 22019
11206 40001
11212 40001
11506 23000
11509 23000
11907 42S02
11912 42S22
11914 42S11
12502 42S02
12602 23000
12616 23000
12626 40001
12627 23000
12628 23000
12706 42S21
12707 42S02
12715 42S01
12728 42S21
12729 42S02
12741 08004
13002 42S12
13310 40001
13605 23000
13606 23000
13607 01000
13608 01000
13623 01000
13702 42S02
13704 42S12
13719 42S12
13903 25000
13904 25000
13907 25000
13909 25000
14003 28000
14018 08004
14314 42S12
14315 42S02
14402 42S02
14410 21S02
14502 21S02
14503 21S02
14507 42S21
14510 42S21
14702 42S02
14903 42S02
14925 42S22
15702 01000
15704 01000
16227 42S12
16402 25000
17113 40001
18115 22018
18116 22003
18135 22012
18153 22001
18154 01003
26903 HY109
26917 34000L
26930 HY009
26931 24000
26932 24000
26935 01001
27810 08004
28451 08004
28459 08004
28460 28000
40000 Cannot drop the index
40001 Microsoft SQL Server Login
40002 table
40003 owner
40004 database
40005 stored procedure
40006 (local)
40007 Microsoft SQL Server Login
40008 Help is not available
40017 Filling listbox requires a valid Login Id and Password
40018 Filling listbox failed:\nSQLState: '%s'\n SQL Server Error: %ld\n%s
40019 Connection failed:\nSQLState: '%s'\nSQL Server Error: %ld\n%s\n
40020 &Server:
40021 (Default)
40022 Unknown Translator
40023 Select Log File
40024 Log Files(*.log)|*.log|All Files(*.*)|*.*|
40025 Query Logging Threshold field must be numeric
40026 At %s the following query executed in %lu milliseconds
40027 Error %d occurred. No description was returned by server '%s'.
40114 07001Wrong number of parameters
40115 07006Restricted data type attribute violation
40116 07S01Invalid use of default parameter
40117 08001Client unable to establish connection
40118 08004Server rejected the connection
40119 08S01Connection failure
40120 21S01Insert value list does not match column list
40121 21S02Degree of derived table does not match column list
40122 22001String data, right truncation
40123 22002Indicator variable required but not supplied
40124 22003Numeric value out of range
40125 22018Invalid character value for cast specification.
40126 22007Invalid date format
40127 22007Invalid time format
40128 22007Invalid timestamp format
40129 22026String data, length mismatch
40130 24000Invalid cursor state
40131 25000Invalid transaction state
40132 28000Invalid authorization specification
40133 28000Invalid authorization specification; Access to selected database has been denied
40134 28000Invalid authorization specification; Language specified is not supported
40135 34000Invalid cursor name
40136 42000Syntax error or access violation
40137 3C000Duplicate cursor name
40138 HY018Server declined cancel request
40140 IM006Packet size change not supported by server, default used
40141 IM008Dialog failed
40142 IM009Unable to load translation DLL
40143 IM009Translation module is not valid
40144 HY000General error
40146 HY000The stored procedure required to complete this operation could not be found on the server (they were supplied with the ODBC setup disk for the SQL Server driver). Please contact your system administrator.
40147 HY000Unknown token received from SQL Server
40148 HY000Operation not allowed while results are pending
40149 HY000Unable to load communication module. Driver has not been correctly installed.
40150 HY000Communication module is not valid. Driver has not been correctly installed.
40151 HY000Warning: Partial insert/update. The insert/update of a text or image column(s) did not succeed.
40152 HY000Connection is busy with results for another command
40153 HY000Failure during closing of connection
40154 HY000Protocol error in TDS stream
40155 HY000TDS buffer length too large
40156 HY000Non-default parameter not allowed after default parameter
40157 HY001Memory allocation failure
40158 07009Invalid Descriptor Index
40159 HY003Invalid application buffer type
40160 HY008Operation canceled
40161 HY009Invalid use of null pointer
40162 HY010Function sequence error
40163 HY011Operation invalid at this time
40164 HY015No cursor name available
40165 HY090Invalid string or buffer length
40166 HY091Invalid descriptor field identifier
40167 HY092Invalid attribute/option identifier
40168 07009Invalid parameter number
40169 HY021Inconsistent descriptor information
40170 HY021Invalid scale value
40171 HY096Invalid information type
40172 HY104Invalid precision value
40173 HY105Invalid parameter type
40174 HY106Fetch type out of range
40175 HY107Row value out of range
40176 HY109Invalid cursor position
40177 HY111Invalid bookmark value
40178 HYC00Optional feature not implemented
40179 HYT00Timeout expired
40180 08003Connection does not exist
40184 HY019Non-character and non-binary data sent in pieces
40190 07005Prepared statement is not a cursor-specification
40192 HY020Attempt to concatenate to a null or default value
40193 HY000Too many columns in select list
40194 HY016Cannot modify an implementation row descriptor
40195 HY004Invalid SQL data type
40197 22015Interval field overflow
40198 HY007Associated statement is not prepared
40199 HY024Invalid attribute value
40201 HY000Connection is not enabled for BCP
40202 HY000Unable to load DBLib
40203 HY000ODBCBCP/Driver version mismatch
40205 HY000Unicode conversion failed
40212 HY000Attempt to bulk-copy a NULL value into a Server column which does not accept NULL values
40224 HY000Attempt to bulk-copy an oversized column to the SQL Server
40227 HY000All bound columns are read-only
40228 HY000Cannot initialize SSPI package
40229 HY000Cannot generate SSPI context
40233 HY000The row length exceeds SQL Server's maximum allowable size
40234 HY000Unicode conversion failed. Code page of server not on client
40350 25S11Enlistment is not possible due to pending transaction
40351 25S12Distributed transaction error
40400 01000General warning
40401 01000Ongoing transaction has been committed
40402 01000The catalog stored procedures installed on server %s are version %s; version %02d.%02d.%4.4d or later is required to support IDBSchemaRowset. Please contact your system administrator.
40403 01000Access to database configured in the DSN has been denied. Default used.
40404 01000Language configured in the DSN is not supported. Default used.
40405 01000Procedure executed with 'EXEC'. No output parameters returned.
40406 01000An error has occurred during an attempt to access the log file, logging disabled.
40407 01000Connected to backup server
40408 01000SQL Debugging disabled
40409 01000Translation options conflict with client/server character sets
40410 01004String data, right truncation
40450 01S00Invalid connection string attribute
40451 01S01Error in row
40452 01S02Option value changed
40453 01S02Packet size change not honored by server, server size used
40454 01S02Packet size changed
40455 01S02Cursor type changed
40456 01S02Cursor concurrency changed
40457 01S02Login timeout changed
40458 01001Cursor operation conflict
40459 01S05Cancel treated as FreeStmt/Close
40460 01S06Attempt to fetch before the result returned the first rowset
40461 01S07Fractional truncation
40500 Data Source Name
40501 Driver
40502 Server
40503 Login ID
40504 Password
40505 AppName
40506 WorkStation ID
40509 Database
40510 Language
40550 Unknown NetErr.
40551 Insufficient memory.
40552 Access denied.
40553 Connection is busy.
40554 Connection broken.
40555 Connection limit exceeded.
40556 Specified SQL server not found.
40557 The network has not been started.
40558 Insufficient network resources.
40559 Network is busy.
40560 Network access denied.
40561 General network error. Check your network documentation.
40562 Incorrect connection mode.
40563 Name not found in directory service.
40564 Invalid connection.
40565 Error reading or writing network data.
40566 Too many open file handles.
40567 SQL Server does not exist or access denied.
40619 Current Catalog
40620 Active Sessions
40621 Asynchable Commit
40622 Pass By Ref Accessors
40623 Catalog Location
40624 Catalog Term
40625 Catalog Usage
40626 Column Definition
40627 NULL Concatenation Behavior
40628 Data Source Name
40629 Read-Only Data Source
40630 DBMS Name
40631 DBMS Version
40632 GROUP BY Support
40633 Heterogeneous Table Support
40634 Identifier Case Sensitivity
40635 Lock Modes
40636 Maximum Index Size
40637 Maximum Row Size
40638 Maximum Row Size Includes BLOB
40639 Maximum Tables in SELECT
40640 Multiple Storage Objects
40641 Multi-Table Update
40642 Notification Phases
40643 NULL Collation Order
40644 OLE Object Support
40645 ORDER BY Columns in Select List
40646 Prepare Commit Behavior
40647 Prepare Abort Behavior
40648 Procedure Term
40649 OLE DB Version
40650 Provider Name
40651 Provider Version
40652 Quoted Identifier Sensitivity
40653 Schema Term
40654 Schema Usage
40655 SQL Support
40656 Structured Storage
40657 Subquery Support
40658 Isolation Levels
40659 Isolation Retention
40660 Table Term
40661 User Name
40662 Transaction DDL
40663 Asynchable Abort
40664 Data Source Object Threading Model
40665 Multiple Parameter Sets
40666 Output Parameter Availability
40667 Persistent ID Type
40668 Column Recalculated Notification
40669 Column Set Notification
40670 Row Activate Notification
40671 Row Delete Notification
40672 Row First Change Notification
40673 Row Insert Notification
40674 Row Release Notification
40675 Row Resynchronization Notification
40676 Rowset Release Notification
40677 Rowset Fetch Position Change Notification
40678 Row Undo Change Notification
40679 Row Undo Delete Notification
40680 Row Undo Insert Notification
40681 Row Update Notification
40682 Rowset Conversions on Command
40683 Multiple Results
40691 ISequentialStream
40694 Preserve on Abort
40695 Blocking Storage Objects
40696 Use Bookmarks
40697 Skip Deleted Bookmarks
40698 Bookmark Type
40699 Cache Deferred Columns
40700 Fetch Backwards
40701 Hold Rows
40702 Append-Only Rowset
40703 Scroll Backwards
40704 Column Privileges
40705 Command Time Out
40706 Preserve on Commit
40707 Defer Column
40708 Delay Storage Object Updates
40709 Immobile Rows
40710 Literal Bookmarks
40711 Literal Row Identity
40712 Maximum Open Rows
40713 Maximum Pending Rows
40714 Maximum Rows
40718 Others' Inserts Visible
40719 Others' Changes Visible
40720 Own Inserts Visible
40721 Own Changes Visible
40722 Quick Restart
40723 Reentrant Events
40724 Remove Deleted Rows
40725 Report Multiple Changes
40726 Row Privileges
40727 Row Threading Model
40728 Server Cursor
40729 Objects Transacted
40730 Updatability
40731 Strong Row Identity
40732 IAccessor
40733 IColumnsInfo
40734 IColumnsRowset
40735 IConnectionPointContainer
40736 IProvideMoniker
40737 IRowset
40738 IRowsetChange
40739 IRowsetIdentity
40740 IRowsetInfo
40741 IRowsetLocate
40743 IRowsetResynch
40744 IRowsetScroll
40745 IRowsetUpdate
40746 ISupportErrorInfo
40747 Change Inserted Rows
40748 Return Pending Inserts
40749 IConvertType
40755 Cache Authentication
40756 Encrypt Password
40757 Integrated Security
40758 Mask Password
40759 Password
40760 Persist Encrypted
40761 Persist Security Info
40762 User ID
40764 Data Source
40765 Window Handle
40766 Impersonation Level
40767 Location
40768 Mode
40769 Prompt
40770 Protection Level
40771 Connect Timeout
40772 Locale Identifier
40773 Extended Properties
40774 Autocommit Isolation Levels
40775 Autoincrement
40776 Default
40778 Fixed Length
40779 Nullable
40780 Primary Key
40781 Unique
40783 Clustered
40784 Fill Factor
40788 Primary Key
40792 Unique
40793 Temporary Table
40794 Trusted Connection
40795 Current Languge
40796 Network Address
40797 Network Library
40798 Use Procedure for Prepare
40799 Auto Translate
40800 Packet Size
40801 Application Name
40802 Workstation ID
40803 Replication server name connect option
40804 Server to Server RPC server name
40805 Override the NIC in the loginrec
40806 Concurrency Type
40807 Position on the last row after insert
40808 FOR BROWSE columns hidden
40809 No FOR BROWSE table
40810 Log text and image operations
40811 Maximum BLOB Length
40812 Fastload Options
40813 Keep Nulls
40814 Keep Identity
40820 Enable Fastload
40825 Quoted Catalog Names
40901 HY000The data source can not be used, because it DBMS version is less than 6.0.0.
40903 The requested properties cannot be supported.
40904 Operation Canceled
40905 Nested variants are not supported as parameters.
40906 At least one parameter contained a type that was not supported.
40907 Unable to determine parameter type for at least one variant parameter.
40908 Cannot start transaction because more than one connection is in use.
40909 Cannot create new connection because in manual transaction mode.
40910 Can not start transaction while in firehose mode.