Thanks 🙂

Hi Guys,

For testing purpose i have sql 2000 and sql 2005 installed on the same machine

I have created a sample database with some few basic objects i.e tables/views/indexes/stored

procedures/triggers...

Am doing a dettach and attach on sql server 2005.

Question is, do we need to attach the .ldf along with .mdf file?

Is there any use of that, or else...

Forgot a step,

Once i install sql 2005. Can i first install the latest service pack for 2005 and then do the all the above steps ?

Upgrading a SQL Server 2000 Replication Environment

I have a replication being setup on 1 server which is 2000 Server which is acting as Publisher as well as distributor

and we...

While performing Migration, probably the first/second step which method is the best one.

1.Attach / Dettach

2.backup and restore

Is there any constraints going for either of the two methods

Also, want to...

Forgot to mention the replication type. It is Transactional Replication.

Hi Gila,

Thanks a bunch.

What is the use of the below

Change the database's page verify to Checksum

Also, i have replication set up on 2000.

What essential steps should be taken to...

Thank You.

Hi Brandie,

Thanks for the comments on the Maintenance plans and migrating jobs through SSIS. But still i need to check it out practically..

Would like to ask one more question on...

Thanks so much.

That was very helpful.

One last question, i would like to know is there any way to generate scripts for the Maintenance plans so that i can move...

Thanks.

Thanks for the quick response.

I would like to know in the above example , am assuming you have created a "Integrity check" maintenance plan.Right???

or else by seeing at the above...

Thanks 🙂

How it can achieved using xp_cmdshell or osql?

Help!