Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Run Ident_Current function on remote server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-07 : 09:07:11
Chris writes "I'm trying to use Ident_Current to find identity values in 2 different database on 2 different servers. The documentation is no help in trying to solve this.

It states that I issue an 'Ident_Current('Tablename').

I've tried the following in my endeavors:

server.database.ident_current('kernel')
ident_current('server.database.kernel')

How can I get the result across servers?"
   

- Advertisement -