I know it is probably something that is staring me right in the face but...
how do you set the default font properties for a project (or all projects to
be created) so that for all objects you pull on to the report they default to
this font property? Is there a RS setting or a Visual Studio setting
somewhere that nominates the default font (I'm particularly after font family
& size defaults). The reason I am asking is that I don't want to have to
reset object by object/ group of objects every report I create...
...hoping someone can save me some time...
THX.in visual studio... tools... options... then under Environment look at "fonts
and colors"
i think this is what you are looking for?
"Bridget" wrote:
> I know it is probably something that is staring me right in the face but...
> how do you set the default font properties for a project (or all projects to
> be created) so that for all objects you pull on to the report they default to
> this font property? Is there a RS setting or a Visual Studio setting
> somewhere that nominates the default font (I'm particularly after font family
> & size defaults). The reason I am asking is that I don't want to have to
> reset object by object/ group of objects every report I create...
> ...hoping someone can save me some time...
> THX.|||Thanks Mike I was hoping that would be it - but I have tested it and have got
someone I work with to double check and changing these settings seems to just
change the environment as opposed to the defaults for the objects which is
what I am after... i.e. when I pull on a text box (or field) I want to be
able to preset the font size at which this initiates with...so I guess what
I am after is how to set the default properties for the various objects ...
any ideas..?
thx
"mike" wrote:
> in visual studio... tools... options... then under Environment look at "fonts
> and colors"
> i think this is what you are looking for?
> "Bridget" wrote:
> > I know it is probably something that is staring me right in the face but...
> > how do you set the default font properties for a project (or all projects to
> > be created) so that for all objects you pull on to the report they default to
> > this font property? Is there a RS setting or a Visual Studio setting
> > somewhere that nominates the default font (I'm particularly after font family
> > & size defaults). The reason I am asking is that I don't want to have to
> > reset object by object/ group of objects every report I create...
> >
> > ...hoping someone can save me some time...
> >
> > THX.sql
Showing posts with label properties. Show all posts
Showing posts with label properties. Show all posts
Tuesday, March 27, 2012
Sunday, March 25, 2012
Default database location?
I have the default location for Data setup to be G:\Microsoft SQL
Server\Data (Database Settings under server properties).
But, when I invoke "Copy Database" from Management, it places the data on
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
Why doesn't the Copy Database Wizard respect my setting?
OlavOlav
It probably takes it from a model database
SELECT REPLACE(filename, 'model.mdf', '') FROM master..SysDatabases
WHERE [name] = 'model'
"Olav" <x@.y.com> wrote in message
news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>I have the default location for Data setup to be G:\Microsoft SQL
>Server\Data (Database Settings under server properties).
> But, when I invoke "Copy Database" from Management, it places the data on
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
> Why doesn't the Copy Database Wizard respect my setting?
> Olav
>|||I'm confused!
Why are there multiple places to configure the same kind of option?
Olav
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uUaZJ8WXGHA.4248@.TK2MSFTNGP05.phx.gbl...
> Olav
> It probably takes it from a model database
> SELECT REPLACE(filename, 'model.mdf', '') FROM master..SysDatabases
> WHERE [name] = 'model'
>
>
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>|||You can view the default directory with the following :-
exec master..xp_regread
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft
\MSSQLServer\Setup','SQLDataRoot'
It can be changed with EnterPrise Manager, but... this change may not stick
as you need sufficient permsion to write to registry. If you find it isn't
saving you will need to logon to the box as administrator.
HTH. Ryan
"Olav" <x@.y.com> wrote in message
news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>I have the default location for Data setup to be G:\Microsoft SQL
>Server\Data (Database Settings under server properties).
> But, when I invoke "Copy Database" from Management, it places the data on
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
> Why doesn't the Copy Database Wizard respect my setting?
> Olav
>|||This is the result I got from the query on that machine:
RegQueryValueEx() returned error 2, 'The system cannot find the file
specified.'
Msg 22001, Level 1, State 1
(0 row(s) affected)
What does this indicate?
Olav
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:uDgpjEXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> You can view the default directory with the following :-
> exec master..xp_regread
> 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft
\MSSQLServer\Setup','SQLDataRoot'
> It can be changed with EnterPrise Manager, but... this change may not
> stick as you need sufficient permsion to write to registry. If you find it
> isn't saving you will need to logon to the box as administrator.
> --
> HTH. Ryan
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>|||I checked in the Registry and it shows the following value for that key:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
In SQL Server Management Studio it shows:
G:\Microsoft SQL Server\Data
I'm still confused!
Why are there two different values for the same thing stored?
I'm running Management Studio logged in as an Administrator, so there should
be no problem writing to the registry.
Olav
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:uDgpjEXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> You can view the default directory with the following :-
> exec master..xp_regread
> 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft
\MSSQLServer\Setup','SQLDataRoot'
> It can be changed with EnterPrise Manager, but... this change may not
> stick as you need sufficient permsion to write to registry. If you find it
> isn't saving you will need to logon to the box as administrator.
> --
> HTH. Ryan
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>
Server\Data (Database Settings under server properties).
But, when I invoke "Copy Database" from Management, it places the data on
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
Why doesn't the Copy Database Wizard respect my setting?
OlavOlav
It probably takes it from a model database
SELECT REPLACE(filename, 'model.mdf', '') FROM master..SysDatabases
WHERE [name] = 'model'
"Olav" <x@.y.com> wrote in message
news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>I have the default location for Data setup to be G:\Microsoft SQL
>Server\Data (Database Settings under server properties).
> But, when I invoke "Copy Database" from Management, it places the data on
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
> Why doesn't the Copy Database Wizard respect my setting?
> Olav
>|||I'm confused!
Why are there multiple places to configure the same kind of option?
Olav
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uUaZJ8WXGHA.4248@.TK2MSFTNGP05.phx.gbl...
> Olav
> It probably takes it from a model database
> SELECT REPLACE(filename, 'model.mdf', '') FROM master..SysDatabases
> WHERE [name] = 'model'
>
>
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>|||You can view the default directory with the following :-
exec master..xp_regread
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft
\MSSQLServer\Setup','SQLDataRoot'
It can be changed with EnterPrise Manager, but... this change may not stick
as you need sufficient permsion to write to registry. If you find it isn't
saving you will need to logon to the box as administrator.
HTH. Ryan
"Olav" <x@.y.com> wrote in message
news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>I have the default location for Data setup to be G:\Microsoft SQL
>Server\Data (Database Settings under server properties).
> But, when I invoke "Copy Database" from Management, it places the data on
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
> Why doesn't the Copy Database Wizard respect my setting?
> Olav
>|||This is the result I got from the query on that machine:
RegQueryValueEx() returned error 2, 'The system cannot find the file
specified.'
Msg 22001, Level 1, State 1
(0 row(s) affected)
What does this indicate?
Olav
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:uDgpjEXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> You can view the default directory with the following :-
> exec master..xp_regread
> 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft
\MSSQLServer\Setup','SQLDataRoot'
> It can be changed with EnterPrise Manager, but... this change may not
> stick as you need sufficient permsion to write to registry. If you find it
> isn't saving you will need to logon to the box as administrator.
> --
> HTH. Ryan
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>|||I checked in the Registry and it shows the following value for that key:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
In SQL Server Management Studio it shows:
G:\Microsoft SQL Server\Data
I'm still confused!
Why are there two different values for the same thing stored?
I'm running Management Studio logged in as an Administrator, so there should
be no problem writing to the registry.
Olav
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:uDgpjEXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> You can view the default directory with the following :-
> exec master..xp_regread
> 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft
\MSSQLServer\Setup','SQLDataRoot'
> It can be changed with EnterPrise Manager, but... this change may not
> stick as you need sufficient permsion to write to registry. If you find it
> isn't saving you will need to logon to the box as administrator.
> --
> HTH. Ryan
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>
Default database location?
I have the default location for Data setup to be G:\Microsoft SQL
Server\Data (Database Settings under server properties).
But, when I invoke "Copy Database" from Management, it places the data on
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
Why doesn't the Copy Database Wizard respect my setting?
OlavOlav
It probably takes it from a model database
SELECT REPLACE(filename, 'model.mdf', '') FROM master..SysDatabases
WHERE [name] = 'model'
"Olav" <x@.y.com> wrote in message
news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>I have the default location for Data setup to be G:\Microsoft SQL
>Server\Data (Database Settings under server properties).
> But, when I invoke "Copy Database" from Management, it places the data on
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
> Why doesn't the Copy Database Wizard respect my setting?
> Olav
>|||I'm confused!
Why are there multiple places to configure the same kind of option?
Olav
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uUaZJ8WXGHA.4248@.TK2MSFTNGP05.phx.gbl...
> Olav
> It probably takes it from a model database
> SELECT REPLACE(filename, 'model.mdf', '') FROM master..SysDatabases
> WHERE [name] = 'model'
>
>
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>>I have the default location for Data setup to be G:\Microsoft SQL
>>Server\Data (Database Settings under server properties).
>> But, when I invoke "Copy Database" from Management, it places the data on
>> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
>> Why doesn't the Copy Database Wizard respect my setting?
>> Olav
>|||You can view the default directory with the following :-
exec master..xp_regread
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\MSSQLServer\Setup','SQLDataRoot'
It can be changed with EnterPrise Manager, but... this change may not stick
as you need sufficient permsion to write to registry. If you find it isn't
saving you will need to logon to the box as administrator.
--
HTH. Ryan
"Olav" <x@.y.com> wrote in message
news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>I have the default location for Data setup to be G:\Microsoft SQL
>Server\Data (Database Settings under server properties).
> But, when I invoke "Copy Database" from Management, it places the data on
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
> Why doesn't the Copy Database Wizard respect my setting?
> Olav
>|||This is the result I got from the query on that machine:
RegQueryValueEx() returned error 2, 'The system cannot find the file
specified.'
Msg 22001, Level 1, State 1
(0 row(s) affected)
What does this indicate?
Olav
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:uDgpjEXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> You can view the default directory with the following :-
> exec master..xp_regread
> 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\MSSQLServer\Setup','SQLDataRoot'
> It can be changed with EnterPrise Manager, but... this change may not
> stick as you need sufficient permsion to write to registry. If you find it
> isn't saving you will need to logon to the box as administrator.
> --
> HTH. Ryan
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>>I have the default location for Data setup to be G:\Microsoft SQL
>>Server\Data (Database Settings under server properties).
>> But, when I invoke "Copy Database" from Management, it places the data on
>> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
>> Why doesn't the Copy Database Wizard respect my setting?
>> Olav
>|||I checked in the Registry and it shows the following value for that key:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
In SQL Server Management Studio it shows:
G:\Microsoft SQL Server\Data
I'm still confused!
Why are there two different values for the same thing stored?
I'm running Management Studio logged in as an Administrator, so there should
be no problem writing to the registry.
Olav
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:uDgpjEXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> You can view the default directory with the following :-
> exec master..xp_regread
> 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\MSSQLServer\Setup','SQLDataRoot'
> It can be changed with EnterPrise Manager, but... this change may not
> stick as you need sufficient permsion to write to registry. If you find it
> isn't saving you will need to logon to the box as administrator.
> --
> HTH. Ryan
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>>I have the default location for Data setup to be G:\Microsoft SQL
>>Server\Data (Database Settings under server properties).
>> But, when I invoke "Copy Database" from Management, it places the data on
>> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
>> Why doesn't the Copy Database Wizard respect my setting?
>> Olav
>
Server\Data (Database Settings under server properties).
But, when I invoke "Copy Database" from Management, it places the data on
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
Why doesn't the Copy Database Wizard respect my setting?
OlavOlav
It probably takes it from a model database
SELECT REPLACE(filename, 'model.mdf', '') FROM master..SysDatabases
WHERE [name] = 'model'
"Olav" <x@.y.com> wrote in message
news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>I have the default location for Data setup to be G:\Microsoft SQL
>Server\Data (Database Settings under server properties).
> But, when I invoke "Copy Database" from Management, it places the data on
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
> Why doesn't the Copy Database Wizard respect my setting?
> Olav
>|||I'm confused!
Why are there multiple places to configure the same kind of option?
Olav
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uUaZJ8WXGHA.4248@.TK2MSFTNGP05.phx.gbl...
> Olav
> It probably takes it from a model database
> SELECT REPLACE(filename, 'model.mdf', '') FROM master..SysDatabases
> WHERE [name] = 'model'
>
>
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>>I have the default location for Data setup to be G:\Microsoft SQL
>>Server\Data (Database Settings under server properties).
>> But, when I invoke "Copy Database" from Management, it places the data on
>> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
>> Why doesn't the Copy Database Wizard respect my setting?
>> Olav
>|||You can view the default directory with the following :-
exec master..xp_regread
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\MSSQLServer\Setup','SQLDataRoot'
It can be changed with EnterPrise Manager, but... this change may not stick
as you need sufficient permsion to write to registry. If you find it isn't
saving you will need to logon to the box as administrator.
--
HTH. Ryan
"Olav" <x@.y.com> wrote in message
news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>I have the default location for Data setup to be G:\Microsoft SQL
>Server\Data (Database Settings under server properties).
> But, when I invoke "Copy Database" from Management, it places the data on
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
> Why doesn't the Copy Database Wizard respect my setting?
> Olav
>|||This is the result I got from the query on that machine:
RegQueryValueEx() returned error 2, 'The system cannot find the file
specified.'
Msg 22001, Level 1, State 1
(0 row(s) affected)
What does this indicate?
Olav
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:uDgpjEXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> You can view the default directory with the following :-
> exec master..xp_regread
> 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\MSSQLServer\Setup','SQLDataRoot'
> It can be changed with EnterPrise Manager, but... this change may not
> stick as you need sufficient permsion to write to registry. If you find it
> isn't saving you will need to logon to the box as administrator.
> --
> HTH. Ryan
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>>I have the default location for Data setup to be G:\Microsoft SQL
>>Server\Data (Database Settings under server properties).
>> But, when I invoke "Copy Database" from Management, it places the data on
>> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
>> Why doesn't the Copy Database Wizard respect my setting?
>> Olav
>|||I checked in the Registry and it shows the following value for that key:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
In SQL Server Management Studio it shows:
G:\Microsoft SQL Server\Data
I'm still confused!
Why are there two different values for the same thing stored?
I'm running Management Studio logged in as an Administrator, so there should
be no problem writing to the registry.
Olav
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:uDgpjEXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> You can view the default directory with the following :-
> exec master..xp_regread
> 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\MSSQLServer\Setup','SQLDataRoot'
> It can be changed with EnterPrise Manager, but... this change may not
> stick as you need sufficient permsion to write to registry. If you find it
> isn't saving you will need to logon to the box as administrator.
> --
> HTH. Ryan
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>>I have the default location for Data setup to be G:\Microsoft SQL
>>Server\Data (Database Settings under server properties).
>> But, when I invoke "Copy Database" from Management, it places the data on
>> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
>> Why doesn't the Copy Database Wizard respect my setting?
>> Olav
>
Thursday, March 22, 2012
default affinitymask and affinityIOmask settings
Through the GUI for Server properties on my sql 2005 64 bit server,
I see that under processors, both set processor affinity mask and set IO
affinity mask are checked.
Is that the default ?
Also when I run
select name,value,value_in_use from sys.configurations where name like
'affinity%'
Output is as below :
affinity mask 0 0
affinity64 mask 0 0
affinity I/O mask 0 0
affinity64 I/O mask 0 0
So something does not add up. Is value the default and value_in_use the
current setting and if so, I would think that value_in_use should be 1.
I even restarted SQL. But it has the same results.Hi Hassan
All the of the affinity mask settings are bit MASKS, not just booleans. If
you set them to something non-zero, you are telling SQL Server which
processors to use. Each bit set means the corresponding processor will be
available to SQL Server.
The default is 0, which means that SQL Server will use all the available
processors.
Can you clarify what is 'set' in your GUI screen. I do not see anything that
says 'set processor affinity mask'; I have something that says
'Automatically set processor affinity mask for all processors' which is
basically telling SQL Server to use the 0 value, rather than having YOU
choose specific processors.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
> Through the GUI for Server properties on my sql 2005 64 bit server,
> I see that under processors, both set processor affinity mask and set IO
> affinity mask are checked.
> Is that the default ?
> Also when I run
> select name,value,value_in_use from sys.configurations where name like
> 'affinity%'
> Output is as below :
> affinity mask 0 0
> affinity64 mask 0 0
> affinity I/O mask 0 0
> affinity64 I/O mask 0 0
> So something does not add up. Is value the default and value_in_use the
> current setting and if so, I would think that value_in_use should be 1.
> I even restarted SQL. But it has the same results.
>
>|||Yes its the one you mentioned i.e. automatically set processor affinity mask
and automatically set IP affinity mask for all processors and they both are
checked for me.
Is that default ?
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
> Hi Hassan
> All the of the affinity mask settings are bit MASKS, not just booleans. If
> you set them to something non-zero, you are telling SQL Server which
> processors to use. Each bit set means the corresponding processor will be
> available to SQL Server.
> The default is 0, which means that SQL Server will use all the available
> processors.
> Can you clarify what is 'set' in your GUI screen. I do not see anything
> that says 'set processor affinity mask'; I have something that says
> 'Automatically set processor affinity mask for all processors' which is
> basically telling SQL Server to use the 0 value, rather than having YOU
> choose specific processors.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Hassan" <hassan@.hotmail.com> wrote in message
> news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
>> Through the GUI for Server properties on my sql 2005 64 bit server,
>> I see that under processors, both set processor affinity mask and set IO
>> affinity mask are checked.
>> Is that the default ?
>> Also when I run
>> select name,value,value_in_use from sys.configurations where name like
>> 'affinity%'
>> Output is as below :
>> affinity mask 0 0
>> affinity64 mask 0 0
>> affinity I/O mask 0 0
>> affinity64 I/O mask 0 0
>> So something does not add up. Is value the default and value_in_use the
>> current setting and if so, I would think that value_in_use should be 1.
>> I even restarted SQL. But it has the same results.
>>
>|||Yes
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:uFWlFM2PIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Yes its the one you mentioned i.e. automatically set processor affinity
> mask and automatically set IP affinity mask for all processors and they
> both are checked for me.
> Is that default ?
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
>> Hi Hassan
>> All the of the affinity mask settings are bit MASKS, not just booleans.
>> If you set them to something non-zero, you are telling SQL Server which
>> processors to use. Each bit set means the corresponding processor will
>> be available to SQL Server.
>> The default is 0, which means that SQL Server will use all the available
>> processors.
>> Can you clarify what is 'set' in your GUI screen. I do not see anything
>> that says 'set processor affinity mask'; I have something that says
>> 'Automatically set processor affinity mask for all processors' which is
>> basically telling SQL Server to use the 0 value, rather than having YOU
>> choose specific processors.
>> --
>> HTH
>> Kalen Delaney, SQL Server MVP
>> www.InsideSQLServer.com
>> http://sqlblog.com
>>
>> "Hassan" <hassan@.hotmail.com> wrote in message
>> news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
>> Through the GUI for Server properties on my sql 2005 64 bit server,
>> I see that under processors, both set processor affinity mask and set IO
>> affinity mask are checked.
>> Is that the default ?
>> Also when I run
>> select name,value,value_in_use from sys.configurations where name like
>> 'affinity%'
>> Output is as below :
>> affinity mask 0 0
>> affinity64 mask 0 0
>> affinity I/O mask 0 0
>> affinity64 I/O mask 0 0
>> So something does not add up. Is value the default and value_in_use the
>> current setting and if so, I would think that value_in_use should be 1.
>> I even restarted SQL. But it has the same results.
>>
>>
>
I see that under processors, both set processor affinity mask and set IO
affinity mask are checked.
Is that the default ?
Also when I run
select name,value,value_in_use from sys.configurations where name like
'affinity%'
Output is as below :
affinity mask 0 0
affinity64 mask 0 0
affinity I/O mask 0 0
affinity64 I/O mask 0 0
So something does not add up. Is value the default and value_in_use the
current setting and if so, I would think that value_in_use should be 1.
I even restarted SQL. But it has the same results.Hi Hassan
All the of the affinity mask settings are bit MASKS, not just booleans. If
you set them to something non-zero, you are telling SQL Server which
processors to use. Each bit set means the corresponding processor will be
available to SQL Server.
The default is 0, which means that SQL Server will use all the available
processors.
Can you clarify what is 'set' in your GUI screen. I do not see anything that
says 'set processor affinity mask'; I have something that says
'Automatically set processor affinity mask for all processors' which is
basically telling SQL Server to use the 0 value, rather than having YOU
choose specific processors.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
> Through the GUI for Server properties on my sql 2005 64 bit server,
> I see that under processors, both set processor affinity mask and set IO
> affinity mask are checked.
> Is that the default ?
> Also when I run
> select name,value,value_in_use from sys.configurations where name like
> 'affinity%'
> Output is as below :
> affinity mask 0 0
> affinity64 mask 0 0
> affinity I/O mask 0 0
> affinity64 I/O mask 0 0
> So something does not add up. Is value the default and value_in_use the
> current setting and if so, I would think that value_in_use should be 1.
> I even restarted SQL. But it has the same results.
>
>|||Yes its the one you mentioned i.e. automatically set processor affinity mask
and automatically set IP affinity mask for all processors and they both are
checked for me.
Is that default ?
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
> Hi Hassan
> All the of the affinity mask settings are bit MASKS, not just booleans. If
> you set them to something non-zero, you are telling SQL Server which
> processors to use. Each bit set means the corresponding processor will be
> available to SQL Server.
> The default is 0, which means that SQL Server will use all the available
> processors.
> Can you clarify what is 'set' in your GUI screen. I do not see anything
> that says 'set processor affinity mask'; I have something that says
> 'Automatically set processor affinity mask for all processors' which is
> basically telling SQL Server to use the 0 value, rather than having YOU
> choose specific processors.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Hassan" <hassan@.hotmail.com> wrote in message
> news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
>> Through the GUI for Server properties on my sql 2005 64 bit server,
>> I see that under processors, both set processor affinity mask and set IO
>> affinity mask are checked.
>> Is that the default ?
>> Also when I run
>> select name,value,value_in_use from sys.configurations where name like
>> 'affinity%'
>> Output is as below :
>> affinity mask 0 0
>> affinity64 mask 0 0
>> affinity I/O mask 0 0
>> affinity64 I/O mask 0 0
>> So something does not add up. Is value the default and value_in_use the
>> current setting and if so, I would think that value_in_use should be 1.
>> I even restarted SQL. But it has the same results.
>>
>|||Yes
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:uFWlFM2PIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Yes its the one you mentioned i.e. automatically set processor affinity
> mask and automatically set IP affinity mask for all processors and they
> both are checked for me.
> Is that default ?
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
>> Hi Hassan
>> All the of the affinity mask settings are bit MASKS, not just booleans.
>> If you set them to something non-zero, you are telling SQL Server which
>> processors to use. Each bit set means the corresponding processor will
>> be available to SQL Server.
>> The default is 0, which means that SQL Server will use all the available
>> processors.
>> Can you clarify what is 'set' in your GUI screen. I do not see anything
>> that says 'set processor affinity mask'; I have something that says
>> 'Automatically set processor affinity mask for all processors' which is
>> basically telling SQL Server to use the 0 value, rather than having YOU
>> choose specific processors.
>> --
>> HTH
>> Kalen Delaney, SQL Server MVP
>> www.InsideSQLServer.com
>> http://sqlblog.com
>>
>> "Hassan" <hassan@.hotmail.com> wrote in message
>> news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
>> Through the GUI for Server properties on my sql 2005 64 bit server,
>> I see that under processors, both set processor affinity mask and set IO
>> affinity mask are checked.
>> Is that the default ?
>> Also when I run
>> select name,value,value_in_use from sys.configurations where name like
>> 'affinity%'
>> Output is as below :
>> affinity mask 0 0
>> affinity64 mask 0 0
>> affinity I/O mask 0 0
>> affinity64 I/O mask 0 0
>> So something does not add up. Is value the default and value_in_use the
>> current setting and if so, I would think that value_in_use should be 1.
>> I even restarted SQL. But it has the same results.
>>
>>
>
default affinitymask and affinityIOmask settings
Through the GUI for Server properties on my sql 2005 64 bit server,
I see that under processors, both set processor affinity mask and set IO
affinity mask are checked.
Is that the default ?
Also when I run
select name,value,value_in_use from sys.configurations where name like
'affinity%'
Output is as below :
affinity mask 0 0
affinity64 mask 0 0
affinity I/O mask 0 0
affinity64 I/O mask 0 0
So something does not add up. Is value the default and value_in_use the
current setting and if so, I would think that value_in_use should be 1.
I even restarted SQL. But it has the same results.
Hi Hassan
All the of the affinity mask settings are bit MASKS, not just booleans. If
you set them to something non-zero, you are telling SQL Server which
processors to use. Each bit set means the corresponding processor will be
available to SQL Server.
The default is 0, which means that SQL Server will use all the available
processors.
Can you clarify what is 'set' in your GUI screen. I do not see anything that
says 'set processor affinity mask'; I have something that says
'Automatically set processor affinity mask for all processors' which is
basically telling SQL Server to use the 0 value, rather than having YOU
choose specific processors.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
> Through the GUI for Server properties on my sql 2005 64 bit server,
> I see that under processors, both set processor affinity mask and set IO
> affinity mask are checked.
> Is that the default ?
> Also when I run
> select name,value,value_in_use from sys.configurations where name like
> 'affinity%'
> Output is as below :
> affinity mask 0 0
> affinity64 mask 0 0
> affinity I/O mask 0 0
> affinity64 I/O mask 0 0
> So something does not add up. Is value the default and value_in_use the
> current setting and if so, I would think that value_in_use should be 1.
> I even restarted SQL. But it has the same results.
>
>
|||Yes its the one you mentioned i.e. automatically set processor affinity mask
and automatically set IP affinity mask for all processors and they both are
checked for me.
Is that default ?
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
> Hi Hassan
> All the of the affinity mask settings are bit MASKS, not just booleans. If
> you set them to something non-zero, you are telling SQL Server which
> processors to use. Each bit set means the corresponding processor will be
> available to SQL Server.
> The default is 0, which means that SQL Server will use all the available
> processors.
> Can you clarify what is 'set' in your GUI screen. I do not see anything
> that says 'set processor affinity mask'; I have something that says
> 'Automatically set processor affinity mask for all processors' which is
> basically telling SQL Server to use the 0 value, rather than having YOU
> choose specific processors.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Hassan" <hassan@.hotmail.com> wrote in message
> news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
>
|||Yes
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:uFWlFM2PIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Yes its the one you mentioned i.e. automatically set processor affinity
> mask and automatically set IP affinity mask for all processors and they
> both are checked for me.
> Is that default ?
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
>
I see that under processors, both set processor affinity mask and set IO
affinity mask are checked.
Is that the default ?
Also when I run
select name,value,value_in_use from sys.configurations where name like
'affinity%'
Output is as below :
affinity mask 0 0
affinity64 mask 0 0
affinity I/O mask 0 0
affinity64 I/O mask 0 0
So something does not add up. Is value the default and value_in_use the
current setting and if so, I would think that value_in_use should be 1.
I even restarted SQL. But it has the same results.
Hi Hassan
All the of the affinity mask settings are bit MASKS, not just booleans. If
you set them to something non-zero, you are telling SQL Server which
processors to use. Each bit set means the corresponding processor will be
available to SQL Server.
The default is 0, which means that SQL Server will use all the available
processors.
Can you clarify what is 'set' in your GUI screen. I do not see anything that
says 'set processor affinity mask'; I have something that says
'Automatically set processor affinity mask for all processors' which is
basically telling SQL Server to use the 0 value, rather than having YOU
choose specific processors.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
> Through the GUI for Server properties on my sql 2005 64 bit server,
> I see that under processors, both set processor affinity mask and set IO
> affinity mask are checked.
> Is that the default ?
> Also when I run
> select name,value,value_in_use from sys.configurations where name like
> 'affinity%'
> Output is as below :
> affinity mask 0 0
> affinity64 mask 0 0
> affinity I/O mask 0 0
> affinity64 I/O mask 0 0
> So something does not add up. Is value the default and value_in_use the
> current setting and if so, I would think that value_in_use should be 1.
> I even restarted SQL. But it has the same results.
>
>
|||Yes its the one you mentioned i.e. automatically set processor affinity mask
and automatically set IP affinity mask for all processors and they both are
checked for me.
Is that default ?
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
> Hi Hassan
> All the of the affinity mask settings are bit MASKS, not just booleans. If
> you set them to something non-zero, you are telling SQL Server which
> processors to use. Each bit set means the corresponding processor will be
> available to SQL Server.
> The default is 0, which means that SQL Server will use all the available
> processors.
> Can you clarify what is 'set' in your GUI screen. I do not see anything
> that says 'set processor affinity mask'; I have something that says
> 'Automatically set processor affinity mask for all processors' which is
> basically telling SQL Server to use the 0 value, rather than having YOU
> choose specific processors.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Hassan" <hassan@.hotmail.com> wrote in message
> news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
>
|||Yes
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:uFWlFM2PIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Yes its the one you mentioned i.e. automatically set processor affinity
> mask and automatically set IP affinity mask for all processors and they
> both are checked for me.
> Is that default ?
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
>
default affinitymask and affinityIOmask settings
Through the GUI for Server properties on my sql 2005 64 bit server,
I see that under processors, both set processor affinity mask and set IO
affinity mask are checked.
Is that the default ?
Also when I run
select name,value,value_in_use from sys.configurations where name like
'affinity%'
Output is as below :
affinity mask 0 0
affinity64 mask 0 0
affinity I/O mask 0 0
affinity64 I/O mask 0 0
So something does not add up. Is value the default and value_in_use the
current setting and if so, I would think that value_in_use should be 1.
I even restarted SQL. But it has the same results.Hi Hassan
All the of the affinity mask settings are bit MASKS, not just booleans. If
you set them to something non-zero, you are telling SQL Server which
processors to use. Each bit set means the corresponding processor will be
available to SQL Server.
The default is 0, which means that SQL Server will use all the available
processors.
Can you clarify what is 'set' in your GUI screen. I do not see anything that
says 'set processor affinity mask'; I have something that says
'Automatically set processor affinity mask for all processors' which is
basically telling SQL Server to use the 0 value, rather than having YOU
choose specific processors.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
> Through the GUI for Server properties on my sql 2005 64 bit server,
> I see that under processors, both set processor affinity mask and set IO
> affinity mask are checked.
> Is that the default ?
> Also when I run
> select name,value,value_in_use from sys.configurations where name like
> 'affinity%'
> Output is as below :
> affinity mask 0 0
> affinity64 mask 0 0
> affinity I/O mask 0 0
> affinity64 I/O mask 0 0
> So something does not add up. Is value the default and value_in_use the
> current setting and if so, I would think that value_in_use should be 1.
> I even restarted SQL. But it has the same results.
>
>|||Yes its the one you mentioned i.e. automatically set processor affinity mask
and automatically set IP affinity mask for all processors and they both are
checked for me.
Is that default ?
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
> Hi Hassan
> All the of the affinity mask settings are bit MASKS, not just booleans. If
> you set them to something non-zero, you are telling SQL Server which
> processors to use. Each bit set means the corresponding processor will be
> available to SQL Server.
> The default is 0, which means that SQL Server will use all the available
> processors.
> Can you clarify what is 'set' in your GUI screen. I do not see anything
> that says 'set processor affinity mask'; I have something that says
> 'Automatically set processor affinity mask for all processors' which is
> basically telling SQL Server to use the 0 value, rather than having YOU
> choose specific processors.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Hassan" <hassan@.hotmail.com> wrote in message
> news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
>|||Yes
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:uFWlFM2PIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Yes its the one you mentioned i.e. automatically set processor affinity
> mask and automatically set IP affinity mask for all processors and they
> both are checked for me.
> Is that default ?
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
>
I see that under processors, both set processor affinity mask and set IO
affinity mask are checked.
Is that the default ?
Also when I run
select name,value,value_in_use from sys.configurations where name like
'affinity%'
Output is as below :
affinity mask 0 0
affinity64 mask 0 0
affinity I/O mask 0 0
affinity64 I/O mask 0 0
So something does not add up. Is value the default and value_in_use the
current setting and if so, I would think that value_in_use should be 1.
I even restarted SQL. But it has the same results.Hi Hassan
All the of the affinity mask settings are bit MASKS, not just booleans. If
you set them to something non-zero, you are telling SQL Server which
processors to use. Each bit set means the corresponding processor will be
available to SQL Server.
The default is 0, which means that SQL Server will use all the available
processors.
Can you clarify what is 'set' in your GUI screen. I do not see anything that
says 'set processor affinity mask'; I have something that says
'Automatically set processor affinity mask for all processors' which is
basically telling SQL Server to use the 0 value, rather than having YOU
choose specific processors.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
> Through the GUI for Server properties on my sql 2005 64 bit server,
> I see that under processors, both set processor affinity mask and set IO
> affinity mask are checked.
> Is that the default ?
> Also when I run
> select name,value,value_in_use from sys.configurations where name like
> 'affinity%'
> Output is as below :
> affinity mask 0 0
> affinity64 mask 0 0
> affinity I/O mask 0 0
> affinity64 I/O mask 0 0
> So something does not add up. Is value the default and value_in_use the
> current setting and if so, I would think that value_in_use should be 1.
> I even restarted SQL. But it has the same results.
>
>|||Yes its the one you mentioned i.e. automatically set processor affinity mask
and automatically set IP affinity mask for all processors and they both are
checked for me.
Is that default ?
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
> Hi Hassan
> All the of the affinity mask settings are bit MASKS, not just booleans. If
> you set them to something non-zero, you are telling SQL Server which
> processors to use. Each bit set means the corresponding processor will be
> available to SQL Server.
> The default is 0, which means that SQL Server will use all the available
> processors.
> Can you clarify what is 'set' in your GUI screen. I do not see anything
> that says 'set processor affinity mask'; I have something that says
> 'Automatically set processor affinity mask for all processors' which is
> basically telling SQL Server to use the 0 value, rather than having YOU
> choose specific processors.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Hassan" <hassan@.hotmail.com> wrote in message
> news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
>|||Yes
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:uFWlFM2PIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Yes its the one you mentioned i.e. automatically set processor affinity
> mask and automatically set IP affinity mask for all processors and they
> both are checked for me.
> Is that default ?
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
>
Friday, February 24, 2012
Debugging SQL SERVER Stored Procedures
I don't see the option to debug a stored procedure. I right click onthe procedure and should'nt it appear in the properties window. Do Ineed to install some extra component to get the debugger.
I went to this link:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsdebug/html/vxlrfsettingupsqldebuggingenablingsqldebuggingonsql2000desktop.asp
And copied the .dll from the Visual Studio 2003/sqlserver it says put the file in the binn directory. Are they talking about the bin directory of the Asp.net Project.
|||okay so I copied the .dll file into SQL SERVEr Binn folder. But nowwhen I debug the strored procedure it just shows the Arrow => butwhen I press F11 so it can go to the next line It just exits
And prints the message :
// GEEK0001 is the name of my computer
The thread GEEK0001 has exicted with code 0 (0x0)
|||okay I got it to work !
:D
I don't remember clearly but IMO it was dependant on the VS.NET version. But don't take that one as granted, I really don't remember. Try Google.
Anyways,here is explained what is needed to setup debugging and how to try it out. Andhere'salso a few words how to debug in Query Analyzer and again the instructions visualized for VS.NET.
|||Thanks for the reply.I went to this link:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsdebug/html/vxlrfsettingupsqldebuggingenablingsqldebuggingonsql2000desktop.asp
And copied the .dll from the Visual Studio 2003/sqlserver it says put the file in the binn directory. Are they talking about the bin directory of the Asp.net Project.
|||okay so I copied the .dll file into SQL SERVEr Binn folder. But nowwhen I debug the strored procedure it just shows the Arrow => butwhen I press F11 so it can go to the next line It just exits
And prints the message :
// GEEK0001 is the name of my computer
The thread GEEK0001 has exicted with code 0 (0x0)
|||okay I got it to work !
:D
Subscribe to:
Posts (Atom)