I was testing using the Alter...rebuild, since the DBCC REINDEX is falling out of favor these days.

That probably bears confirmation. Should be easy to verify with a small table/index.

Accessing VBA or VS automation for Office tools would give you the ability to cycle through the "tabledefs" collection in the Access file, or the table names as defined in...

Adam -

From testing I performed a while ago, issuing the rebuild with no specified fillfactor will rebuild using the latest specified Fillfactor.

Meaning - each time you specify a...

As long as the LUN's are PHYSICAL LUN's and not virtual/shared LUN's (meaning - based on different disks and controllers, not just a partitioned version of the same disk set),...

yusuf (2/28/2008)

---

I know I can dump the one record into a table. To do that I...

Try putting a ; at the end of the USE statement.

Meaning -

... Use [crime2]; ...

You should be able to locate this through profiler. You definitely need to get to the bottom of what's doing that. since it's an ongoing problem - I'm...

Brandie Tarvin (2/29/2008)

---

Matt,

You actually have a separate DB to do the scrubbing?

Hmmm. I didn't think about that idea. Originally I was going to use staging tables in the...

Start here:

http://msdn2.microsoft.com/en-us/library/ms130214.aspx

The lack of communication kind of makes it sound like there's a 2-sided problem. The Server Administration should should in fact have the ability to back up just about...

then perhaps just try dropping and re-adding an identity column. All of the numbers will regenerate.

Not at all - t'is true. I do okay - but there are lots here who can run circles around me day in and day out.

's okay...

Not an issue - welcome to the boards!

Let us know if you get stuck. Lots of highly competent folks on here, much more so than I.

Assuming your split function returns a table - I do believe so. Looks legit to me.

Jack's solution will work well if there's no chance to have duplicate test records. If there's a possibility that a user have dupes tests, then perhaps adding DISTINCT will...