Thanks for the script can it be changed to show result in MB and GB also?

Can any one help or have seen this issue before ?

Thank you for reply I will try to change the job schedule and will update.

I don't have any error message. Please take a look at screen shot.

thanks

Sorry Sean & Tom ,

I will start a new thread with a details.

again sorry.

All ,

Thanks for your help.

This trigger is not going to work for me. I am trying to capture user name, data and couple of other thing when something is inserted,...

Thanks for reply ,

I am getting below error when I am trying to create the trigger.Only thing I changed is inserting output into a different database on same server. I...

Thank you for this DML trigger.

When I am running this trigger I am getting syntax error is there any thing I need to change in that trigger ?

Thanks for the reply ,

I have schema changes enabled but when I alter one of the view add one more column but it didn't reflect on the rep side....

my distribution database is only 16GB... but my prob database is 380GB in total...it don't happen every day its to random... by default it is set to run every 10...

Here are the steps to add article in publication without setting up whole replication again or running the whole snapshot again.

First Execute these two statements :-

To Get the publication Name:-

exec...

This is my uset.

CREATE LOGIN [testuser] WITH PASSWORD=N'ô8îlDùì+îí< ¥XÒ³#µë!©Eõý¬7>?', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

GO

ALTER LOGIN [testuser] DISABLE

GO

This is on database

USE [TraceDB]

GO

CREATE DATABASE AUDIT SPECIFICATION [Truncate_DeleteAudit]

FOR SERVER AUDIT [Truncate_DeleteAudit]

ADD (DELETE ON DATABASE::[TraceDB] BY [dbo])

WITH (STATE = ON)

GO

this on master database

USE [master]

GO

/****** Object: Audit [Truncate_DeleteAudit]...

Funny .... We are running network trace from yesterday and problem has not occurred.

Wonder WHY??? But right now its point to wards Networks.

will keep you posted.

Thanks for reply ,

We are going to set up a network trace tonight. Other thing I was thinking we have Transaction replication that is on 24 hours and SQL...