Do you have adequate permissions in AD to query and pull back the list?

Here is a query that you could integrate into xp_cmdshell if you wanted.

dsquery user -limit 0 |...

George has a good point. There are scripts available to help automate the index reorgs rebuilds in smaller chunks at a time.

Smaller reindex operations will help to keep the...

NP.

One last tidbit. It was written in 2k5. If it needs to work for SQL 2000, you will need to modify as you need.:cool:

Thanks for the update on what finally worked for you in this scenario.

DBAgal (11/18/2009)

---

Matt Miller (#4) (11/18/2009)

---

Would there be a downside to that data getting...

Read this Blog Post on Nolock

Q. Will nolock provide a performance boost?

A. Yes it could, as well as provide unexpected results.

Read the article, it outlines some precautions with...

Lynn Pettis (11/18/2009)

---

But guys and gals, I strive for those lonely souls who just haven't seen the light, the joy when the cfl finally comes on is so fulfilling! ...

Are you able to connect in Management Studio using the IP?

And to combine the two:

With IndexSize as (

SELECT objectname = object_name(object_id) ,reservedpages = SUM (reserved_page_count),usedpages = SUM (used_page_count)

,pages = SUM (

CASE

WHEN (index_id < 2)

THEN (in_row_data_page_count + lob_used_page_count + row_overflow_used_page_count)

ELSE lob_used_page_count...

With IndexSize as (

SELECT objectname = object_name(object_id) ,reservedpages = SUM (reserved_page_count),usedpages = SUM (used_page_count)

,pages = SUM (

CASE

WHEN (index_id < 2)

THEN (in_row_data_page_count + lob_used_page_count + row_overflow_used_page_count)

ELSE lob_used_page_count + row_overflow_used_page_count

END

)

,srowCount = SUM...

Yes, you will need to verify that 1335 is permitted through your firewall. You will also need to verify that the server is listening on 1335. Verify that...

Liger - it's a mythical creature

It is possible to put a database in the dmz, as long as the data is disclosable (application centric), and then firewall it off. Typically, customer data should not...

Are you trying to create a scenario where every combination must be inserted into the database in pairs? And if the combination is not paired then it should not...

this might be of help:

http://sqlserverpedia.com/blog/sql-server-management/my-reporting-services-chunkdata-table-is-huge-how-can-i-manually-delete-the-data/