• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 352
  • Last Modified:

Hardware ID from within SQL7.0

Is there any way to get some unique hardware ID from within MSSQL 7.0 ? I know I can do it via Windows APIs from my application. But is there anything built-into SQL 7.0, some system stored procedure or table holding some ids or whatever. This is for licencing purposes,to lock/unlock software.
I do not want to wite my own Extended stored procedure to do this.

1 Solution
alexkAuthor Commented:
Edited text of question.
There is no such thing in SQL Server, however you can easily add it - either write your own OLE server which gets this unique ID via WinAPI and then call it from SQL server using sp_OA... stored procedures. Or you can write your own extended stored procedure(in VC++ 6.0 there is a wizard which helps you do that) and call the WinAPI in this extended stored procedure

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now