I believe he is using MS Excel to access data in SQL Server. Rather than have MS Query run a SQL query directly, he is having MS Query execute a...

You say you want to know how many matches there are - this sounds like you don't actually need the matches themselves.  Rephrased, if you have 100,000 matches then you...

v8 is SQL Server 2000.  If you're running SQL Server 2000 then try/catch won't work and you have to look at the @@ERROR global variable/function.

However, if you are running SQL...

well, that's one bit of it.  You should also read the licence agreement - previously you could only use MSDE (now replaced by Express) if you had a Visual Studio...

I'm in Australia and we've had a "debate" lately about "THE" national identity card.  At the moment there are several cards and numbers issued by the government, such as Medicare,...

No need to cross post (or at least include a link to your other pose to keep a consistent and single thread)...  Answer (or at least mine) is here.

Hi,

First of all, you needn't cross post.

Second...  A transaction log backup relates to the previous full backup.  If a full backup is in progress then you cannot have a transaction...

Interesting article.  I tend to agree with Joe Celko on this, BUT, the bitmask manipulation is something that a good programmer should know in the languages he/she is using.

For example,...

If it's not too much trouble (and not tooooooo nasty ) could you please post your workaround in case others have the same...

You could try applying the SQL Server 2005 Service Pack.  Also ensure your SQL 2000 server is at SP4.

You are using Windows integrated authentication by the sounds of it.. Correct?

Could you run Query Analyser, execute the following script, and post its output?

use [MY_DB_NAME]     --replace...

Perhaps you have a collation problem on your original table in 2005?

Have you applied the latest service pack for 2005, etc?  What version of 2005 are you running?  Are you able to give us any further details about your server, the...

Could you try using localhost rather than (local)?

They're certainly the goals.  The clearer object names (like namespaces I suppose) are the most obvious benefit.  I haven't explored them a lot yet but have read some articles.  One...