Flip those around 🙂

UPDATE MyTbl SET MyCol = 1

WHERE somecol = somecriteria

IF @@ROWCOUNT = 0

PRINT 'no such row exists'

ELSE

...

Please look at this posting from a previous topic as regards to how you can query greater than 1000 objects in Active Directory.

http://www.sqlservercentral.com/Forums/Topic472463-149-1.aspx#bm568643%5D

Look to see if the batch processing uses a parallel plan.

Could you define exactly what the processing is doing?

Do you receive a list of people that used the discount code for the summit?

I actually searches the first two characters I belive, so the odds of running into that issue are even more remote.

This will bring back every user account in AD (you can restrict it to certain OU where you would place your LDAP information) and put it in a table called...

The whole backup and restore functionality is somewhat funky with Sharepoint, and it might not function with the processes that you currently use.

I found the problem, I mistakenly removed the <> around the LDAP details, it works now.

Thanks, great script, something I have desperately needs for a while.

I am unable to get this to work.

I've replaced the with my AD information, however get an error. Having performed ADSI queries before I am not sure how...

That's probably your issue. With the Primary Key not being partitioned, effectively neither is the data any longer.

I've found that any indexes on the table have to have the partitioning...

I think it's a great idea. A great many products are out there, and they are not being used, or looked at as there is always that learning curve, or...

Unfortunately I was not involved in...

Part of the problem is that the 10g client will not connect to an 8i database, you have to use the 9i or 8i client.

The articles are great, however I don't see a resolution to my problem.

By the looks of things I will have to drop the pk index and recreate it as a...

That drops the function, would that not lead to the data no longer being partitioned? I only want to be rid of the data on a single partition.