What kind of infrastructure exists between the user and the server?

I suspect if they are on different networks then you are going to have to use VPN or FTP to...

they all have pros and con's -

idera sql diagnostic manager tends to be a little flaky and actually consumes a fair amount of CPU from the sql box with the...

can you post what you are attempting to do. add a subscription? add an article?

if you have renamed your server then you also need to let sql server know

if...

seems to me you might be better creating a view on your sql server and then let your application read from the view

that way you get some decent sql that...

also check if there is a trigger against the table - especially a badly coded one - perhaps with nested trigger calls

most of our web guys use WCF to provide a service exposed to the internet that can access the SQL server

if you look at the original post its 7 int values - so we don't need to worry about . - e etc

this looks right to me

select a.Prescription_id,count(distinct b.id) from tbl_prescription_dates a

inner join tbl_prescription_dates b

on a.Prescription_id=b.Prescription_id

and a.Date_Issued >= dateadd(dd,-2,b.Date_Issued)

and a.Date_Issued <=dateadd(dd,+2,b.Date_Issued)

and a.idb.id

group by a.Prescription_id

but i needed the...

another problem here is that if you look at the 1st 4 rows of data (numbered 1 - 4)

1 was within 2 days of 2 & 3

2 was within 2...

i had a go at this and ran out of time

but you need to add an identity to your table definition so you don't match a row with itself

CREATE table...

isnumeric(right(myfield,7))

or if it's not always 7 digits

isnumeric(substring(myfield,3,7) )

we have similar issues, but not on that scale - normally we can get about 10,000 pages out in about 20 minutes. - but we always render to pdf or...

or why not convert it to SQL express??????

you say it's access - is it an ADP (access data project)? or a standard access file.

if you convert to an adp file you can use stored procs to...

sql i beleive