Mark,

rowcount sysindexes says 3583.

Thanks.

Yes, I even disconnected and reconnected. .

Negative.

Hi Mark,

dbcc updateusage didn't resolve the issue.

Thanks, Brian

HI KB Kelly,

The local security policy doesn't revert back. The local service account still show having permissions to lock pages in memory. 

Thanks, Brian

Hi BL,

Thanks. I've been through that article and made the local policy changes as suggested, still no go.

It's frustrating to have that much ram sitting idle.

BPH

Hi Michelle,

Thank you. I saw those pieces earlier this morning, and ran the hot fix. Everything completed successfully, stopped and restarted just to make sure. Strange.

Brian

I read your stuff. It's good. And yes, that is some beautiful landscaping in the picture. A structure would be an improvement. But....good things take time. Editorials or House building? Editorials win...

Bob,

I'll take a look at those. I'm just getting use to this site and have found a lot of useful info, as well as friendly and helpful people.

Thanks.

Thanks to Junie01 and Goce Smilevksi. I will persue those avenues and try to figure this out. .

Hi Rajiv,

Your solution gets the horizontal look that I'm trying to achive.

The user did come with more info.

>>>There are many Collegeid.

>>>There are many deptid. 

>>>There are up to 900 regid....

Look at current activity. Determine who is still in the database and ask them to get out. Then proceed with the rename.

Bph