Is this a Named instance? On which port does sql server listen on?

check if both users have same permission, which user is the job owner? The user which is...

Check how the data types are mapped and then use SQL Server mingration assistance tool.

http://www.microsoft.com/downloads/details.aspx?FamilyID=3E8722AE-77F3-4288-906D-F421E24D322F&displaylang=en&displaylang=en

Did you shared the tlog backup and restored location?

Is SQL Services is running on domain account with admin right?

What error is logged in error log/

Did you checked the tlog backup...

Try using GROUPING SETS ,ROLLUP or CUBE with group by function.

http://msdn.microsoft.com/en-us/library/ms177673.aspx

hxkresl (6/29/2010)

---

All 5 test emails from SQL Server 2008 on the Windows 2008 Server have failed. The error rcvd:

"The mail could not be sent to the recipients because of...

The above TSQL Statement given by LutZ will give you the information needed.

Check the column start_execution_date & Last_execution_date from the sysjobactivity table. From this info, you will know when...

We have set up monitoring jobs, which will monitor

?Log , data and disk space and send alerts if it reaches a thershold.

?A regular full backup with log...

Check if you use ip address instead of servername and check if the user have enough permission on both the server, it should be a domain account? If firewall is...

diva.mayas (6/28/2010)

---

Replication related issue,

IReplication-Replication Distribution Subsystem: agent abc-serv1\PRD01-star-star Billing-PROD-VREPL1\REPL01-25 failed.

Violation of PRIMARY KEY constraint 'PK_vendors'. Cannot insert duplicate key in object 'dbo.vendors'.

Error is issued while operation is done...

While installing SQL Server 2008 and choosing authentication, By default it will be windows authentication, if you choose mixed mode then it would have asked to type the sa password....

spgorasiya (6/23/2010)

---

Every time I am installing first visual studio 2005 and then install sql server 2005 Enterprise Edition but this time I install SQL Server 2005 first and then install...

Check the execution plan for both 2000 & 2008, there might be missing indexes,

Did you changed the compatability level to 100 after upgradation? Please check and if possible run...

There are so many reasons for time out, please provide more context on that?

Option 2

Quite trucky and would require a bit of work. Put a trigger on the tables for A and B and have them populate the data to C through...

I think Your points are absolutely right, the above steps are not clear and proper. Some time it is easier to upgrade the instances and then configure the log shipping...