|
|
You're in the
sql server notification services
group:SubscriberDevice.ID ???
sql server notification services:
SubscriberDevice does not have the ID field ! How you guys identify the device?
The ID is an internally used indentifier, not intended to be used by
applications. Your application should identify devices by name. For a given subscriber, all devices must have a unique name. So, the pair [SubscriberID, DeviceName] is always unique. Hope this helps. -shyam -- Learn more about SQL-NS: http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/ --------------------------------------------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm. --------------------------------------------- [quoted text, click to view] "tarpan" <tarpan@discussions.microsoft.com> wrote in message news:F0C27152-0FFD-45AC-B00D-099B99B14126@microsoft.com... > Hello, > > SubscriberDevice does not have the ID field ! How you guys identify the > device? > Name is read only field (once entered it can not be changed).
%-)
ID is not intended to be used by applications??? If I use Name as an ID that field I have to use as a Name? DB basics (extremly simplified): - Every entity has to has ID and Name. - ID is a unique key used inside the application for address the enity - Name is some enity parameter presentable for a user I can "identify devices by name". But what field I have to present to the user? Let say user has added device with name "email". Next day the user has dicided to rename "email" to "E-mail". Apperantly, it is not possible, because Name field IS the ID and ID can not be changed. What to do? [quoted text, click to view] "Shyam Pather [MSFT]" wrote:
> The ID is an internally used indentifier, not intended to be used by > applications. Your application should identify devices by name. For a given > subscriber, all devices must have a unique name. So, the pair [SubscriberID, > DeviceName] is always unique. > Hope this helps. > -shyam > > -- > Learn more about SQL-NS: > http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/ > --------------------------------------------- > This posting is provided "AS IS" with no warranties, and confers no rights. > Use of included script samples are subject to the terms specified at > http://www.microsoft.com/info/cpyright.htm. > --------------------------------------------- > "tarpan" <tarpan@discussions.microsoft.com> wrote in message > news:F0C27152-0FFD-45AC-B00D-099B99B14126@microsoft.com... > > Hello, > > > > SubscriberDevice does not have the ID field ! How you guys identify the > > device? > > Name is read only field (once entered it can not be changed). > >
[SubscriberId, DeviceName] is the only unique identifier for subscriber
devices. If you want to change the subscriber device name, you have to create a new subscriber device with the new name, copy over all the properties from the old device, and then delete the old device. -shyam -- Learn more about SQL-NS: http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/ --------------------------------------------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm. --------------------------------------------- [quoted text, click to view] "tarpan" <tarpan@discussions.microsoft.com> wrote in message news:870F7881-EB32-4A9B-9663-1FF650609732@microsoft.com... > %-) > ID is not intended to be used by applications??? > If I use Name as an ID that field I have to use as a Name? > > DB basics (extremly simplified): > - Every entity has to has ID and Name. > - ID is a unique key used inside the application for address the enity > - Name is some enity parameter presentable for a user > > I can "identify devices by name". But what field I have to present to the > user? Let say user has added device with name "email". Next day the user has > dicided to rename "email" to "E-mail". Apperantly, it is not possible, > because Name field IS the ID and ID can not be changed. What to do? > > > > > "Shyam Pather [MSFT]" wrote: > > > The ID is an internally used indentifier, not intended to be used by > > applications. Your application should identify devices by name. For a given > > subscriber, all devices must have a unique name. So, the pair [SubscriberID, > > DeviceName] is always unique. > > Hope this helps. > > -shyam > > > > -- > > Learn more about SQL-NS: > > http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/ > > --------------------------------------------- > > This posting is provided "AS IS" with no warranties, and confers no rights. > > Use of included script samples are subject to the terms specified at > > http://www.microsoft.com/info/cpyright.htm. > > --------------------------------------------- > > "tarpan" <tarpan@discussions.microsoft.com> wrote in message > > news:F0C27152-0FFD-45AC-B00D-099B99B14126@microsoft.com... > > > Hello, > > > > > > SubscriberDevice does not have the ID field ! How you guys identify the > > > device? > > > Name is read only field (once entered it can not be changed). > > > > > >
I posted a reply to this yesterday, but for some reason it hasn't shown up
in the newsgroup. I'll try to restate my reply here: [SubscriberId, DeviceName] is the unique key for subscriber devices. In the NS design, there is no seperable "friendly name" built into the subscriber device records. In general, NS tries to stay away from storing presentation-level data because every application has different requirements for this type of data and it is very difficult to design a generic solution. You can always store "presentation names" yourself in a separate table and refer to the NS subscriber device records by [SubscriberId, DeviceName]. If you don't want to explicitly store the friendly name yourself, you can also achieve the same thing by creating a new NS subscriber device with the new name, copying over the other properties from the old device, and then deleting the old device. -shyam -- Learn more about SQL-NS: http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/ --------------------------------------------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm. --------------------------------------------- [quoted text, click to view] "tarpan" <tarpan@discussions.microsoft.com> wrote in message news:870F7881-EB32-4A9B-9663-1FF650609732@microsoft.com... > %-) > ID is not intended to be used by applications??? > If I use Name as an ID that field I have to use as a Name? > > DB basics (extremly simplified): > - Every entity has to has ID and Name. > - ID is a unique key used inside the application for address the enity > - Name is some enity parameter presentable for a user > > I can "identify devices by name". But what field I have to present to the > user? Let say user has added device with name "email". Next day the user has > dicided to rename "email" to "E-mail". Apperantly, it is not possible, > because Name field IS the ID and ID can not be changed. What to do? > > > > > "Shyam Pather [MSFT]" wrote: > > > The ID is an internally used indentifier, not intended to be used by > > applications. Your application should identify devices by name. For a given > > subscriber, all devices must have a unique name. So, the pair [SubscriberID, > > DeviceName] is always unique. > > Hope this helps. > > -shyam > > > > -- > > Learn more about SQL-NS: > > http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/ > > --------------------------------------------- > > This posting is provided "AS IS" with no warranties, and confers no rights. > > Use of included script samples are subject to the terms specified at > > http://www.microsoft.com/info/cpyright.htm. > > --------------------------------------------- > > "tarpan" <tarpan@discussions.microsoft.com> wrote in message > > news:F0C27152-0FFD-45AC-B00D-099B99B14126@microsoft.com... > > > Hello, > > > > > > SubscriberDevice does not have the ID field ! How you guys identify the > > > device? > > > Name is read only field (once entered it can not be changed). > > > > > >
Thank you for the help.
[quoted text, click to view] "Shyam Pather [MSFT]" wrote:
> I posted a reply to this yesterday, but for some reason it hasn't shown up > in the newsgroup. I'll try to restate my reply here: > > [SubscriberId, DeviceName] is the unique key for subscriber devices. In the > NS design, there is no seperable "friendly name" built into the subscriber > device records. In general, NS tries to stay away from storing > presentation-level data because every application has different requirements > for this type of data and it is very difficult to design a generic solution. > You can always store "presentation names" yourself in a separate table and > refer to the NS subscriber device records by [SubscriberId, DeviceName]. > > If you don't want to explicitly store the friendly name yourself, you can > also achieve the same thing by creating a new NS subscriber device with the > new name, copying over the other properties from the old device, and then > deleting the old device. > > -shyam > > -- > Learn more about SQL-NS: > http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/ > --------------------------------------------- > This posting is provided "AS IS" with no warranties, and confers no rights. > Use of included script samples are subject to the terms specified at > http://www.microsoft.com/info/cpyright.htm. > --------------------------------------------- > "tarpan" <tarpan@discussions.microsoft.com> wrote in message > news:870F7881-EB32-4A9B-9663-1FF650609732@microsoft.com... > > %-) > > ID is not intended to be used by applications??? > > If I use Name as an ID that field I have to use as a Name? > > > > DB basics (extremly simplified): > > - Every entity has to has ID and Name. > > - ID is a unique key used inside the application for address the enity > > - Name is some enity parameter presentable for a user > > > > I can "identify devices by name". But what field I have to present to the > > user? Let say user has added device with name "email". Next day the user > has > > dicided to rename "email" to "E-mail". Apperantly, it is not possible, > > because Name field IS the ID and ID can not be changed. What to do? > > > > > > > > > > "Shyam Pather [MSFT]" wrote: > > > > > The ID is an internally used indentifier, not intended to be used by > > > applications. Your application should identify devices by name. For a > given > > > subscriber, all devices must have a unique name. So, the pair > [SubscriberID, > > > DeviceName] is always unique. > > > Hope this helps. > > > -shyam > > > > > > -- > > > Learn more about SQL-NS: > > > http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/ > > > --------------------------------------------- > > > This posting is provided "AS IS" with no warranties, and confers no > rights. > > > Use of included script samples are subject to the terms specified at > > > http://www.microsoft.com/info/cpyright.htm. > > > --------------------------------------------- > > > "tarpan" <tarpan@discussions.microsoft.com> wrote in message > > > news:F0C27152-0FFD-45AC-B00D-099B99B14126@microsoft.com... > > > > Hello, > > > > > > > > SubscriberDevice does not have the ID field ! How you guys identify > the > > > > device? > > > > Name is read only field (once entered it can not be changed). > > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |