September 23, 2016 at 9:10 am
HI
In SQL server 2000 the sysuser table had an suid column. in Sql server 2008 that table changed to a sys view and the column name changed to the uid. the program that I am using is old and its refering to that column. is there anyway to alter those system view to map another column?
thanks
September 23, 2016 at 9:13 am
No, you can't change the definition of the system views.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2016 at 12:26 pm
No. But maybe you could create your own view with a similar name -- such as dbo.sysusers2 -- and change your code to use the view name?
create view dbo.sysusers2
as
select uid as suid, status, name, sid, roles, createdate, updatedate, altuid, password, gid,
environ, hasdbaccess, islogin, isntname, isntgroup, isntuser, issqluser, isaliased, issqlrole, isapprole
from dbo.sysusers
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
September 23, 2016 at 12:35 pm
The problem is that I dont have a way if changing the source code. this is an old ERP system (PSI) that its was based on SQL server 7. now that I am trying to upgrade the database to 2008 its complaining as its referring to the old column name...
September 23, 2016 at 12:52 pm
vblllove (9/23/2016)
The problem is that I dont have a way if changing the source code. this is an old ERP system (PSI) that its was based on SQL server 7. now that I am trying to upgrade the database to 2008 its complaining as its referring to the old column name...
I guess your options are upgrade everything or nothing.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply