complete guess .. but perhaps you should not use isnull with sum. Maybe you could put the results of isnull in a variable instead and use sum that way.

ok charshman, but what if I have created the logins and run your sync script and then I want to restore the database again from the same source db. I...

cool.. Just a couple of questions about the migration

should I only have to transfer the logins once using this method because once the sids are in sync If I...

Hope you don't find my explanation too dry...

I am transfering a 2000 db to 2005. I haven't been given a test environment to work with. I am migrating by restore...

thanks for checking Andrew - I have done that

thanks guys - is there any issue setting the model back to simple again when it is in full recovery model?

Sorry Jack.. I don't understand because I believe the max memory is set to the default (2TBs) which that counter is not showing for any of those instances.

hehe.. you had me freakin out there for a minute - I'm glad Gail is right cos I would be in all sorts of trouble!

why is the max set so high as a default (2147483647 MB)? If I am getting paging problem would that be because this is too high?

ok maybe that was a silly question. I would like to try a 1 more.

can you replicate a read only subscriber?

hi Lenny,

I have been thinking about that too. Can I ask how does you database run with that, what type of hardware do you use?how big is you db (i.e...

Two questions

what the current patch level for sql server?

Can I patch 1 instance without effecting another instance - e.g. SP2 is saying SQL Browser is locked. I will need...

thanks Ken.. you helped me out heaps

Ok.. I will try to attack this from another viewpoint. My SQL server 2000 box say I am using Latin1_General_CI_AS server collation. I may be wrong but because this...

thanks. I think I have the right collation for my 2005 server - SQL_Latin1_General_CP437_CI_AS. SQL Server 2000 say Latin1_General_CI_AS though. Is this ok? What is the best way...