Menampilkan nama tabel yang berisi NIP tersebut

 DECLARE @NIP VARCHAR(50) = '123456789';
DECLARE @SQL NVARCHAR(MAX) = '';

CREATE TABLE #Hasil (
    NamaTabel VARCHAR(256)
);

SELECT @SQL = @SQL +
'
IF EXISTS (
    SELECT 1
    FROM [' + TABLE_SCHEMA + '].[' + TABLE_NAME + ']
    WHERE nip = ''' + @NIP + '''
)
INSERT INTO #Hasil
VALUES (''' + TABLE_SCHEMA + '.' + TABLE_NAME + ''');
'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'nip';

EXEC sp_executesql @SQL;

SELECT * FROM #Hasil;

DROP TABLE #Hasil;