Turns out that installing SP2 created two new resource files (mdf ldf) in their original locations. I shutdown the service and moved them to where they are supposed to...

what options do I have? I'm a little leary to just uninstall the instance?????????????

I did not make a copy of the files before attempting to apply the service pack if that is what you mean.. are you always supposed to make...

i did attempt sp2 after moving the files.

when you say 'move it back'? i don't know what you mean...

i ended up starting the instance in single user (netstart mssqlserver /f /t3608), opening SSMS, cancelling the connect dialog and then opening a new query window and issueing my alter...

I tried starting the Instance from a command prompt

sqlservr -c -m (minimal mode) so that I could restore model and msdb and it WILL NOT come up. ...

Thank you. That is the article i followed and i must have messed up somehow.

i can bring the instance up in single user mode but when I try...

Still can't seem to figure out how to restore my model and msdb databases?????

Thanks for your help. I was using the wrong install media I think. I popped in Disk 1 and it worked fine

Maybe you can help me too.. I did all this:

n SSMS select Database Mail under Management, right-click and Configure Database Mail. After that's complete send a...

all set. Thanks for your help

I attached my file.. see attached. I still can't get integration services to work

awesome.. thank you!!!

my correct INI.XML attached!!

SQL Server Browser service is running.

I restarted the SSI Server after changing the INI.XML file. ...

THANK YOU!!! As you can see I'm a total newbie with management studio.

I got that far now.. but the problem I'm having is that I am...

"Sleeping until external dump process completes" I guess is what I'm calling a sleeping condition..

anyway.. I contacted Microsoft and this Instance is a candidate for the post...