I re-complied but slowness still exists..

We are gonna try bouncing the server this weekend.

yeah it helps thank you..

okay so I followed your advise ...ran the execution plan on both prod and stage boxes..

On my prod box (query 4) I have a clustered index scan..cost of 81 percent

I...

the execution plans appear to be the same...

Thank you!

it is not on backorder?

anyone actually have a real dev edition?

It was permissions!

Thanks guys!

Good karma to you all..

yeah everythings the same I can see all the old DB's in the catalog

just not the new DB I just created.

I waited for the server to get out of recovery..which it did..

But when I expand on anything I get the "lockout time out period exceeded" error 1222

I tried changing the...

Thanks MAN!

how would i update this column?

update upb set upb = /100

so there's no way to move the decimal via precision/scale?

Thanks man

I chnaged some things now I'm getting a

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Thanks