Looks like when doing the restore or attach, you alter the location there.

http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/ff8c14ae-a9d0-4668-a95b-ee19bbb48b26/

You'll restore a lot more than just jobs, and I wouldn't recommend this. The msdb restore is really for DR purposes. I suspect it would be OK, but I wouldn't...

My vote would be either compat mode change, or alter the code to use RTRIM instead.

First, the users are always there. They might not be linked to logins, but the users are in the restored database. If you have the same logins, you can use...

I tend to agree with Gail, though you could just install 2008 as a named instance, set both instances to manual, and only run the one you need.

I would say that if you feel comfortable answering questions about any of the topics listed on the MS site, you'll be fine. The questions are not overly tricky, and...

Open Access, select Database Tools on the Ribbon, then there's a "Move Data" section. Choose SQL Server, follow the wizard.

cengland0 (8/4/2011)

---

And, to make it clear, I am a libertarian, but we do not have a libertarian government in the US. I want one but don't have one. ...

I don't know if there is a complete way from SQL/SSIS, but Access has an upsize wizard. Does that not work?

michael wang-201906 (8/4/2011)

---

When you put a 7/24 business on the cloud. How any days you could lost to rebuild an in-house data center when your cloud provider having a trouble?...

Jack Corbett (8/4/2011)

---

GSquared (8/4/2011)

---

GilaMonster (8/3/2011)

---

Tom.Thomson (8/3/2011)

---

which stopped happening 11 years ago) because US immigration control has deteriorated to the point where no-one in his right mind wants to travel to...

GSquared (8/4/2011)

---

...One of the key signs of a dying culture is loss of respect and manners towards others. We've got that in abundance. (We also have most of...

Nevyn (8/4/2011)

---

So it ought to be asked, do you think social security (and while we're at it, medicare, medicaid, etc) ought to be abolished? Do you think doctors ought...

GSquared (8/4/2011)

---

When the government mandates that banks must give loans to high-risk home buyers, that's an inappropriate role for government. When the government tells you that you have to...

blandry (8/4/2011)

---

"The cloud isn't the ultimate answer, and you ought to have a backup plan, which should include the ability to move your services back to your own data center."

This...