ÅG configured. As per app requirement , secondary replica is in asyn mode.

Can anyone of you suggest me. ??

Thanks for your reply.

As per application requirement its in asyn mode.

Hi Lowell,

Using DDL Trigger script , I deployed in Sql 2008 server and found few DDL events not capturing.

Example:- TestA SQL server login I created and grant SA permissions ,...

Thank you for your support Lowell.

In SQL 2008 it is working fine . Seems tobe some issue in SQL 2005. I will look into this & let you...

Thanks for your support Lowell.

I executed your script and tested. I found few issues and I have attached, can you please check. I am using SQL Server 2005.

thanks in...

Hi,

Below is the example code for DDL server level Trigger

declare @data xml,

@CommandText varchar(max)

set

In SP , we have implemented below events :-

...

Thanks for the information.

We are using only Server level audit trigger.

For example :- I created the login on one server and later drop the same login. Now I want to...

Hi, I got requirement to move all indexes from primary to new filegroups.

Is there any challange will face while moving cluster index to new filegroups.

Hi All,

I got the solution in this site itself.

Pls find the code:-

/*************************************************************

Script made by : Lester A. Policarpio

Email Address : lpolicarpio2001@yahoo.com

Date Created : September 03, 2007

--=UPDATES=--

January 17, 2008

- Solved...

Other than replication;is there any way to do as per my doubt...

can you please suggest

HI, please find the profiler screen shot and advice

i have traced the same thing in profiler it is showing queries which is takes > 2 sec.

i have tunned through DTA but performance wise same thing it is showing...

yes ,backup has been scheduled at 11 clock morning at it'll be completed with 20 mins, other than nothing is scheduled.