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),user_name() 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
30019 Current Catalog
30020 Active Sessions
30021 Asynchable Commit
30022 Pass By Ref Accessors
30023 Catalog Location
30024 Catalog Term
30025 Catalog Usage
30026 Column Definition
30027 NULL Concatenation Behavior
30028 Data Source Name
30029 Read-Only Data Source
30030 DBMS Name
30031 DBMS Version
30032 GROUP BY Support
30033 Heterogeneous Table Support
30034 Identifier Case Sensitivity
30035 Lock Modes
30036 Maximum Index Size
30037 Maximum Row Size
30038 Maximum Row Size Includes BLOB
30039 Maximum Tables in SELECT
30040 Multiple Storage Objects
30041 Multi-Table Update
30042 Notification Phases
30043 NULL Collation Order
30044 OLE Object Support
30045 ORDER BY Columns in Select List
30046 Prepare Commit Behavior
30047 Prepare Abort Behavior
30048 Procedure Term
30049 OLE DB Version
30050 Provider Name
30051 Provider Version
30052 Quoted Identifier Sensitivity
30053 Schema Term
30054 Schema Usage
30055 SQL Support
30056 Structured Storage
30057 Subquery Support
30058 Isolation Levels
30059 Isolation Retention
30060 Table Term
30061 User Name
30062 Transaction DDL
30063 Asynchable Abort
30064 Data Source Object Threading Model
30065 Multiple Parameter Sets
30066 Output Parameter Availability
30067 Persistent ID Type
30068 Column Recalculated Notification
30069 Column Set Notification
30070 Row Activate Notification
30071 Row Delete Notification
30072 Row First Change Notification
30073 Row Insert Notification
30074 Row Release Notification
30075 Row Resynchronization Notification
30076 Rowset Release Notification
30077 Rowset Fetch Position Change Notification
30078 Row Undo Change Notification
30079 Row Undo Delete Notification
30080 Row Undo Insert Notification
30081 Row Update Notification
30082 Rowset Conversions on Command
30083 Multiple Results
30091 ISequentialStream
30094 Preserve on Abort
30095 Blocking Storage Objects
30096 Use Bookmarks
30097 Skip Deleted Bookmarks
30098 Bookmark Type
30099 Cache Deferred Columns
30100 Fetch Backwards
30101 Hold Rows
30102 Append-Only Rowset
30103 Scroll Backwards
30104 Column Privileges
30105 Command Time Out
30106 Preserve on Commit
30107 Defer Column
30108 Delay Storage Object Updates
30109 Immobile Rows
30110 Literal Bookmarks
30111 Literal Row Identity
30112 Maximum Open Rows
30113 Maximum Pending Rows
30114 Maximum Rows
30118 Others' Inserts Visible
30119 Others' Changes Visible
30120 Own Inserts Visible
30121 Own Changes Visible
30122 Quick Restart
30123 Reentrant Events
30124 Remove Deleted Rows
30125 Report Multiple Changes
30126 Row Privileges
30127 Row Threading Model
30128 Server Cursor
30129 Objects Transacted
30130 Updatability
30131 Strong Row Identity
30132 IAccessor
30133 IColumnsInfo
30134 IColumnsRowset
30135 IConnectionPointContainer
30136 Notification Granularity
30137 IRowset
30138 IRowsetChange
30139 IRowsetIdentity
30140 IRowsetInfo
30141 IRowsetLocate
30143 IRowsetResynch
30144 IRowsetScroll
30145 IRowsetUpdate
30146 ISupportErrorInfo
30147 Change Inserted Rows
30148 Return Pending Inserts
30149 IConvertType
30150 Maximum Open Chapters
30151 Maximum OR Conditions
30152 Maximum Sort Columns
30153 Sort on Index
30155 Cache Authentication
30156 Encrypt Password
30157 Integrated Security
30158 Mask Password
30159 Password
30160 Persist Encrypted
30161 Persist Security Info
30162 User ID
30164 Data Source
30165 Window Handle
30166 Impersonation Level
30167 Location
30168 Mode
30169 Prompt
30170 Protection Level
30171 Connect Timeout
30172 Locale Identifier
30173 Extended Properties
30174 Autocommit Isolation Levels
30175 Autoincrement
30176 Default
30178 Fixed Length
30179 Nullable
30180 Primary Key
30181 Unique
30183 Clustered
30184 Fill Factor
30188 Primary Key
30192 Unique
30193 Temporary Table
30195 Current Language
30196 Network Address
30197 Network Library
30198 Use Procedure for Prepare
30199 Auto Translate
30200 Packet Size
30201 Application Name
30202 Workstation ID
30203 Replication server name connect option
30204 Server to Server RPC server name
30205 Override the NIC in the loginrec
30211 Maximum BLOB Length
30212 Fastload Options
30213 Keep Nulls
30214 Keep Identity
30220 Enable Fastload
30225 Quoted Catalog Names
30226 Provider Friendly Name
30227 Connection Status
30228 Bookmark Information
30229 Server Name
30230 Open Rowset Support
30231 Initial Catalog
30232 Initial File Name
30233 Multiple Connections
30234 Access Order
30235 IMultipleResults
30236 Lock Mode
30237 Server Data on Insert
30238 Unique Rows
30239 Unicode Locale Id
30240 Unicode Comparision Style
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 derive parameter information for a temporary stored procedure.
40203 HY000ODBCBCP/Driver version mismatch
40205 HY000Unicode conversion failed
40206 HY000Cannot insert or update columns from multiple tables.
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
40237 HY000An old netlib (%s) has been detected. Please delete it and restart the application.
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.
40601 HY000The data source can not be used, because it DBMS version is less than 6.5.0.
40602 Microsoft OLE DB Provider for SQL Server
40603 The requested properties cannot be supported.
40604 Operation Canceled
40605 Nested variants are not supported as parameters.
40606 At least one parameter contained a type that was not supported.
40607 Unable to determine parameter type for at least one variant parameter.
40608 Cannot start transaction because more than one connection is in use.
40609 Cannot create new connection because in manual transaction mode.
40610 Cannot start transaction while in firehose mode.
40611 HY000The data source can not be used, because it is not a Microsoft SQL Server.