Thanks

Nita

Yes it is the requirement to go only side-by side only

We going to do side-by-side upgrade....after we do we going to put same server name.

Nita

We have so many subscriber...

Is there is any other way to do replication with upgrade wizard.

Nita

Thanks for help

Nita

you need to give access to MSDB database.

Nita

You can select whatever need from sp_who2 and filter the sleeping in where cluase. Create another SP

Nita

Exec in job step do

Exec SP_name

Nita

Thanks Got it.

Thanks for quick response

It's a SYSADMIN

Nita

Thanks it worked

Excellent

how should I do for 100 tables

Thanks Greag,

Got the answer its was simple so I just change it to FULL

Thanks for the help

Nita

Diagram Only

Nita

The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL...