This would be a solution to your problem. (Probably some extra error handling will be needed, to check that it only accepts upper case chars, and so on..) But the...

Apparently there is not too much experience on this topic.

I would like to use the mssql.mib database, but I would also like to be able to raise a custom SMNP...

Daniel,

The batch file was calling some 3th party product batch files which call Java and they also changed the active directory a few times.

I needed to simplified this, and indeed...

Yelena,

That was my original question: how to use the page size within a linked server. But indeed, there is no option but to partition. I partitioned on the first charachter...

By the way, I ended up with the following code. Thanks for helping.

Jan

CREATE TABLE #tmpADUsers

 (  employeeId varchar(10) NULL,

  SAMAccountName varchar(255) NOT NULL,

  email  varchar(255) NULL)

GO

/* AD is limited to send 1000 records in one batch....

Vinny & Newbie,

Thanks, but I knew this. My question is: how can we do this paging from the OPENQUERY function?

In a vb script (or for that matter any language that...