MS Access Pass-through queries don't get processed in Access, so the native parameter binding doesn't work. (They're called "pass-through" because that SQL is not process locally, but is...

oh...and buy the 64-bit edition to get past the 65,536 files or 4GB/file limit.

I hear you that you're not in charge of the environment. However, as an advisor as you described it, it would be within my purview (or obligation in my...

CAL's are definitely one option for licensing SQL server.

My interpretation is that IF the client data transits through SQL Server, then you WOULD have to license CAL's. If the data calls happen from the app directly to...

Jeff Moden (12/14/2007)

---

C'mon folks... WinZip Pro costs what, 60$??? Don't screw around with your archive data... do it right. You probably spend more than $60 a month buying coffee,...

Keep in mind that by "hit" the server I mean - if the front-end app sends the question to SQL and SQL goes to get the data, returns it and...

If the end-user data being queried by the end-users never "hits" the SQL server, then I would imagine that no, you don't need it. If it's only using it...

Try this:

First start by creating an ODBC data source:

- Control Panel, admin tools, data sources (ODBC)

- switch to the System DSN tab, click on Add. Pick...

On another note - it's so very reassuring to see that these IT guru's at the government agency think it's perfectly ok to open an unencrypted port to a SQL...

Unless they plan on running the application from that area (i.e. hosting the application in that office where internet access is locked down), you might not get a lot of...

Sampath - to echo what Vladan is saying - cursor's are slow compared to other solutions. If the cursor is so big that you need to know how many...

Oh - I have no doubt that SAS and SCSI is better. I just wish someone would actually come out with the "why SATA doesn't stack up against SCSI",...

Just for my education - what does "track-aligning" a LUN entail (meaning - what is it that's being done?)

As for SATA - I've only dealth with EMC (which only allows...

You also tend to present yourself differently. Our colleagues across the pond tend to be more understated than we are on the left side of the altantic... You...