leokarp (12/21/2007)

---

If an application has embedded SQL statements and they are referencing system tables directly that may be the case of application being compatible only with a particular SQL Server...

Depends how much it's worth to you, John. There is a product called SwisSQL (http://www.swissql.com/products/sql-translator/sql-converter.html) that will do what you want. It's shareware, but full license is just shy of...

Jason Shadonix (12/20/2007)

---

If your vendor says his app is only 2000 compatible, I wouldn't mess with putting it on 2005, even if that DB is in 2000 compatablity mode. ...

The problem I find with tests like those you've mentioned is usually that they concentrate on the detail and not on the fundamental abilities. Personally, I like seeing people provided...

Meredith Ryan (12/19/2007)

---

majorbloodnock (12/17/2007)

---

I'm a little rusty on licensing options now, since it's a while since I had that particular responsibility in my current company. However, last time I made...

Thanks, Andy.

I said it was quite a while since I'd visited this, didn't I! :blush: Your clarification is useful, though, so I'll store it up for when we revisit DB...

I'm a little rusty on licensing options now, since it's a while since I had that particular responsibility in my current company. However, last time I made a comparison, the...

Indeed, Brandie. It's difficult to post a humorous reply about that incident, because no matter how outrageously idiotic you try to make each step sound, it still seems to be...

Brandie Tarvin (12/14/2007)

---

But at my workplace, we can't send anything out on CD or Email without it being seriously encrypted, plus we actually need managerial sign off to send that...

Not sure I'd go that far. I think all I'd check for is corroboration from one other party. I'd probably also ask her for the name of the person who...

Hey, Steve

How did you know that managers tend to look over my shoulder whilst I'm working!

Nice work environment, though, eh?

Hi, Horace

I just posted a response to your other thread (about IIS/SQL Server), and mentioned a book that might be useful for you.

Agree with above. The web site will simply use a connect string, specifying destination server, database, account and password. Most likely, it'll be held in the global.asa file, but not...

Optimist.

Personally, I take the attitude that, as a DBA, I have all the rights and none of the authority to do things. In short, I don't believe it matters whether...