Wednesday, March 28, 2012

How to Get the SQL Affinity Mask value in Sql 2005

Hi All

Can u pls tell me How to Get the SQL Affinity Mask value in Sql 2005.

for SQL 2000 , we were using following query:

SQLStatement.printf("select c.value from master..sysconfigures c, master..spt_values v,"
"master..syscurconfigs r where v.type = 'C' and v.number = c.config and v.number >= 0 "
"and v.number = r.config and v.name ='affinity mask'");

lErrCode=SQLExecDirect(hStmt,(SQLCHAR*)pszSQLStatement,strlen(pszSQLStatement));

lSQLBindCol(nAffMask);

But With SQL 2005 , we are getting ZERO(0) ROWS SELECTED.

you could take a look at the following link in SQL 2005 book online to set the affinity mask

http://msdn2.microsoft.com/en-us/library/ms187104.aspx

Thanks

Sethu Srinivasan [MSFT]

SQL Server Manageability Dev Team

No comments:

Post a Comment