Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PiecesOfEight
Posting Yak Master
200 Posts |
 Posted - 2001-10-08 : 15:51:09
|
| Some of the data in system tables is in bitmap form. In sysprotects, for example, there is a bitmap of columns with a given permission (i.e. SELECT). The problem is that SQL stores binary as hex and I would like to just look at the binary directly, so that I can associate it with a column ordinal and then get the column name with that. So, how do I convert between the two?BTW - this relates to a question on getting permissions for user defined roles that I responded to yesterday: [url]http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=9581&FORUM_ID=6&CAT_ID=3&Topic_Title=User+Defined+Role&Forum_Title=Administration[/url] |
|
|
|
|
|
Coverting hex to binary