Viewing 15 posts - 3,031 through 3,045 (of 7,429 total)
Where are you seeing this?
The message related to that is "Executing SQL directly; no cursor."
Edited by - antares686 on 05/07/2003 03:22:47 AM
May 7, 2003 at 3:22 am
Right DavidBurrows, I think we need more pieces to this puzzle. He stated all product combinations with 3 CROSS JOINS which actually gives far more than 8. All possible unique...
May 7, 2003 at 3:18 am
You know. Thinking about this now I realize, what are you wanting the result to be for the final output and how are you visioning getting it? I am not...
May 6, 2003 at 6:27 pm
Ok, I will throw this out for anyone who wants to try the 2nd half. I named my ProdName containing table prodx with the ProdName column as the only item....
May 6, 2003 at 4:05 pm
Not sure, I wouldn't think so, however my SQL 6.5 reference that came with 6.5 does not even mention and nor does 6.5 Unleashed so I cannot be sure without...
May 6, 2003 at 3:52 pm
Interesting. I have no idea, but I will keep my eyes peeled for anything I come across.
Oops just thought of something. I believe there was a utility patch you could...
May 6, 2003 at 3:25 pm
You may want to redownload the SP3 install or check the @@VERSION to be sure it didn't get done without you knowing. I have not heard this at all.
May 6, 2003 at 2:53 pm
I think you are looking for something a little more like this.
SELECT
WorkHistory.Unit,
MIN(workhistory.travelerid) as Traveler
FROM
WorkHistory
LEFT JOIN
unittype
ON
Workhistory.Unit = UnitType.[Description] OR
Workhistory.Unit = UnitType.fullDescription
WHERE
(UnitType.NotNullPKColumn IS NULL)
GROUP BY
WorkHistory.Unit
If in...
May 6, 2003 at 2:50 pm
It some rare cases it may be possible but whne the compiler parses the query it will weight the statistics for each idex related to items in the query and...
May 6, 2003 at 2:18 pm
Look at sp_change_users_login, you can fix much easier this way and is the same for 7 and 2000.
May 6, 2003 at 2:16 pm
I see now. I just tried using the MS example included with SQL Server install and found no way to hook the window directly.
May 6, 2003 at 10:56 am
Take a look here for additional help. http://support.microsoft.com/default.aspx?scid=kb;EN-US;q288577
May 6, 2003 at 4:18 am
Duplicate post, please keep messages in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=11920&FORUM_ID=7&CAT_ID=1&Topic_Title=Log+shipping+to+Two+backup+servers&Forum_Title=Replication
Moderator please lock or remove this post.
May 6, 2003 at 4:14 am
Have you tried truning logging on in your DTS packages to see if maybe you can find where they issue is occurring. Also, with the intermediary VB app I would...
May 6, 2003 at 4:11 am
Viewing 15 posts - 3,031 through 3,045 (of 7,429 total)