You make a very good point.

Couldn't agree more on these two above points.

And to...

Thank you for your reply. For ease of the conversation, I'm going to call this co-worker "Alice" from now on.

Underlying problem - Alice is mentally lazy.

Alice came from a...

Build your own. Do the research and you can make a great machine that's exactly what you want. NewEgg is great because you can do side-by-side comparisons and...

This person's ignorance and lack of initiative continue to amaze me.

Under 5gb? I can't imagine how easy it would be to manage databases of that size. I don't think I would ever have to deal with a phone...

80-90% under 2gb? No one has made a comment on that statement?

I assume that 80-90% isn't JUST Sql Server databases. If you include Access and all the other...

Well I already had the '2nd server as sql 2000' option in place.

I have done a ton of research on the problems with 32bit SSIS. Looks like...

So no one has any other work arounds for this issue? I'm really suprised that this isn't a bigger issue in the community.

Thank you both for your replies.

GilaMonster (1/14/2010)

---

What I've had to do before, when there were no x64 drivers, was to set up another server (x86), install SQL on there and use the x86 drivers. Not...

I...

I'm talking about both really.

I have a SQL Server Agent job that does some things, then runs a DOS batch job.

I want to make sure that...

FIXED IT!!!!

When you setup the linked server, click on Provider Options, then check Level Zero Only.

Finding this way to access a linked server basically makes all my DTS jobs on...

Jack Corbett (7/16/2009)

---

Huh, that is very odd. Both the need to grant permissions and the fact the blog won't display in FF (that's what I use).

Are the objects (views,...