We are in the process of upgrading from v11 to v17 (if nothing else to get away from 'all threads are blocked' messages) and noticed that a utility to update tables based on the content in another DB/table suddenly stopped working
In v11 we could return a full list of all the tables we created (not system ones) using
SELECT Name FROM sysobjects WHERE UID = 7
and loop though them adding columns that might not be there..
Now, it seems, the UID for these is 1 - is there a reason for this change?
A big thank you to Graeme (this forum) who put in a good few hours today to fix an issue where I could not login anymore - with the total lack of any support from SAP I was beginning to think we would have to move to MS SQL
asked 03 Jan, 15:58
I do not know the reason why your UID has changed from 7 to 1 - I'm not even sure what user UID 7 would have been? - but I would say that you should never depend on hard coded numbers (in this case UIDs) in your scripts. Rather you should always lookup the UID from the SYSUSERS view (or lookup user_id in SYSUSER table) using the name of the user, in this case DBA.
answered 03 Jan, 16:15