x4 for not using the backup/restore method...

I agree there are lots of methods, but the ones presented above are the best (my experience).

You should know EVERY object change that...

How was it mapped?

CEWII

I agree, but I wanted to make a point without being unpleasant about it. ...

So I would say the answer is yes it still causes locks and you can't prevent it..

CEWII

Why don't you just recompile them on the new database from your source control system?

CEWII

Since they are defined as connections they should be the same, their "connection string" looks a little wierd but is fairly self explanatory..

That does beg another question though, are you...

I would think the only locking would be on tempdb. But for me it is less clear about an INSERT/SELECT, I could see that causing some locking. Hm,...

For connections it is even easier. There is a tab for connections. Go there and check the checkbox next to the connection you want to change and then...

You can get it to do that by clicking on the + sign, it just should be open by default..

CEWII

dbo is the default, usually.. It is considered a best practice to always include the schema of the object you are creating AND accessing. It very clearly determines...

Your confusion is understandable, it is not clearly documented or very clear at all.

I think I want to clear up a misunderstanding first. The variables are ALWAYS...

david.morrison-1035652 (11/4/2009)

---

So my four questions are

1.) Is my assumption about loading it all into memory correct?

2.) Why does it do this?

3.) can I stop it doing this?

3a.) If not can...

There are lots of reasons and last time I had it happen I had to reset its status because I fixed the underlying problem. For me one of the...

Krishna -878600 (11/4/2009)

---

Mixed mode?? Not a best practice. That is the...

hydbadrose (11/3/2009)

---

Hello,

I need help or good site to get the steps to migrate the data, shcema, logins, dependencies, agent jobs from sql 2000 to Sql 2008. The shcema has been...