Ok that's the statement. Where does it says that it will update the varibles following a certain order ?

We know that, so far, we have been able to force the...

AFAIR tempdb collation must match Default "SERVER" collation .

Read access on the subscriber ?

Can you explain abit more what you really want ?

Can you run?

UPDATE STATISTICS tblname WITH FULLSCAN,ALL

Bob Fazio (10/3/2007)

---

FROM BOL

SET @variable = column = expression sets the variable to the same value as the column. This differs from SET @variable = column, column = expression, which...

I have done that in the past and to be honest is not that bad .... 😀

Ah How much I have requested such feature .....

Sorry, currently there is no way 🙁 ...Use naming conventions to help yourself out a bit.

First places to look iare: SQL Error Log and then on Windows Event Log.

You should definitely consider upgrading to SP2 and hotfix update rollup 3.

If the service account is running under a "domain user" account you must grant permissions to that account on the destination share.

FILE state <> DATABASE state. your query returns FILE states not DATABASE states:

From BOL:

In SQL Server 2005, the state of a database file is maintained independently from the state of...

mastroine (10/2/2007)

---

SELECT opinion_id, site_name, site_benefits

FROM tblMyOpinions_SitesILike

WHERE positive_opinion = 1

AND site_ranking = 1

...

Just a little warning... you are using an undocumented behaviour and a SP could belly up your project. :hehe:

Other than that the use of variables in update statements have been...

instead...

First you should separate the insert from the update.

Second you should check for @@rowcount at the begining of the trigger

Third you should join also in the update trigger with the...

Another trick for the large import is to set the DB in BULK_LOGGED mode before the import and if possible run bcp/bulkinsert in parallel (if at all possible)

I am also...