Viewing 15 posts - 5,941 through 5,955 (of 9,722 total)
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
Boys, you should be ashamed of yourselves. Jeff Moden gave us a better way.
DECLARE @MaxTally int;
SELECT @MaxTally = Max(ID) FROM dbo.Combinations;
SELECT c.ID, t.N AS TallyID
FROM dbo.Combinations c
CROSS JOIN dbo.Tally t
WHERE...
May 18, 2011 at 11:21 am
Steve,
I actually have a table in an analytics database where I had to set something like this up, but the numbers are so small that I just entered them into...
May 18, 2011 at 11:09 am
Ray K (5/18/2011)
bcsims 90437 (5/17/2011)
May 18, 2011 at 11:01 am
Viewing 15 posts - 5,941 through 5,955 (of 9,722 total)