Is there anything mentioned in the error logs of sql server?

Has sql server recently been moved/renamed?

Looks like a permission issue. Normal admin functions run fine?

Have a look at

http://support.microsoft.com/kb/328306/en-us

Is the remote server Windows Authentication only?

you still have the line

Set rsLogin = conn2.Execute(SQLQuery2) ?

Do you have experience with asp?

Step 1: create connection

Step 2: execute query

Step 3: check if there are any results .eof

Step 4: process results

Step 5: close recordset

The function IsNull transforms any...

Have you included the function tnull before you call tnull?

You could also change null to IsNull.(Haven't got any empty values yet)

To be really sure you should test if sp_getLogin returns...

El,

The ... was "and so on". The left join causes MATBIT.ITEMCODE to be null if NoSpaces.ITEMCODE isn't found in MATBIT. Actual syntax can differ bases on Access version and how...

Hello,

I divided up in 2 and left out worktask,workrequest (not used?)

select Mileage.users.Uname

, Mileage.UnameFirst

, Mileage.UnameLast

, Mileage.totMileage

, expenses.totExpenses

FROM --calculate total mileage per user,per workcompleted

(

SELECT users.Uname, users.UnameFirst, users.UnameLast

,round(sum(workcompleted.WCmileage), 2) as totMileage

FROM users /*all...

/*updating existing values*/

UPDATE MATBIT INNER JOIN [NewPrice List] ON MATBIT.ITEMCODE=[NewPrice List].ITEMCODE SET MATBIT.PRICE = [NewPrice List]!MATBITPRICE, MATBIT.DESC_Col = [NewPrice List]!MATBITDESC_COL;

/*inserting new values*/

INSERT INTO MATBIT

(PRICE,DESC_Col,ITEMCODE )

SELECT NoSpaces.MATBITPRICE,...

FROM [NewPrice List] NoSpaces

WHERE...

finding bottleneck:

Look at the performance counter (cpu, I/O)?

sp_who2 gives some information about connections, if they are blocked and the amount op cpu,io since the connection started

sql profiler can start a...

I havent't used this one, but there is an option-clause for the select statement

USE pubs

SELECT a.au_fname, a.au_lname, SUBSTRING(t.title, 1, 15)

FROM authors a INNER JOIN titleauthor ta

ON...

If you use triggers be sure to add the line

SET NOCOUNT ON after the "AS" to reduce roundtrips.

CREATE TRIGGER LastEditDate ON ManifestHeader FOR INSERT,UPDATE

AS

SET NOCOUNT ON

...

see

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1057991,00.html

Depends on how high the fragmentation level is. One advantage of dbcc indexdefrag is that you can continue to work. A disadvantage is that all it operations are logged, resulting...

Hello,

Have a look at:

http://support.microsoft.com/kb/283811

*lost typing

Have a look at

http://www.sql-server-performance.com/sql_server_performance_audit.asp

for some info about performance counters etc.

Resetting the service also clears any outstanding transactions/locks. Try to figure out which queries are taking longer (sql profiler),...

perhaps this

http://support.microsoft.com/kb/175239

Is the server up to date with patches?