You need a Corellated SubQuery for this.

Try this,

SELECT A.Dept_ID, A.Dept_Name, A.Date_Stamp

FROM Departments A

WHERE Date_Stamp IN (SELECT MAX(Date_Stamp)

FROM Departments B

WHERE A.DeptI_D = B.Dept_ID)

If you are trying to use Windows Authentication and have only logged into a workgroup, then that is what the problem is!

You need to get the workstation configured to join...

José Rotsaert,

Could you please educate me on how you granted your Domain users Windows group to the Browser & viewer roles on the Rport Server?

I'm having difficulty understanding Reporting Services...

You can't restore a SQL Server 2000 Database to a SQL Server 6.5 Server or vice versa.

You would have to look at copying Data and Objects via DTS.

Thanks Phil. I thought the same but I just wanted to check if anyone knew a trick or 2 with it.

The step that is failing, what does it do?

I have a similar process in one of my Databases here. You basically have to create a Table and record each users login time and logout time. Then you can...

Each Server requires a per processor license.

Try reinstalling on top of it.

Did you update the Index Statistics with a FULLSCAN? if not, try that.

Is there any chance you could try this on a test server?

I too have moved Transaction Logs but not on a Replicated Database, so it would be safer to try...

Are the SQL Server services started with a domain account?

Did you setup Snapshot replication with the default settings?

You should be able to just do a GROUP BY CUST_ADDRESS.STATE

Have you tried that?

You should be able to just do a GROUP BY CUST_ADDRESS.STATE

Have you tried that?

Triggers is what you need! Just rememeber to place the NOT FOR REPLICATION statement in the Triggers!