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