I am really sorry for not responding to the questions. Actually the issue has been resolved. Thanks for all your help!!

Yes, we are not the same. I do'nt know how the other username got created as mh?? It should'nt have allowed to use mh...

Thanks, I will try and will let you know.

Thanks for the reply. Will there be any data loss by changing the data type? I am trying to prepare if

we need to do anything different so that there is...

No it's running fine, I need to know how I can find the report name? Thanks!

I need to copy the database every night on a scheduled basis. In this case, is it better to use SSIS and schedule it to run daily? If so, which...

Thanks!! It worked. 🙂

Thanks for your reply, I am going thru the script, actually I want to transfer the logins from sql 2000 to sql 2008, can I...

Can I follow the same article if I want to copy the logins from sql 2000 to sql 2008 server. Thanks!!

In addition to running the below queries:

Do we also need to configure the /3GB switch in the boot.ini file?

When do we enable AWE? before running these queries?

EXEC sp_configure 'show...

Do I need to change config.sys file under the bin folder? Thanks.

What do you mean by orphan users?

I agree with that,...

GilaMonster (11/22/2008)

---

Queries that work on 2000 but throw errors on 2005, either due to syntax that's now invalid or changes to the optimiser is the main one I've seen.

Another fun...

The advisor did'nt find any issues, I tested in our test environment, so far we did'nt have any issues. But just curious what challenges do we usually face during the...