SELECT*

1)Perform a full backup of all user,system and Resource databases. 2)Note down of Important SQL Server configuration settings,Start Up parameters,Linked Servers and Script out SQL Server Agent Jobs,Script Out SQL Server Logins,Memory Utilization,CPU and Disk Utilization. 3)Create an appropriate service pack Deployment and Rollback Plan 4)Always Install Service Packs first In Development environment and then test all applications which are using by SQL Server 5)Once everything looks good in development environment then only install service pack in QA environment and also test your rollback plan 6)If everything good in development and QA Environment then plan to install service pack in a Production Environment by communicating an appropriate downtime window to the stake holders and database application users. 7)Once the service pack installed successfully in a production environment perform sanity checks to confirm all applications are working fine. 8)Reboot sql server once servic...

Push Subscription: Runs all agents at the Distirbutor. This option makes it easier to administer the synchoronization of subscriptions centrally. Pull Subscription: Runs each agent at its subscriber. This option reduces the processing overhead at the distributor and lets each Subscriber administer the synchronization of its subscription.

Some times you may get the above error while you are install SQL Mail Successfully and testing it form TestMail. Then you need to look at the below issues. Go to the your Mail Server Click Run--> InetMgr-->In the InetMgr You can find DEFAULT SMTP SERVICES(If this not there need to be installed. If this is not there in that server you can not use this as @mailserver_name in msdb.dbo.sysmail_add_account_sp procedure)-->Right Click-->Properties-->Access-->Give ip address there in Connection and Relay.