Rebooting is very typical solution to Microsoft product issue. It worked perfect. Actually I even had to recreate the dts package. Thank you, sir.

For some reason, we decided to give a different name to the new server. Is it still a valid and good plan to move the user dabase and the system...

I found what the problem was. It works good after I change the firewall public profile state to off.

Yes I did. It did not work.

Oh Okay. Thank you so much.

I'm sorry. But I don't quite understand what you mean by two processes in one. The new sql server will take the old one's name once the old one is...

Oh I see. What you're saying is that if you move those system databases along with user databases, you don't have to manually move the logins, dts, and other database...

you were right. very light like feather. Thank you.

No, I don't think I'm going with archiving. Instead, I have a good news. After I fixed a couple of sql jobs that are running slow, The performance is a...

Thank you guys. Your comments gave new views to me. I guess I have to go with the hardest way to fix it. Identify the troublesome queries and Optimize them....

our system is so of over developed. We're looking for a quick and easy fix. I can't tell I have well-designed indexes with confidence. I have another question on tuning...

Somebody suggested to reboot the server. and The linked server is fixed. Unbelievable.

Thank you so much.

I checked the Be made using this security context. and then I typed the login id and password. I think I already mentioned this. Just to make sure, this is...

I tried the both. Putting the sql server name on it and leaving it blank. After putting login information at the Security tab and setting Rpc/Rpc Out to True, I'm...

I'm getting very close. However, I'm having trouble with what to put on Provider string. Here's what I have so far. Thank you so much.

Provider: Microsoft OLE DB Provider for...