HowardW (4/21/2010)

---

You absolutely must use a non-standard port if publishing a SQL Server to the internet and SQL Browser should always be disabled. I've no idea why you'd allow UDP...

Elliott W (4/20/2010)

---

I did a quick search to see if NT AUTHORITY\NetworkService would normally have enough rights to stop/start a service, but I didn't see any answers or anything pointing...

It's not a hole in functionality. Generally your network architechture would provide the security layer that you require. Provided the same thing in SQL Server would be redundant,...

Thanks. Seems a glaring hole in functionality though :/

I'll have to look at the firewall route for blocking the ranges, but then some clients connect from anywhere in the world...

I have a dedicated server at the ISP. The VNC I use to remote desktop to it stopped working. I just needed to restart the service.

My SQL Server Service is...

Thanks, I've tried the proxy account earlier, but it seems I need to restart the server for that to take effect. I could not access the server other than with...

Thanks Florian

I'm going to look at SSIS definately.

In the mean time, I've dropped 2 indexes I don't use at all (my ER tool created them autmatically).

Performance is now up from...

Florian Reischl (7/1/2009)

---

Just an extension to arun's fine approach. Use an OUTPUT statement to get the the handled IDs to INSERT the new data without joining the large destination table.

You...

I believe BatchSize's default is the entire bulk insert size by default? I insert 1000 records at a...

Thank you Arun

I forgot to remove the delete from BodyPos line. I've only had it there while trying to figure out why I get duplicate keys sometimes.

Is there a way...

Thanks, I can hold off any queries on the table until the insert is complete, but the rebuild of...

Not sure about ASP, but I know ADO Connections has a KeepConnection property. If it's false, it will drop the connection automatically if no datasets are open. Perhaps this is...

lol sorry more haste less speed. I meant Florian, with Peso's inputs 🙂

Thanks a million, she's purring like a kitten now for 3 days. No deadlocks, no duplicate jobs issued.

I decided to go with SSCommitted's simple implementation. Works a charm and fast.

My...

That's the problem, I might have 50 clients doing at least one...