Of course that rather depends on how your Crystal Reports are written - if they're written by a DBA then chances are they just hook into stored procedures, and the...

Just because you're using an IP address to find the server doesn't mean you're communicating with the d/b via TCP/IP, best guess here is that you had different connection options...

How much of a network engineer are you? Do you have basic network connectivity? Can you see the database via ODBC? Can you ping the database server?

Have you installed the...

True - I have a friend who works for the ambulance service - if their db is down they can't route calls to ambulances and people die.

However, on my manufacturing...

Just been reading all this, and I have to say as a UK citizen your healthcare system is pretty barbaric.

There still seems to be some political reticence on the part...

I'm with Terry on this one, just change the language settings manually in the rdl, although it's easier to find if you just "view code" from Visual Studio, then do a...

Sony have played the same trick they did last time - the Playstation 2 launch was also a debacle, but the Playstation 2 was a nifty piece of kit so...

"I know my 8 year old definitely is more of a Microsoft kid than a Sony kid at this point. "

Only because he can't have played on the Nintendo Wii...

I was quite caught up in SOA for a while until I penetrated the hype and I realised it was just three tier architecture in a dress.

I mean, it is...

Thanks William - top tip, I'll remember that one....

Good advice JMC, but I'm running it off the back of a third party app and this is a once a month query, I don't like creating tables in a third...

Gotcha, thanks Jack.

I moved the GO to the end of the query and it worked fine after I deduped a few variables and table names.

I actually have an exact replica...

Just bear in mind that recruitment consultants aren't actually equipped to read between the lines, so if you apply for a DBA role and your title isn't DBA then you...

You got that right.

I've built a data warehouse (after a fashion). It's brilliant. I can predict stock costs for a year to within 1.8% of actuals.

Unfortunately the users don't...

Fair enough - it could be a useful solution, I agree.

My personal preference these days is reporting services - it takes 5 minutes to set up a data source, run a query...