Avinash Kothare

Jul 20, 2016 at 10:19 PM

ASE 16 : missing token in master.dbo.spt_values

142 Views

The token #205, 'Grant' existing in master..spt_values in ASE 15.5 is dropped from ASE 16 version.

Any reason why this could be ?

One of our scripts malfunctioned because it expected the token "Grant" at #205

Ran query below to find the tokens and names

select left(v.name,40) as name, v.number from master.dbo.spt_values v where v.type='T'

go

ASE 15 list

TOKEN VALUES -1

References 151

Set Proxy 167

Select 193

Insert 195

Delete 196

Update 197

Create Table 198

Create Database 203

Grant 205

..... /<snip>

ASE 16 list

Token Values -1

Select Builtin 5

DBCC Checkalloc 17

DBCC Checkalloc Any Database 18

DBCC Checkcatalog 21

DBCC Checkcatalog Any Database 22

Allow Hadr Login 23

DBCC Checkdb 25

DBCC Checkdb Any Database 26

DBCC Checkindex 29

DBCC Checkindex Any Database 30

DBCC Checkstorage 33

DBCC Checkstorage Any Database 34

DBCC Checktable 37

DBCC Checktable Any Database 38

DBCC Checkverify 41

DBCC Checkverify Any Database 42

DBCC Fix_text 45

DBCC Fix_text Any Database 46

DBCC Indexalloc 49

DBCC Indexalloc Any Database 50

DBCC Reindex 53

DBCC Reindex Any Database 54

DBCC Tablealloc 57

DBCC Tablealloc Any Database 58

DBCC Textalloc 61

DBCC Textalloc Any Database 62

DBCC Monitor 64

DBCC Tune 65

Setuser 136

References 151

Set Proxy 167

Select 193

Insert 195

Delete 196

Update 197

Create Table 198

Create Database 203

Create View 207

Create Trigger 221

.... <snip>

Avinash