Recent content by mdeemer

u got MSN dude? im matt @ bikechat. net (remove spaces)

i have, and it does return them using the SQL server on my PC but not MSSQL1. The tables are linked in the query. Give you an example. Table1:- IDtbl1, fname, sname Table1:- IDtbl2, IDtbl1, col1, col2 In my query, im linking IDtbl1 in both tables. Im running a search on sname for...

now its running at lightspeed again! PS: When i tell you load times, i mean on the server not download. Ive got a timer on each page (Starts at top, finishes at bottom - and is displayed on each page).

gone again - not many people online either. ???? Some pages just arent even loading now, just constantly waiting for them here. Some loading in a long time, like 20-30 seconds

its actually using a foreign key the query, so its loading all linked records. Works fine on my test server too with the same data, running MS SQL 2000 and IIS.

lol, that means nothing to me. Dont know what the method is, but its between WIN8 and MSSQL1 again (think its win8 tho im not sure). If i use the exact same Access Project file to access my test server then it works fine, but on MSSQL1 its not - like its limiting it (Gets to the same...

Did i say that if I FILTER a table rather than query it then i get all the results I should do! very confused ?(

it shows all the records from my home server, but not when i query MSSQL1. For example, i have a table as such... ID,fname,sname Data might like like this... 1 | John | Smith 2 | John | Jones 3 | John | White 4 | Joe | Bloggs Now, if i open the table on either...

thanks mate. It just goes down once every so often, for like 5 to 20 minutes. During this time any page using a connection to MSSQL1 takes ages to load, often timing out. This can happen when theres nobody on my website so its not my usage/processing capacity. Thanks for setting up a monitor

folks, ive got an exact copy of my SQL database on my home server. However, when i run a query on my home server i get all the results i should do, but when i run the exact same one on MSSQL1 i dont get all the results. The query is exactly the same, but i dont get all results displayed...

with all the 5 and 10 minutes loss of performance, i never get to your live support in time, so by the time i get to them the sites fine. Is there no stats jobs running? Cant you look back at whats caused issues?

back now. wot the hell happened? 5 mins downtime at least.... again....???

completely gone now, wont work at all. www.forums.bikechat.net

Microsoft OLE DB Provider for SQL Server error '80040e31' Timeout expired on basic scripts

dead again! pages that normally load in 0.5 seconds are now loading at around 30-40 seconds. ????