Brian, sounds like an article

Here I'm not sure I improved the SQL servers. I did upgrade from SQL 7 to 2000.

I also helped architect an inhouse...

Looks like this is not working in parallel. Perhaps there is some single threading behind the connections? Not sure.

Steve Jones

steve@dkranch.net

I've done something similar, but I include a datetime field in my sql staging. Then I track when the process runs and only work with rows that have a timestamp...

Let em add one more qualifier. If I had a good design tool, then I'd use that. At a former job, we had Er-Studio from Embarkadero and I did all...

This doesn't make sense? What does not work?

Assume server MAC is "AA" and you have clients with "BB" and "CC" as their MACs.

In sysprocesses, you will see:

SPID ...

perhaps. try formatnumber()

Steve Jones

steve@dkranch.net

You can use your select statement as a derived table.

select

article

, armazem

, quant

, sum(total)

, type

from ( insert...

You could implement a delete trigger to write this information to an audit table. However, keep in mind that the hostname is dependent on the client app to send it....

Since development and testing have the ability to have "untested" code, which could potentially peg the CPU, I'd avoid hacing them on the same server. I have seen queries that...

Sorry for your loss. I'm sure lots of little ASPs do this. We used Data Return and they provided great SQL backups ever hour.

This is one of those "buyer beware"...

short answer, laziness. Even for testing, it saves time in EM.

Personally, I have a template in QA that I use to outline a table and fill in columns.

Steve Jones

steve@dkranch.net

Not sure why you'd use multiple instances on a server. It sounds good for dekstops,but servers? why not different databases? I guess if you had a hard coded db name...

You can use a scripted FTP to do it if that is supported.

Steve Jones

steve@dkranch.net

8.xx

Steve Jones

steve@dkranch.net

That's what I'd do.

Steve Jones

steve@dkranch.net