Right click on the publications --> Properties --> Articles

Un-Check the article that you want to stop replicating.

SELECT * FROM [5K5_PatLevelData_September_2008-9_MST_20089_029] WHERE

[PatID(HospitalNumber)] in (

SELECT [PatID(HospitalNumber)]

FROM [5K5_PatLevelData_September_2008-9_MST_20089_029]

GROUP BY

[PatID(HospitalNumber)],

...

As stated above, the best approach would be to do this manually using ssis, I am not sure i would fully trust an automated tool to do...

Can you post some sample data and your table structure?

krayknot (11/6/2008)

---

Vivien Xing (11/6/2008)

---

There are many different ways including 3rd party tools to recover lost data nowadays. I am trying to collect all the possible solutions for these scenarios:

A.Table...

database mirroring is database specific so when you mirror your production database to your test server, this will create a mirror database that is in-recovery mode.

So you...

Is there any reason why you cannot deny these users delete rights? it would save you a lot of hassle.

here is my attempt without using PIVOT, there may be a better way to do this but this seems to work. It will fail if there are...

it doesnt work because you are putting three quotes around your variable (''') you do not need to do this, surround it in single quotes (') and...

It looks like you are missing out a step in your query, you are inserting a value into a variable then selecting from a table. Where is the...

It depends on your setting for ANSI_NULLS

is you set this to off

SET ANSI_NULLS off

then your code will return 'NULL is equal to 3041'

check out this microsoft link for a full...

crazyfig (11/5/2008)

---

Hi,

Thanks for the feedback, but thats part of the issue Im having in a way. I would have to go through each table and field name, to link them....

If you already have a primary key then what is the need for the Identity column?

if is for display purposes only , you could use ROW_NUMBER() and generate a sequence...

A loop is not the best way to do this, the best way would be to use a join between the two tables based upon a primary key...

try this code to get the current user

SELECT SUSER_SNAME()