I always use the SystemDSN tab under ODBC. Are you on that tab? Follow the screen prompts and the wizard should ask for ODBC name, description, SERVER name, then...

Hmmmmm......I am going to have to respectfully disagree with Doc-s. We started down the VMware

path 15 months ago and have not looked back. Going VM allowed us to consolidate...

Set up an ODBC hook using the same logon and pswd pair that you use to actually log onto the server and you should be able to connect. I...

Rob Nickolaus-860201 (4/23/2010)

---

In addition to the technical costs, there can be a legal risk (cost) with retaining certain types of data. My company has taken a stance on certain data...

I hope that sooner or later, you realize that money is NOT everything. ...

I myself work in local government, so there are never any bonuses. And, I have been here long enough that I am now at the top of my pay range,...

Take the time (and bite the bullet) to write a preprocessing module to edit the batch coming into your database and edit the darn field. Any record not passing...

I am a member of the 'maintain' but do not change group, but have a similar dilemma:

One of the systems that I work with is the county prosecutor's case management...

Perry Whittle (4/2/2010)

Nelson i presume you are using the MS script to export logins from one instance to another. If so, the script notes strongly recommend you review the output...

Thanks for the laugh, Steve. It was a GREAT way to start off a rainy, drizzly day here in Olympia, WA. I certainly like your selection of aloha shirts,...

CirquedeSQLeil responded:

Besides the side by side install, have you considered moving all of the databases to SQL 2005?

Eventually, we will convert the remaining databases, but several are maintained...

Being a "county" staff member, our systems are on a really 'slow growth' schedule and fortunately are really stable. My biggest update time, each month, is MS critical updates for...

I would think that "being average" may be ok, in most cases. The PROBLEM is becoming "complacent" and unwilling (or inflexible) to handle the strange and unknown issues that pop...

Jesse Barlau (1/8/2010)

---

You have Featured Articles, Editorial, Featured Script. That's where I start, that's how I decide whether to read further. Add "Interesting Products/Vendors" as a link to...

Well, work-wise, my main goal in 2010 would be to "stay employed"....Project-wise, I'll be working on SSIS and a lot of .NET upgrades from VB 6.0 ( really old stuff...