Tom Bakerman (1/15/2014)

---

Sorry Steve, but I disagree with you. I think it's a good thing that we are not craftspeople.

...

Thomas Abraham (1/15/2014)

---

We're just not, we're not craftspeople, at least not most of us. We do what we need to do at work. We get systems working just enough. We...

below86 (1/15/2014)

---

You get pulled into so many different projects with so little time it impossible to 'craft' the perfect solution. As they say 'A jack of many trades, master...

chrisn-585491 (1/15/2014)

---

You want craftsmanship and professionalism? Talk to my boss and convince him. Or better yet talk to our clients and ask them how much they want to pay.

Not...

Fixed and thanks

Thanks for the update.

Sounds like half-a** coding and an item for Connect.

Should be fixed. A minor code failure after a release yesterday fixed.

Bug logged

I guess I'm saying if I put the known password in there, the last value, it doesn't return what the value is in the system tables.

Is there some other salt...

Do you mean?

SELECT sl.name

, sp.type

, sl.sysadmin

, CAST(sl.password AS VARBINARY(384)) AS EntireSaltAndPasswordHash_HashcatFormat

, LOGINPROPERTY(sl.name,'PasswordHash') AS EntireSaltAndPasswordHashAnotherWay

, CAST(LEFT(RIGHT(sl.password,12),2) AS VARBINARY(32)) AS Salt

, HASHBYTES('SHA1', CONVERT(VARBINARY,N'computer') + CAST(LEFT(RIGHT(sl.password,12),2) AS VARBINARY(32))) AS HashBytesReconstructionOfPasswordHashFromAGivenPassword2005

, HASHBYTES('SHA2_512', CONVERT(VARBINARY,N'computer')...

Or use the file watcher to see if any process touches a log file.

Keith Tate (1/14/2014)

---

I'm not sure what is being asked now? There is no default password that I know of for every instance. I'm also not sure how strong the password...

Well, if Master Bob is stumped, how can we help?? :-P:w00t:

What about using something like the Process Monitor from Sysinternals to see if anything else launches after the tool reads...

We have build lists here as well: http://www.sqlservercentral.com/articles/Build+List/71065/

Basically I think you need custom scripts that run as part of your restore process to clean up the data before people use it. Essentially follow this:

- restore db

- set...