You could try and insert a tracer token to see what your latency is like, there may be network issues that are causing a problem

So you are moving the server that the access 2003 front-end is linked too?

when you move the access database to a new SQL server you will have to change the...

SanjayAttray (12/9/2008)

---

steveb (12/9/2008)

---

CURRENT_TIMESTAMP is ANSI code

GETDATE...

CURRENT_TIMESTAMP is ANSI code

GETDATE is not.

Like...

Alvin Ramard (12/9/2008)

---

Which one should you use?

Simple, look at both values and you'll see the difference. I guess the correct answer to your questions is that it depends what...

You really need to consider the size of your CMS and how many users you will be supporting on it. I would have a look at the higher-level business...

this part of the code

SELECT TotalCleared, CONVERT(char(10), ClearedDate, 101) AS ClearedDate

FROM CTE

GROUP BY...

SELECT top 10 * FROM [YourTable] Order by YourId Desc

It really depends on how your table is orderd, otherwise the results will not really mean anything

Open the file in a Hex Editor to check the commas are all there and that there are no hidden value codes causing havoc

If all your filenames are consistent then you should be able to use a combination of FINDSTRING to find the position of the last '_' and then use...

Go into File-Explorer and then delete them, but be absolutely sure you don't need them first.

Or Setup a maintanence plan to automaticaly delete the older backups based on file...

Do these values have quote identifiers (") around them in the flat file?

What are the constraints on the publishing table?

Did you re-build the merge replication after you changed the value of NOT FOR REPLICATION to On?

The constraints that merge replication add to the table may be causing this problem,...

For merge replication you need to have Not_For_Replication set to ON, this means that the value will not generate a new id when it is merged replicated.

It seems like...