Isn't it great when you can solve your own issues? Awesome job and thanks for posting the resolution!

It only shrinks it to its original file size. I need it way smaller than that.

Alrighty! Thanks again!

Does not start in single user mode. Do I need to put the system databases in original location?

No they are not in default locations. Let me try single user mode.

That KB article it mentions says something about the file name SQLServer2005-KB936252-x86-ENU.exe. But no fix.

I tried re-running and it did not work. I found this in the hotfix log

04/01/2008 14:46:37.109 Warning: Product HotFixNS is missing LCID value

Also this in the app events

Event Type:Error

Event Source:MSSQL$servername

Event...

Alright! Let me try this! Thank you!

All of the above has been done. I'm trying to get the password for the group windows account verified. I'm hoping thats it....

I gave the developers windows group access to and also enabled it in SAC. still nothing.

Yes, they can. It is a development box and I gave it to them via their credentials. That is why I dont understand why they cant execute cmd shells.

I have one of the network guys looking into a password for this account, however i find it weird that they can see legacy dts packages and schedule and run...

ok. I'll have to talk to whoever setup this account. They just all log in with their individual windows account and have access.

thanks!

Any password? I used a group windows authenticated account. all developers can access everything via this account rather than being individually assigned security. Less maintenance.

Yes, however it is a windows user id and i did not enter a password. Is that incorrect?