Getting IDENT_CURRENT value as NULL

Hello,
I am getting everything fine at my machine database, for all tables
having identity columns I am getting the identity values properly. Using
this:
declare @.test int
set @.test = ident_current('Track_Changes_Table')
print @.test
However at the client production machine I am not getting any value
printed i.e. it is coming NULL. Any idea about the cause for this
problem.
Please help. . Thanks in advance.
Neha Magia
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
is this transactional or merge?
If transactional identity columns are not replicated as identity columns by
default.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Neha Magia" <nehamagia9@.yahoo.com> wrote in message
news:%23ulCPwd3EHA.1144@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I am getting everything fine at my machine database, for all tables
> having identity columns I am getting the identity values properly. Using
> this:
> declare @.test int
> set @.test = ident_current('Track_Changes_Table')
> print @.test
>
> However at the client production machine I am not getting any value
> printed i.e. it is coming NULL. Any idea about the cause for this
> problem.
> Please help. . Thanks in advance.
> Neha Magia
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!