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:

--...

I would agree with Suresh. I have never seen a place where you can track the changes made to a job over time.

However, you could set up logging that tracks...

DTS doesn't exist in SQL 2005 except as a legacy hook up. I do not recommend using this.

I'm not quite understanding your comment about no internet access. I'm not sure...

Are they "Did you ever find a solution" resurrections, spam resurrections, or "hey,...

I may be misunderstanding the CONTAINS predicate, but it seems to me that it searches for a whole word, not part of a word.

BOL

---

CONTAINS can search for:

A word or...

Stefan Krzywicki (5/24/2011)

---

LutzM (5/23/2011)

---

Regarding the specific situation: it might be better for the person in question to officially ask for support. Try to deal with the situation "undercover" would just...

GilaMonster (5/23/2011)

---

Just got a PM and a mail asking for some free consulting. I sympathise with people in tough situations, but that doesn't mean I'm willing to give telephonic support...

Tara,

I don't think Litespeed uses the SQL Server extended procs. I'm pretty sure they built their own.