Oh, jeez, Frank. Now you're giving me a headache!

Ha! Ha! You got me laughing on that one. Yes, I have and it's like scratching fingernails on a chalk board.

Well, I'll be honest with you. When I'm creating complex queries in MS Access, I feel much more secure that my syntax is correct by using Query By Example....

Very interesting conclusion, John. I was not aware that EM acts a client, but it actually makes sense. I suppose that's where EM separates you as the Database...

No problems, Frank. I'm back from a vacation in Boston. I'll be posting again this week. Thanks for missing me.

This looked like...

Hi Frank!

Now, this I really, really liked 'cause it's so darn true:

quote:

---

Why C++ is like teenage sex. It is on everyone's...

Open Enterprise Manager and open the appropriate Database. Go to Management and under Current Activity you can view the current Process ID's.

All the best,

Dale

Try looking in the SQL Server Agent log first.

1. Open SQL Server Enterprise Manager.

2. Click the + sign next to the server name.

Expand the Management folder.

3. Right-click...

You can use an updategram (included in the second SQL Server 2000 Web Release) which allow you to provide a schema-compliant XML document to be mapped back to the database.

http://search.microsoft.com/search/results.aspx?View=msdn&st=a&s=2&c=4&qu=updategrams

All...

You may be getting this error because you don't have a unique index defined in Tbl02. The only way to really tell what is going on is by running...

You need to get the latest Service Pack. This error was corrected in Service Pack 2 (refer to Q308744).

All the best,

Dale

Joseph,

This is probably more of what you are looking for:

http://www.gattinger.org/wordlists/

All the best,

Dale

Sure thing. Give me a minute. I thought those were downloadable word lists (text files). Hang on.

I just answered this under a different thread - "Anything that is not about SQL".

Well, they looked to be the same topic. They are so similar, you should probably...

You can find wordlists here:

http://www.deny.de/pafiledb/pafiledb.php

All the best,

Dale