Viewing 15 posts - 34,516 through 34,530 (of 39,726 total)
I don't think that you want [] around the filepath do you?
October 8, 2004 at 2:24 pm
I received this question with supporting documentation about an open case with MS. At the time I needed some questions and posted it
,...
October 8, 2004 at 12:26 pm
select sum( case when sub2 = 0 then sub1 else sub2 end)
from ...
October 8, 2004 at 12:23 pm
select max( dt) from mytable
where dt < (select max( dt) from mytable))
October 8, 2004 at 12:23 pm
I haven't worked with many systems at 8GB and none on W2K3, but I pinged a few people that might have. Which HP system is this?
October 8, 2004 at 9:23 am
Installing 6.5 on W2K requires some tweaking. Search MS.com for a kb article on this. As far as the restore, I'm not sure. I know there are issues if you...
October 8, 2004 at 9:21 am
Profiler is really the only good way of doing this. Be sure that if you remove stuff, you archive it so that if 6 months from now you find out...
October 7, 2004 at 9:31 am
Not sure. I suspect that the process isn't tolerant of the delay and doesn't fail out until the provider returns some sort of message that it's active. What provider are...
October 7, 2004 at 9:29 am
SQL Server has two types of liceneses, one for the server and one for the clients.
The "10" licenses you received should be for 10 clients. I believe SBS has a...
October 7, 2004 at 9:28 am
If these are all on one server, I think DTS or straight SQL might work well. It really depends on how complicated the transforms are. If it's straight table-table movement,...
October 7, 2004 at 9:25 am
I've corrected the question to be the correct method name. The answer stands as B, but I've awarded points back for people answering D.
October 6, 2004 at 3:42 pm
That's quite a description and no I don't get it either. I'm not sure there's an easier way, especially when there are left joins involved. I think you might do...
October 6, 2004 at 3:38 pm
On W2K and W2K3, there also are options for the OS to restart it. I belive in SQL2K, there's an option as well.
October 6, 2004 at 3:37 pm
yes, you will be current to the point of the diff.
October 6, 2004 at 3:35 pm
Viewing 15 posts - 34,516 through 34,530 (of 39,726 total)