Place your code in an activeX script if it isn't already. Check the return value of the proc call either by using recordset, or parameter. If the error is returned...

I have experienced behavior like this when tryin to execute queries via the dts steps/tasks. I only use activeX scripts in DTS now because they are more reliable and don't...

Another, more simple factor could just be your aggregations. If You do not have the necessary aggregations on your partition(s)/cube then raw data will have to be queried to return...

Moving the querylog table to the sql server is a two part process. First you must migrate the actual jet file over to the sql server you want it...

Ahh, now that's a possibility. The TempDB is on another file, and I know it is sustaining much activity in this process, but I haven't checked it's size or really...

Thank you for the suggestions so far. It is in simple mode, and the log file is 5 GB - it never needs to grow. I have a solution that...

I have experienced weird behavior from sending queries with the nonemptycrossjoin and the non empty functions. I prefer the non empty function over the nonemptycrossjoin, but either way i have...

From what I can gather by your situation the best way to accomplish this task is with MDX. It doesn't sound so much like a schema issue to me.

"SELECT...

uhm, yes you can use the ado objects and methods via extended stored procs in Sql.

I have provided a specific real life example, but it is not well documented. Let...

I am inclined to agree with you. Besides, it can't be easy to come up with a new question every single day. I am satisfied with taking my bad mark...

That would probably be to difficult to administrate. I am thinking more in conceptual terms. By thinking of it in these terms questions could be tailored (made easier or harder)....

As a matter of fact that 80% idea of yours is pretty good. You can't base the legitimacy of a question on whether it made you think, or if you...

This was a bad quesion. Questions that yield a single wrong answer of over 50%, or where the right answer has under 30% are bad questions. These questions should not...

select   a.department,a.mgr_id,b.mgr,a.emp1_id,c.emp1,a.emp2_id,d.emp2

from     dept_table a

join      employees b

on       a.mgr_id = b.emp_id

join      employees c

on       a.emp1_id = c.emp_id

join      employees d

on       a.emp2_id = d.emp_id

order    by a.department

Just replace emp_id with whatever the column name is in employees that represents the...

I REALLY didn't want to have to edit the registry, but your first link looked pretty solid, so I just went with it. I was, btw, working on SQL 7,...