Viewing 15 posts - 13,261 through 13,275 (of 26,486 total)
Sounds more like an issue with their application than a problem with the sql native client to me. However, you might be better off following their recommendation for their...
April 3, 2012 at 5:23 am
Conficker (4/3/2012)
Lynn,Just different way to write a code, if both works then nothing to complain:-D
Resources used. Your code has to create a temporary table, populate it using a loop using...
April 3, 2012 at 5:19 am
dwain.c (4/2/2012)
To ensure order you need an ORDER BY clause.
How about this case?
DECLARE @n TABLE (n INT)
INSERT @n (n)
SELECT 5
UNION ALL SELECT 1
UNION ALL SELECT 4
UNION ALL SELECT 2
UNION ALL...
April 2, 2012 at 10:20 pm
Evil Kraig F (4/2/2012)
Steve, looks like you'll be coming to SQLSaturday in Phoenix. It will be a pleasure to meet you. Looking forward to it more now. 🙂
Too...
April 2, 2012 at 6:42 pm
please read and follow the instructions in the first article I reference below in my signature block regarding asking for help. It will walk you through what you need...
April 2, 2012 at 4:35 pm
Welsh Corgi (4/2/2012)
SQLKnowItAll (4/2/2012)
In my neverending search for knowledge... I found this article. Welsh, does this help at all?
I had found another article similar to this.
I got an error...
April 2, 2012 at 4:31 pm
SQLRNNR (4/2/2012)
Here is the matrix listing the supported upgrades for SQL 2008.
Where is the matrix? And I'm not talking about the movie(s). 😛
April 2, 2012 at 3:25 pm
I would be curious the value for is_broker_enabled in sys.databases for this database.
April 2, 2012 at 3:22 pm
With nothing to use for testing, here is a shot in the dark:
create function [dbo].[itvf_GetGeoDistance] (
@inLon1 float,
@inLat1 float,
@inLon2...
April 2, 2012 at 3:19 pm
Lowell (4/2/2012)
Lynn Pettis (4/2/2012)
What has me slightly confused is you talk about using Database Mail, but the code you show is using...
April 2, 2012 at 2:48 pm
SSIS shouldn't have anything to do with Database Mail.
What has me slightly confused is you talk about using Database Mail, but the code you show is using CDONTS. I...
April 2, 2012 at 2:43 pm
sqlserver8650 (4/2/2012)
Hi All,Thanks for giving the replay
Is there any chance to get order with out order by clause
No. To ensure order you need an ORDER BY clause.
April 2, 2012 at 1:54 pm
And to ensure order by the id column, you need to include an ORDER BY id in your query.
April 2, 2012 at 1:20 pm
GilaMonster (4/2/2012)
Evil Kraig F (3/30/2012)
GilaMonster (3/30/2012)
Initial gut feel - improper transaction management (leaves transactions open) combined with connection pooling....
April 2, 2012 at 1:18 pm
GilaMonster (4/2/2012)
Lynn Pettis (4/2/2012)
April 2, 2012 at 1:08 pm
Viewing 15 posts - 13,261 through 13,275 (of 26,486 total)