HP is using undocumented MS SQL functions ....

Nikita Rambarransingh

Good Day All,

 

  I am trying to install the MediaBin 8.2 dataase on SQL Server.  One of the tables, dbo.MetaData, creates a computed field which has a referrence to an undocumented funciton called "sys.fn_repl_hash_binary".  In SQL Studio Mgr, you can find this in the master db, sys schema.

 

  However, as I am working in an Enterprise environment, I am only dbowner, temporarily while we setup the db, but, once that is done, our priv.'s will revert to data_reader/writer.

 

  The DBA's are reluctant to create the ref to the function, or grant me the permissions to create it due to security concerns.  I kind of see where they are coming from.

 

  I have to wonder - Whhhhyyyyy is HP using an undocmented function in their code ?

 

  Soooo, the question is - what are my options ?  I am thinking, to get the installation moving, I want to remove the col for now, get the db setup, and then Alter the table later.

 

Err msg: 

The REFERENCES permission was denied on the object 'fn_repl_hash_binary', database 'mssqlsystemresource', schema 'sys'.

 

Comments / Suugestion please.

 

Thnx,

Nick - DND Canada

Nikita Rambarransingh

Good Day All,

 

  I may have solved this.  The dbo.metadata table had an xml field as the result of a function call.  Its computed as each row is accessed.

 

  The problem was, when creating a table like this, you are creating a binding to the function, which is in a Microsoft library somewhere.  If the DBA's try to update that library, they will not be able to until the binding is dropped.  Not reasonable.

 

My solution (I think):  I created my own function in the MediaBin db, and bound the table to that function.  The function simply calls the MS library and returns what ever it gets.

 

I wanna say that is gonna work.  HP ?

 

Thanks,

Nikita