i've just had the same problems on a new install - i think it relates to the priveleges of the SERVICE ACCOUNT - not your login account.

I usually resort to one of the following

pig headed stubborness

obfuscating database code

boring them to death (ok - that's not hard)

or my favourite so far has been in sql 2005 -...

run the following

select name from sysobjects where name like '%mytable%'

you should see a list of all the constraints in there somewhere. the create statement will have defaulted it to...

select table1.*,table2.* from table1 inner join table2 on table1.site_ref=table2.site_ref

the problem we're seeing with 2003 is not a network issue, it's a casae of outlook 2003 jsut not behaving the way 2000 used to.

the problem is really evident when...

i've seen this behaviour on betweens before.

try using where Ticks.Tick_Price = @Triggered_Price AND

Ticks.Tick_DateTime >= @Triggered_Datetime AND

Ticks.Tick_DateTime<=(dateadd......

no idea why it fixed the problem but it did - possibley something to do...

we have a similar problem in that a few of our outlook 2003 installations take a long time to initialise. this causes sql agent to hang.

interestingly enough - these 2003...

this really depends on your table structure

if you have an id column in the table (as primary key) then it's pretty easy

basically your first query returns the top 1 record

the...

just one i made up to demo the principal

you need to order the results in some sort of order to be able to effectively say this is the 101st record...

just a though. you're using labels to show this data - not text boxes?

but i'm guessing since you're getting #name thats not the problem.

looking at it though - you're using...

use a union query

select cutomer_id,max(orderdate) from mytable group by customer_id

UNION

select customer_id,max(orderdate) from mytable where custorders.id not in

(select id from custorders where ..........

i always use convert(varchar(11),getdate()) to put the value out in a real date format.

then convert it back to datetime

hence

select convert(datetime(convert(nvarchar(11),getdate()))

returns '12-may-2006 00:00:00'

not sure if this is right - but you might have to use

dim param1 as NEW adodb.parameter

although after a beer at lunch i'm not sure

is the login a member of builtin/administrators?

if the service is failed over on node 1 where your user login is a member of local admins, but not a member of...

depends on the table structure

but normally for the 1st 100

select top 100 * from mytable order by dateadded

then for the second 100

select top 100 * from mytable where...