But surely merge is two way. Or can we do this one way?

I do not want the webserver SQL box to have the data from the main SQL box....

Thanks guys.

Not sure how storing in a separate table will help.

Frequency of transactions: 10 a day

Frequency of insertions: Same 10 a day

Connection at the main server end is currently a...

But i have nothing in the DTS package referencing SA (it runs ok when you trigger it manually) - and i have actually scripted the scheduled task, and searched for...

Thanks mate.... you really put effort onto that.  Wish i could mark the post as useful for others

Odd how that works really.

Thanks for...

Brent,

Not really applicable i think - as i am running the code on the same PC, so the same Dll.

Dan

All,

Just to confirm (as the same thing is has been asked on other forums i have posted on (not SQLsc)).

I have taken a backup from our main DB this morning...

Sorry - and to confirm.

The datagrid is bound to a table.  There is a routine which calculates values - and sticks them in this table/grid.

If the routine is run a second...

Thanks....

But the data is indenticle in both grids (both DBs).

I am 99.99999% sure that its not the data thats the problem.

NO COUNT OFF --> NOT COUNT NOT --> NOT NOT Count() --> Count() --> Counting takes up more resources.

Thanks for the attempt - it now makes less sense though.  I...

Got to be honest i am slightly confused here.

The graph and the text below seem to state that turning it OFF will slow the response, yet then it says the...

So what would happen if i had a table with Varchars in which look like ID`s, and changed em to UnqiueID?

But when i create a GUID it defaults to 16 char.  The GUID that was created (as yours is) is 36 chars.  It wont fit?

D

We are currently using pesimistic locking....  will this help as there will still surely be instances that 2 people in different locations can open the same one till they sync.

If...

Sorry i didnt explain myself well

Current DB below

Non guid                                                       col1                          

------------------------------------          ------------------------------

C7AFE883-23AA-4546-B726-00F432BAAED4   Kalis

DDCF5D85-DF50-4282-9220-D47FF03F18CF   Frank

Now my question is after the moving of the data, if i specify that the GUID field must be...