Natasreeni - I've got the same problem. Please read

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=10084&FORUM_ID=5&CAT_ID=1&Topic_Title=Error+during+upgrade+from+6%2E5+to+2000&Forum_Title=Administration

Initially, it looked like an upgrade problem which is why I posted in the Administration forum but it seems it...

Thanks for the reply. There are no spaces in any directory names so I dont think thats the problem.

The upgrade worked fine on 2 test servers. It is now failing...

Antares - you are usually the font of all knowledge but not on this occasion. Read BOL 'Upgrading Databases from SQL Server 6.5 (Upgrade Wizard)'

BTW - I've been searching round...

Have you considered a database in Standby mode ? This allows read-only access. Read "Using Standby Servers" in BOL.

I think you need to use sum not count

eg Select persid, sum(datediff(day,startdate,completiondate)) as dates from <table_name>

You might also need to group by persid

I'll explain.

Currently, the 2 server environment is running SQL6.5. On the database on the Primary server, there are regular tran. log dumps around the clock. These are loaded onto the...

The tables I'm looking at have non-clustered indexes only. I'm stuck with the design as its a bought in package.

Lgm - Thanks for the advice. I did have Profiler...

Thanks for the reply Brian.

What I am investigating is whether there are any performance gains from putting tables and indexes from an existing database into different filegroups. The database was...