Still haven't had much luck finding the answer to this.

Thanks

Thanks Howard.

Yeah I just realized that a big ago that in regards to your first comment.

You were correct, it was set to DontSaveSensitive. Changed and appears to be operable.

Thank you...

Interesting ... after reading this: http://social.technet.microsoft.com/Forums/en/winserverMigration/thread/84626fc0-b36b-4775-acf7-678fd6ea60dc

I recreated the 32bit and 64bit alias and now it works ...

Many updates have happened to these objects ... while our documentation is still rather poor, visit the site in my signature if you want to review these objects and many...

Shawn Melton (4/28/2011)

---

We cycle the error logs in SQL frequently so I don't show logs back...

Shawn Melton (4/28/2011)

---

Well considering that is an undocumented stored procedure I doubt you are going to get much help by putting a Connect item out there.

I checked a SQL...

Bumping this thread as this is something I'm looking to implement as well.

Yeah that's where I'm at now ... was just looking for an easy way out!

Unless I'm missing something, you can't do a repair in express can you?

However, I went forth with doing a fresh install and let it default to \SQLEXPRESS. I then tried...

Hi Chris,

I do not see a template.ini anywhere, so I did a quick search and the syntax appears to be: sqlexpr.exe /qb REMOVE=ALL INSTANCENAME=<InstanceName>

I ran through that, and it appeared...

Create your procedure in the master db, and run this:

EXEC [master].[sys].[sp_procoption] 'schemaname.objectname', 'startup', 'true'

To verify...

zaubut (11/30/2010)

---

Sounds like a lot of work,,, given i understand why it is necessary.

Sadly the servers i need to fix are in a remote co-location facility. They run our...

Sorry for the delayed response, I actually haven't even gone back and worked on this due to multiple other clustering issues I've been working on. Here was my latest response...

I'm opening a ticket with Microsoft now ... while I could easily rebuild this instance, I have 5 others on the cluster that I am now worried about. I realize...

I found a similar thread for 2008 ... that according to Microsoft, has been resolved with SP2 ... what about R2 though? http://www.sqlservercentral.com/Forums/Topic772839-146-1.aspx

I'm opening a ticket with Microsoft now.