This is my third attempt to reply. My postings keep getting lost. Sooo, I have decided to type it in Notepad and paste it.

To restore the current transaction log into...

Don't know anything about merge replication, sorry. But to change SQL server to run with a domain account :

In Enterprise Manager right click on the server

select Properties

on the Security tab...

It sounds like the database (mdf file) had increased in size just before the crash and the new disk clusters had either not been written to disk, or they were...

You can if you start the Profiler tool (in Enterprise Manager click on the tools menu option and select Profiler). This monitors what is going on in SQL server, but...

IF you haven't already, you can boost the priority of the SQLServer process on the server it is running on by:

right click on the server name in EM, and select...

I think you need:

insert into tblduplicatedata (dataid)

select dataid from tbldata d

left join tblduplicatedata dup on dup.dataid = d.dataid

inner join (select field1, field2, field3, min(dataid) as dataid

            from tbldata group...

You really need another table that links which parts are dependent on other parts being completed. But, using your assumption (if I understand it correctly) you need the following sql,...

I would recommend the suggestions above about running DTS only on the database server, but, for you information:

A DLL can call (depend on) many other DLLS and if any of...

The generic form of a query that has columns that refer to other column aliases is:

select *, (an_alias + an_alias) as an_alias2, (col2 * 2) as an_alias3

from

    (select (column1 * 2) as...

You don't say what version of Excel you are running, but if it is Office xp then excel is set to stop macros running by default when it is installed. This...

I had a similar problem as few days ago. Running on SQLServer 2k sp3, 4Gb Ram and 2 processors. System was hanging when SQLServer was using 1.7Gb of memory. I...

One way, if you want to do it in SQL would be:

    SELECT companyname, field2, field3

    FROM

    (select companyname, companyname as sortname, 1 as level, field2, field3

    from table1

    UNION all

    SELECT '' as...

It sounds like you need to make one of the servers a linked server on the other server. Then you can select information from both servers in the same select statments...

I am not familiar with the Navision database, but have you tried the simple things to try and bypass the reported problem?

Such as converting the problem fixed length field...

When you use 'select * sometable' to display the table the cr/lf show as 2 spaces even though they are stored in the table as CHAR(10) + CHAR(13). Open the...