Viewing 15 posts - 34,591 through 34,605 (of 39,793 total)
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
the cursor us built in underlying rows and it's entirely possible that a row gets deleted while you are working with it. If that's a possibility, then you should test...
October 6, 2004 at 3:33 pm
I believe that SQL Server will use separate threads for each file, but in most warehouses, a few files get most of the activity, so it's not likely that you'll...
October 5, 2004 at 7:33 am
There isn't a way. I've written jobs that ran every 5 minutes and killed things. If you look at sp_who2, there is a last_batch column, which is the last time...
October 5, 2004 at 7:21 am
I thnk you are probably ok with leaving it until you can reboot. I've had DTS jobs that I've killed from DTS as well as SQL and just let them...
October 4, 2004 at 6:21 pm
There are places where KILL will not interrupt the process. So if it takes a few minutes, be aware that it might be finishing something before it stops the backup.
October 4, 2004 at 1:36 pm
The above advice is the best way. I've written a few articles on auditing SQL Server and this is what I typically do.
October 4, 2004 at 1:30 pm
If KILL won't do it, and I'd be sure to run it a few times, you have to restart the server.
October 4, 2004 at 1:29 pm
netimpress.com. Brian Kelley has a performance tuning book. You can also search performance here. I'd go big in your case, maybe even contact MS and ask them for some help....
October 4, 2004 at 1:27 pm
Viewing 15 posts - 34,591 through 34,605 (of 39,793 total)