Nice Article by the way  I would like to correct some comments in it though

>> A similar process is required for TV, but...

Have a look at TextCopy.exe under the MSSQL\Binn directory

have a look at:

IS_MEMBER ( { 'group' | 'role' } )

OK this is the revised  (and checked) version

Update table1

set value = t2.minval, status =t3.st

from table1 t1

 left join

       (select , min(value) minval

        from table2

        group by ) t2 on...

I haven't tested this but it should be pretty close to what you need:

Update t1

set value = t2.minval, status =t3.st

from table1 t1

 join

       (select key, min(value) minval

        from table2...

Can you post sample data and sample result.

Usually what you do is to compute how it is supposed to be and perform just one DML

You will probably have to re-register the server name if you didn't used (local) on EM but that is not a big deal (Besides That's the recommended way). QA is...

How do you call this ...?    "Self promotion"

If you want to pursue the SQL solution go the SQL Server Alert path they are very very powerful and can help you get where you want very easily (Every...

No you won't only need to

sp_dropserver 'old name'

sp_addserver 'new name', 'local'

For more:

http://www.sqlservercentral.com/columnists/bknight/renameserver.asp

hth

Mark and Tim,

I believe you HAVE TO read the Link posted by Frank. It is not about dynamic sql is dynamic search. In there you can find both options as...

I believe that marking them as NFR will do! I came across something similar when trying to perform bidirectional Trans. Repl. and the One of the triggers was misssing the...

David,

I am assuming that you are using Transactional replication. Do you need to update data at the subscriber? and if so what type of updaing are you using?

Are the Triggers...

Or

select c.CustomerID, n.Number as [Month], ay.y as [Year]

from (select Number from master..spt_values where type = 'P' and number between 1 and 12)n

      cross join (select distinct CustomerID from dtes) c

     ...

SHAPE { SELECT * FROM DT_PERSON  where exists (select * from DT_QUALIFICATION q where DT_PERSON.PersonID = q.Person_ID) }

APPEND({SELECT * FROM DT_QUALIFICATION} RELATE Person_ID TO Person_ID) AS ChildRS

Would something...