December 12, 2005 at 6:50 am
I mean change the app of the program runnign and makins the queries in the co-worker's computers?
December 12, 2005 at 7:26 am
It depends... if the application can use a file DSN, yes you can. There you can edit the file containing the connection information. However, if the application reads only a couple of entries (whether from a configuration file or from the registry) and then builds the connection string on its own, likely not. It completely depends on the application.
K. Brian Kelley
@kbriankelley
December 14, 2005 at 11:41 am
HI,
Today we got a big problem in some tables from the DB, someone delete info of one of those, how can i know who made that or maybe when, from the different sys... tables in sql
Can i do that, please help!!
December 15, 2005 at 3:56 am
You'll want to post this as a different topic. However, did you have any tracing on (Profiler traces)? Do you have any log reading software (Log Explorer, Apex SQL Log)?
K. Brian Kelley
@kbriankelley
December 15, 2005 at 9:17 am
Why a different topic?
CREATE TABLE X5_AUDITORIA2 (
CEDULA DECIMAL (12, 0) NOT NULL ,
NUM_SOLICITUD decimal (2, 0) NOT NULL ,
COD_REGIMEN decimal (4, 0) NOT NULL ,
ESTADO DECIMAL (1, 0) NOT NULL,
N_ESTADO DECIMAL (1, 0) NOT NULL,
USUARIO VARCHAR(100) DEFAULT SUSER_SNAME(),
FECHA_AUDIT DATETIME DEFAULT GETDATE(),
HOST VARCHAR (50) DEFAULT HOST_NAME(),
APLICACION varchar(50) DEFAULT APP_NAME(),
TIPO CHAR(1) CHECK (TIPO='U' OR TIPO='D')
)
CREATE TRIGGER audita_update
ON X5_PENSIONADOS_SOLICITANTES FOR UPDATE AS
INSERT INTO X5_AUDITORIA2
SELECT
D.CEDULA,
D.NUM_SOLICITUD,
D.COD_REGIMEN,
D.ESTADO,
I.ESTADO,
SUSER_SNAME(),
GETDATE(),
HOST_NAME(),
APP_NAME(),
'U'
FROM DELETED D
INNER JOIN INSERTED I
ON D.CEDULA = I.CEDULA
AND
(D.ESTADO I.ESTADO)
If i have that trigger and that table, there is way to get the table and the field that the user is changing?
December 15, 2005 at 9:34 am
New thread because...
1) The problem is different from that in the original thread.
2) much wider audience - people usually read new posts whereas one that's been around for a few days will (usually) only be read by those that participated in it.
3) Even amongst the participants, some may have unsubscribed from this thread so your audience is reduced further!
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply