2005 Internal Functions

There are several instances where I've seen this sort of thing:
%%ColumnEx(ObjectID = @.object_id, Name =
@.identity_column).SetIdentityNotForRepl(Value = @.value).
Anyone know what the full syntax is, where they are listed, if we can take
advantage of them etc?
TIA
Those are, as you noted, internal functions -- they are undocumented and
available only within the scope of the resource database. I haven't seen
anything yet, but I'm sure at some point someone will figure out how to hack
SQL Server to get a full list of them -- it's only a matter of time
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"JB" <JB@.Acme.Com> wrote in message
news:OujsIr2IGHA.3452@.TK2MSFTNGP12.phx.gbl...
> There are several instances where I've seen this sort of thing:
> %%ColumnEx(ObjectID = @.object_id, Name =
> @.identity_column).SetIdentityNotForRepl(Value = @.value).
> Anyone know what the full syntax is, where they are listed, if we can take
> advantage of them etc?
> TIA
>
|||I think that the proc sp_identitycolumnforreplication will do what you are
looking for. These system calls are only executable by system processes. You
may be able to find references to them in the system stored procedures and
functions. I don't know how to call them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JB" <JB@.Acme.Com> wrote in message
news:OujsIr2IGHA.3452@.TK2MSFTNGP12.phx.gbl...
> There are several instances where I've seen this sort of thing:
> %%ColumnEx(ObjectID = @.object_id, Name =
> @.identity_column).SetIdentityNotForRepl(Value = @.value).
> Anyone know what the full syntax is, where they are listed, if we can take
> advantage of them etc?
> TIA
>
|||And even if someone does, they are undocumented for a reason. There is no
guarantee they will function the same from one hotfix to another let alone
one service pack to another. What are you trying to do?
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uM7vn42IGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Those are, as you noted, internal functions -- they are undocumented and
> available only within the scope of the resource database. I haven't seen
> anything yet, but I'm sure at some point someone will figure out how to
> hack SQL Server to get a full list of them -- it's only a matter of time
>
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "JB" <JB@.Acme.Com> wrote in message
> news:OujsIr2IGHA.3452@.TK2MSFTNGP12.phx.gbl...
>