Viewing 15 posts - 38,371 through 38,385 (of 39,754 total)
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
February 5, 2002 at 3:38 pm
February 5, 2002 at 3:36 pm
Viewing 15 posts - 38,371 through 38,385 (of 39,754 total)