Have you tried using the Import wizard from ssms?

Oh, so basically what offline here means is no one will be able to use the index while this operation is on going.  Ahh.  Well I've been testing on a...

Yeah, this one isn't very big I have bigger ones but for the most part they aren't very big that is why I haven't been too concerned but I do...

Here you go Aaron,

23 2009058193 1 1 CLUSTERED INDEX IN_ROW_DATA 2 0 83.3333333333333 6 1 6 NULL NULL NULL NULL NULL NULL NULL NULL

Yeah, I've tried t-sql too but no difference.  I did try saying ..REBUILD WITH (ONLINE = ON), but it came back saying I need to be running the enterprise edition. ...

Access is a pain.  Many of my users access the db via Access so sometimes I have to go in and figure this out then I forget it again.

What version...

We are building forms (vb and access) to deal with normal users who need to edit data and for the most part this will do fine but for those users...

In properties of the users or role, select securables, then select "Specific Objects" or "All objects of types...", select stored procedures, then select the sp you want them to be...

Also, you may encounter version problems if you don't have sp1 on the the server that your backup came from.

Did you double check surface area configuration to insure that no other services are running?

Be careful about removing BUILTIN\Administrators  because when I did this I wasn't able to use the Surface Configuration Utility. 

I removed then re-install SSMS and now it works perfectly.

Great idea Raymond, thanks.

Thanks, I'll try that.

It appears that I am unable to perform this option running SSMS remotely, but using SSMS on the server works fine.  Is this a limitation of SSMS or just a...