Activity overview
Latest activity by arthurblake
FYI:
He posted an "admin" link to the page (I think, accidently...)
The correct link for us users is: https://redgate.uservoice.com/forums/39 ... -says-unkn / comments
FYI:
He posted an "admin" link to the page (I think, accidently...)
The correct link for us users is:https://redgate.uservoice.com/forums/39 ... -says-unkn
mgordonzais
Yes, just click the little feedback link in the tool itself!
Or go here: http://redgate.uservoice.com/forums/390 ... ce-control / comments
mgordonzais
Yes, just click the little feedback link in the tool itself!
Or go here: http://redgate.uservoice.com/forums/390 ... ce-control
David Atkinson wrote: "Out of interest, what is the reason you are choosing a shared development environment over dedicated per-developer ones? "
We use a shared dev environment because the database is too large to replicate for all the developers (well over 500GB.)
Your question makes me wonder if the shared development model is not as well supported or implemented as the per-developer model...
Could you potentially use a db trigger to detect changes to the database?
Here's a sample trigger I wrote once to audit db changes to a table... CREATE TRIGGER [DDL_AuditTrigger]
ON DATABASE
FOR
CREATE_FUNCTION,ALTER_FUNCTION,DROP_FUNCTION,
CREATE_INDEX,ALTER_INDEX,DROP_INDEX,
CREATE_PROCEDURE,ALTER_PROCEDURE,DROP_PROCEDURE,
RENAME,
CREATE_TABLE,ALTER_TABLE,DROP_TABLE,
CREATE_TRIGGER,ALTER_TRIGGER,DROP_TRIGGER,
CREATE_VIEW,ALTER_VIEW,DROP_VIEW,
CREATE_XML_INDEX
AS
DECLARE @eventData xml;
DECLARE @time datetime,
@user varchar(50),
@object varchar(50),
@tsql varchar(max);
SET ARITHABORT ON
SELECT @eventData = EVENTDATA();
SELECT @user=@eventData.value('(/EVENT_INSTANCE/LoginName)[1]','varchar(50)'),
@time = @eventData.value('(/EVENT_INSTANCE/PostTime)[1]','datetime'),
@object= @eventData.value('(/EVENT_INSTANCE/SchemaName)[1]','varchar(50)')+'.'+@eventData.value('(/EVENT_INSTANCE/ObjectName)[1]','varchar(50)'),
@tsql = @eventData.value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','varchar(max)');
INSERT INTO dbo.DDL_Audit VALUES(@object,@user,@time,@tsql);
GO
DISABLE TRIGGER [DDL_AuditTrigger] ON DATABASE
GO
ENABLE TRIGGER [DDL_AuditTrigger] ON DATABASE
GO
/ comments
David Atkinson wrote: "Out of interest, what is the reason you are choosing a shared development environment over dedicated per-developer ones? "
We use a shared dev environment because the databas...