I am running with 16GB and I did the following:

sp_configure 'awe enabled', 1

go

reconfigure with override

go

sp_configure 'max server memory (MB)', 14336

go

reconfigure with override

go

Stop and start SQL Server. I chose the max...

in regards to x64:

Check out this link.

I'm dealing with this headache now.

"There is no 64-bit design-time or run-time support for Data Transformation Services (DTS) packages that were created in earlier versions of SQL Server."

So I'm guessing you didn't have to deal...

The only explanation I can come up with is that the .mdf was removed while the engine wasn't running.

Wally (2/21/2008)

---

Jeff,

If you haven't undertaken any exams as of yet, I would wait.

I have my MCDBA, and was about to take the two exams to upgrade, but decided to wait...

All the security issues aside because I would like to present an option when they say there is no other way.

Is there a way to do this in T-SQL, DTS,...

seeing that it's internal and being a firewall does that change what you are saying?

Matt Miller (10/3/2008)

---

This would be a textbook case for a "man in the middle" attack. Passing large amounts of data using a URL is essentially leaving yourself VERY open...

would synonyms work here?

I see some negative press on here about it but maybe it's an option.

I wish that was more the case but it's not. I've tried expressing the importance...

So how would you work that in practice?

Do you setup a standard where you say the linked server name is the same in dev and prod?

And what about when those...

Well, I hope I can come up with something. I've been playing around a few days and thought I was close only to find out I had gone down a...

I've inherited a system without FK's. There are implied FK's but I can handle that.

I'm starting to wonder if it has something to do with the login.

Can you drop the linked server and re-add it? Verify that they are setup the same.

I've started doing...

I just thought of something we tried when something similar happened for us.

See if anything in this post helps you.