Steven Willis (5/26/2013)

---

I'm late to this party, but here's my entirely TSQL offering to remove duplicate spaces. Most of the code below has been not so shamelessly borrowed from Jeff...

Where/what is this iFunction?

What's the difference between CreateCsv8K2DimArrayRandomAlphaNumeric and CreateCsv8K2DimArrayRandomAlphaNumericWithSpaces?

When restoring a database from one SS instance to another there is two things I generally do from a script:

sp_changedbowner 'USERNAME'

sp_revokedbaccess 'USERNAME'

sp_grantdbaccess 'USERNAME'

These are needed in order to match the...

And what's the point of what you're saying in your binary signature?

paul.knibbs (3/6/2013)

---

There's no reason...

OK, getting it to work on 64bit.

Already found 2 of the 4.

It's estimating 4 hours for the remaining.

Very neat tool!

Geoff,

Did the following:

C:\tmp5\hashcat-0.42>hashcat-cli32.exe -a 3 --pw-min=4 --pw-max=12 -m 131 -p : -o "C:\tmp5\hashcat-0.42/SQL_passwords.txt" --output-format=0 -n 2 "C:\tmp5\hashcat-0.42/Hashes.txt" -1 ?l?u?d?s ?1?1?1?1?1?1?1?1?1?1?1?1

Initializing hashcat v0.42 by atom with 2 threads and 32mb segment-size...

Added...

larry.shanahan (2/28/2013)

---

Dohan has it correct: The UPC algorithm is that the check digit is the number that needs to be *added* to the weighted sums to equal the next...

hakim.ali (2/28/2013)

---

Michael Meierruth (2/28/2013)

---

In the algorithm for calculating the check digit, you have k = X mod 10. If k = 0 all is fine. Otherwise do 10-k. What do...

In the algorithm for calculating the check digit, you have k = X mod 10. If k = 0 all is fine. Otherwise do 10-k. What do you think is...

This approach was published in a solution quite early in this discussion.

Have a look at this:

http://www.sqlservercentral.com/Forums/Topic409505-690-1.aspx

Is the sql server instance located on the same computer where you are running SSMS to do the backup?

If yes, then it should be straight forward using the backup dialog...

Lynn,

I see you too have run into this 'x.x.x...' problem.

I have run into serveral end user applications where this was used to manage hierarchies. Of course, all 'order by' clauses...

Quite some time ago I implemented three processes in SQL. The first one was CPU intenstive, the second was I/O intensive and the third one was Network intensive. I actually...