The steps to follow are

Please test the follwoing in a non production environment before doing it for real.

1, backup the database on server 1

2, Copy the backup file onto server...

Thanks for the replies, looking at the underlying data there is a fundamental flaw in the logic being applied. I think I will have to pass this one back...

Good suggestions, but column1 may contain

1005

10054603700000

10055

10055000100000

10055000200000

10055000300000

etc

So a search for 1005 could return multiple records rather than just the one, all rather frustrating, it would have been nice if the data...

I have managed to get the informatio I need by using

select

u.username

,case

c.type

when 1 then 'Folder'

when 2 then 'Report'

when 3 then 'Graphic/Data'

when 4 then 'Linked Report'

when 5 then 'Data...

Thanks for the reply, I think that maybe I did not explain what I am trying to achieve very clearly.

Within reporting services we have a suite of reports, these are...

Many thanks

Many thanks for the prompt reply

Thank you for the suggestions, I'll try the paralellism and apply the hotfix. The server is going to get a reboot this evening as well.

I'm happy to give this a try, but am unsure of the effects of setting the max degree of parallelism configuration value to 1.

Hi,

AWE is not enabled

SQL2000-KB916287-v8.00.2187 has not been applied

As requested

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)

May 3 2005 23:18:38

Copyright (c) 1988-2003 Microsoft Corporation

Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

Thanks for the reply, the server is on SQL sp 4

The file looks like a complete dogs dinner, seems like a mixture of comma, tab and pipe delimited with an apparent header row in a different format pasted in for...

Many thanks for the replies, this will be on a development server so I think we'll give it a go.