Viewing 15 posts - 5,941 through 5,955 (of 9,725 total)
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...
May 24, 2011 at 10:56 am
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...
May 24, 2011 at 10:30 am
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...
May 24, 2011 at 10:20 am
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...
May 24, 2011 at 9:04 am
Oh, Howard, that's good info. Thanks for the link! (not the OP @=)
May 24, 2011 at 9:02 am
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:
--...
May 24, 2011 at 8:59 am
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...
May 24, 2011 at 8:55 am
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...
May 24, 2011 at 8:51 am
WayneS (5/24/2011)
What's up with all the old threads being resurrected lately? I've seen several this week already... 🙁
Are they "Did you ever find a solution" resurrections, spam resurrections, or "hey,...
May 24, 2011 at 8:48 am
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
A word or...
May 24, 2011 at 8:26 am
Stefan Krzywicki (5/24/2011)
LutzM (5/23/2011)
May 24, 2011 at 7:56 am
GilaMonster (5/23/2011)
May 23, 2011 at 12:29 pm
Tara,
I don't think Litespeed uses the SQL Server extended procs. I'm pretty sure they built their own.
May 23, 2011 at 4:48 am
LutzM (5/18/2011)
GSquared (5/18/2011)
I put in the non-repeat bit because of the way Steve wrote his original Where clause. I just moved it into the Joins.
Gus: If this concept is...
May 18, 2011 at 12:49 pm
I don't see what's wrong with allowing matching since the question was "all possible combinations". <- EDIT: I believe it was the original question in the thread Steve referenced.
However, if...
May 18, 2011 at 12:36 pm
Viewing 15 posts - 5,941 through 5,955 (of 9,725 total)