insert into RemoteServer.MyDB.dbo.Customers(....) values(....) print 'SCOPE_IDENTITY()=' + convert(char,isnull(SCOPE_IDENTITY(),0))