computation for computed columns in sysservers

What is the computation for the sysservers table for the dataaccess and
isremote columns ? How can i find out the computation ?
Was trying to update the column and received a message that the column
cannot be modified since its a computed columnHassan,
Why are you trying to update system tables directly? This is not supported
and not advisable. Use sp_serveroption system SP instead.
--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:%23D$4kKKzFHA.1264@.tk2msftngp13.phx.gbl...
> What is the computation for the sysservers table for the dataaccess and
> isremote columns ? How can i find out the computation ?
> Was trying to update the column and received a message that the column
> cannot be modified since its a computed column
>
>|||sp_addserver and sp_dropserver are the interfaces to that table.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:e8KWFVKzFHA.1132@.TK2MSFTNGP10.phx.gbl...
> Hassan,
> Why are you trying to update system tables directly? This is not supported
> and not advisable. Use sp_serveroption system SP instead.
> --
> Dejan Sarka, SQL Server MVP
> Mentor
> www.SolidQualityLearning.com
>
> "Hassan" <hassanboy@.hotmail.com> wrote in message
> news:%23D$4kKKzFHA.1264@.tk2msftngp13.phx.gbl...
>> What is the computation for the sysservers table for the dataaccess and
>> isremote columns ? How can i find out the computation ?
>> Was trying to update the column and received a message that the column
>> cannot be modified since its a computed column
>>
>|||just in general, if i have a computed column, how does one view the
computations tied to those columns ?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OQOlBeLzFHA.3660@.TK2MSFTNGP15.phx.gbl...
> sp_addserver and sp_dropserver are the interfaces to that table.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:e8KWFVKzFHA.1132@.TK2MSFTNGP10.phx.gbl...
>> Hassan,
>> Why are you trying to update system tables directly? This is not
>> supported and not advisable. Use sp_serveroption system SP instead.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor
>> www.SolidQualityLearning.com
>>
>> "Hassan" <hassanboy@.hotmail.com> wrote in message
>> news:%23D$4kKKzFHA.1264@.tk2msftngp13.phx.gbl...
>> What is the computation for the sysservers table for the dataaccess and
>> isremote columns ? How can i find out the computation ?
>> Was trying to update the column and received a message that the column
>> cannot be modified since its a computed column
>>
>>
>|||Seems to be in syscomments.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Hassan" <hassanboy@.hotmail.com> wrote in message news:%23nsmjDVzFHA.3408@.TK2MSFTNGP09.phx.gbl...
> just in general, if i have a computed column, how does one view the
> computations tied to those columns ?
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:OQOlBeLzFHA.3660@.TK2MSFTNGP15.phx.gbl...
>> sp_addserver and sp_dropserver are the interfaces to that table.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
>> message news:e8KWFVKzFHA.1132@.TK2MSFTNGP10.phx.gbl...
>> Hassan,
>> Why are you trying to update system tables directly? This is not
>> supported and not advisable. Use sp_serveroption system SP instead.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor
>> www.SolidQualityLearning.com
>>
>> "Hassan" <hassanboy@.hotmail.com> wrote in message
>> news:%23D$4kKKzFHA.1264@.tk2msftngp13.phx.gbl...
>> What is the computation for the sysservers table for the dataaccess and
>> isremote columns ? How can i find out the computation ?
>> Was trying to update the column and received a message that the column
>> cannot be modified since its a computed column
>>
>>
>>
>|||In Query Analyzer, press F8 to open the Object Browser, right-click the
table, click Script to new window as > Create.
Don't ever alter or update system tables directly.
--
David Portas
SQL Server MVP
--|||Sure they are, but not the only ones; actually, they are very basic ones.
You add linked servers with sp_addlinkedserver; you change the server
options, like data access, with sp_serveroption, as I correctly mentioned.
All these procedures are described in BOL.
--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OQOlBeLzFHA.3660@.TK2MSFTNGP15.phx.gbl...
> sp_addserver and sp_dropserver are the interfaces to that table.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:e8KWFVKzFHA.1132@.TK2MSFTNGP10.phx.gbl...
>> Hassan,
>> Why are you trying to update system tables directly? This is not
>> supported and not advisable. Use sp_serveroption system SP instead.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor
>> www.SolidQualityLearning.com
>>
>> "Hassan" <hassanboy@.hotmail.com> wrote in message
>> news:%23D$4kKKzFHA.1264@.tk2msftngp13.phx.gbl...
>> What is the computation for the sysservers table for the dataaccess and
>> isremote columns ? How can i find out the computation ?
>> Was trying to update the column and received a message that the column
>> cannot be modified since its a computed column
>>
>>
>