Viewing 15 posts - 38,071 through 38,085 (of 39,456 total)
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...
February 7, 2002 at 10:24 am
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 ...
February 7, 2002 at 10:19 am
February 7, 2002 at 10:14 am
You can use your select statement as a derived table.
select
article
, armazem
, quant
, sum(total)
, type
from ( insert...
February 7, 2002 at 10:09 am
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....
February 7, 2002 at 10:03 am
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...
February 7, 2002 at 9:57 am
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"...
February 6, 2002 at 4:45 pm
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
February 6, 2002 at 3:51 pm
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...
February 6, 2002 at 3:46 pm
February 6, 2002 at 1:02 pm
February 6, 2002 at 1:01 pm
February 6, 2002 at 1:00 pm
Not sure you can make an http request. I think DTS is making a NETBIOS request usijng the file protocols. You could script IE to retrieve the file and then...
February 6, 2002 at 12:15 pm
I save ALL dts packages with a password to get around this. We use a standard password, not for security, but to avoid this bug.
Steve Jones
February 6, 2002 at 12:14 pm
Not sure if replication will work. You could easily setup a DTS package to do this.
Steve Jones
February 6, 2002 at 10:00 am
Viewing 15 posts - 38,071 through 38,085 (of 39,456 total)