Hi Roshan,

This works perfectly for me. thanks for the help.

i'm trying to make it as report and send to me by email daily in xls format. pls let me know...

oscar.spicewood (2/29/2016)

---

Jack,

When a merge replication is enabled on tables, There are some triggers created on tables ., such as ms_merge......, you can see under the triggers of merge replication...

oscar.spicewood (2/29/2016)

---

Hi,

Please send additional information ,

From T to X , what time the data is being replicated ?

Are you using transactional replication from T to X?or Are you...

Hi Alan,

Thanks for your reply. i will test these scripts.

Moreover, i would also like to know how to determine or capture this high IO/CPU queries if they run again. so...

they are expecting to see how...

[/quote]

There are lots of ways to perform this action , the simplest one i think is:

create a job and set its schedule as per the required timings, and merge the...

stephen.christie (2/3/2009)

---

Hi,

You can use option 2 where you create a SSIS package and populate a table.

Create the table with the information you request then add a new column on...

Jeff Moden (10/31/2008)

---

jack_hc (10/30/2008)

---

Hi,

I am facing a problem to extract data from a table, the table contains over 41k records, and some of them(>5k) share same column value, now what...

PaulB (10/31/2008)

---

Yes. There are probably more than a couple of ways of doing it, let me share with you the good-n-old pivot table way; not doing your job but here...

Is there any workaround for this issue? I see the exactly same issue in my enviroment

Hi

Customers using SQL Server Standard Edition must fully license each instance server (whether in per-seat or per-processor mode).

is this also apply to sql2005 std version?

Thanks,

Jack

Thanks again everyone!

Thanks Steve's comment, this is exact what i needed, i went through the instruction, it is very straightforward, the only concern i have is it needs a reboot.

Alternatively, i am...

Hi, Mat,

very appreciate you can send me your plan, because i am currently work on it also, thanks.

jack_hc@hotmail.com

not found for win2003, but you may take a look at this in win2000, hopefully help for you:http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp