It's trivial to get the plaintext versions of encrypted stored procs as long as you have sysadmin privileges - if your client wants to decrypt them they will. To be...

No problems Alex,

From your description you have a set of data being posted along with an HMAC-SHA1 of that data, and your receiving system needs to validate that post by...

Salts are commonly used in two ways:

- When encrypting data using a key-based algorithm (Blowfish, TripleDES, AES, etc.) - you typically append the salt to the key/passphrase during encryption to...

You may find it faster to use a CLR function (search for Matt Miller's posts here for more info) that wraps a dotNET RegEx object to match your keyword string....

Why would you salt Base64 encoded data? Base64 is a reversible transformation, not encryption.

The article show how to use a 3rd party Blowfish function to encrypt your data with a...

Do the procedures in question take input parameters that can vary widely in value, such as a date range? And if so, do the "bad execution" cases happen to have...

Do you mean server when you say "database"? Eg are you referring to two seperate SQL Server instances?

Regards,

Jacob

Heather - even though you can reference a linked server from a local query and have it produce results that are logically the same as if the remote table was...

Create a stored proc on the remote server that encapsulates your logic, and execute it from the local server. You should be able to use your locking hints in it...

Nice - just ran a quick comparison (dual Xeon 2.8, 6GB RAM, SQL Server 2005 Ent. SP2) - your method vs Alex Kozac's original (http://msdn.microsoft.com/en-us/library/aa175780.aspx) vs Goce Smilevski's UDF-based improvement...

Jeff Moden (8/5/2008)

---

...For example, the fastest "missing sequence" code I've ever seen uses a couple of correlated sub-queries which is a form of RBAR... but the constraints it used make...

eerkan - I don't think your solution will give what the OP wanted. It'll collapse all duplicated rows into a single row, whereas the OP wanted to retain all dupes...

Jeff Moden (8/1/2008)

---

It depends... if you're not going to do anything to the values other than add or subtract... no problems. If you're going to do anything else (like...

A service is just a program in an ISM wrapper - there is no special port registry for services, they are like any other apps. To know what port a...

Happy to help 🙂

Your idea wasn't stupid - just not suitable to your specific task. If your process was tolerant of a collision scenario and could deal with it...