Viewing 15 posts - 1,516 through 1,530 (of 1,790 total)
Had this problem during the Beta. You have a service which is running on the server leaving a connection to SQL Server open. Once you stop that service / close...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 22, 2003 at 2:38 pm
I actually think that is an overestimate. I haven't done an upgrade in a while (tomorrow I will be) but when I have, it doesn't seem to have taken that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 16, 2003 at 3:26 pm
Check out MS TechNet Article 298801 or go to http://support.microsoft.com/default.aspx?scid=kb;en-us;298801
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 23, 2002 at 8:36 am
My experiences have been similar to yours, all good. I have not had to call but a couple of times and the support they provided was excellent. In one of...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2002 at 8:11 pm
A solution might look something like what is given below. Not knowing your data makes it pretty hard to be sure if this is correct but from some test data...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 19, 2002 at 3:56 pm
Check out MS Article 304261 or use the link below.
http://support.microsoft.com/default.aspx?scid=kb;en-us;304261
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 17, 2002 at 10:25 am
My suggestion - Pick two areas that are going to be the focus for giveaways each month. From those two areas pick the BEST post and award the prize to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 12, 2002 at 3:05 pm
Sorry, didn't read fully. You will first need to know the difference between your time and Greenwich Mean Time. EST is -5. Once you have that you can compare using...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 12, 2002 at 11:34 am
It appears that all the date functions are referencing what the server setting is for Time Zone.
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 12, 2002 at 10:09 am
Andy - Good article on a topic most people don't think is important.
I have to agree with steven_white40 "If the users have access to multiple databases on the same...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 10, 2002 at 8:48 am
raino -- I would be interested in hearing about the performance issues on the SAN solution. We are in the process of migrating to an EMC SAN and I would...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 22, 2002 at 10:39 am
I hate tooting my own horn but I have a script posted here that does just what is being described that works great for me. Hope it helps here as...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 14, 2002 at 11:47 am
Something like this should work....
select
count(distinct(a.SSN))
from SSCWork4 a
where
StatusID = 50
and ID > (
select max(b.ID)
from SSCWork4 b
where
StatusID = 40
and b.SSN = a.SSN)
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 19, 2002 at 10:56 am
We use the Dynamic Properties Task within DTS to point the "Text File Source" connection to the filename we are looking for. Our situation allows for this as we have...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 19, 2002 at 2:41 pm
1) Download software that would probably save me a ton of time but I never have time to test or justify to managment.
2) Surf - www (specifically http://www.sqlservercentral.com)
3) Walk around...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 9, 2002 at 2:10 pm
Viewing 15 posts - 1,516 through 1,530 (of 1,790 total)