Only the Admins have access to the cubes but they should have access to different cubes at different levels.

How does you set individual access with Roles on cubes? I've read...

Yeah, we're using that over here too. I was just curious about other options.

Thanks!

Donalith

Absolutely. Complete loss.

No luck on that, Gail.

I can't even access the schema. I get an error of:

Could not continue scan with NOLOCK due to data movement.

sigh.. gonna take a long time to rebuild but lesson learned.

Thanks, Gail.

woohoo.. I got it down to THESE errors

Msg 5028, Level 16, State 4, Line 15

The system could not activate enough of the database to rebuild the log.

DBCC results for 'database'.

CHECKDB...

Gail, followed your steps to the letter..

created a database NOT the same size as I don't have a spare 600 gigs on the drive at the moment.

deleted the files

swapped in...

Thanks, Gail. I'm reading up on it now.

I tried re-attaching without the log file so that it would generate a new logfile but I get the same error "The log scan number.....is not valid."

I'll take a look at the link, Bob, thanks. This is on a production server that crashed when the raid controller blew up and not VMWare either..

Basically the worst of...

Apparently you can hit a couch database with the http connection manager in SSIS and at the same time hit an xml view from couch in order to import so...

Ok. I just wondered if I would be able to save any cpu cycles by storing it as an int since SS2008 stores it internally as an int.

Though now...

Both. Is there functionally an speed difference between the two indexes and/or is there a significant size difference?

Donalith

Thank you, that's what I thought but it's best to check when in doubt.

Awesome, thanks! This will definitely give me a good place to start then.

Donalith