It would be funny if...

Oh... That's a good one too, Greg. Thanks.

By golly, Gus. You may have struck paydirt.

Lemme play with that scenario and I'll let you know if I need something else.

Thanks!

It's only a rabbit.

[edit: had to fix one word. I can't believe I got that quote wrong. :blush:]

retread

The reason I'm requesting business cases is because the example I have has the potential of violating business NDA. I'm looking for an example I can use publicly, which is...

Apparently a lot of states were under watches and warnings...

jcrawf02 (5/24/2011)

Not entirely sure, but I may have just provided the...

I'm probably going to get lynched for this one, but ... It is a valid scenario. Honest.

Thoughts?

http://www.sqlservercentral.com/Forums/Topic1114315-149-1.aspx

Encryption is a huge subject. The easiest way is to encrypt the media the data is stored on, as opposed to encrypting the data itself. I'm not even sure you...

Okay. I recommend you encrypt the data, though, before you transport it. If there's private information on that data, and someone steals it, you have a serious problem on your...

BCP is definitely the easiest option, given Steve's note on compatability.

But now I'm curious. If the servers are in different cities, and there's no internet / network connectivity, how do...

How often is this data exchange going to be taking place?

Are both servers SQL Server (or will they both be SQL 2005)?

How far away, physically, from each other are both...

Oh, Howard, that's good info. Thanks for the link! (not the OP @=)

Try running the text of the proc separately (creating the input variable as a "inline" variable and doing a SELECT on @retValue before the RETURN clause).

Here's the code from sp_helptext:

--...