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...

Sean Lange (1/14/2014)

---

Here is a true story from the field that a buddy of mine shared with me yesterday.

Or...

Ahh, Putty. I have that in mind whenever...

Fair enough. I've edited it to say T-SQL Backup command.

I'll award back points since this one was iffy.

EdVassie (1/14/2014)

---

A sabbatical is about taking time out of your normal routine to do something productive that you could not normally do.

I think you are starting well, putting...

There's a strategy, but it isn't backup and...