the first query looks like

find the last date that the quizzer (empno) took

insert into #tempPreviousWinTrainingLog (EmplNO,QuizName, CTDate)

select a.EmplNO,a.quizname,MAX(CTDate) as last_date

from tblPreviousWinTrainingLog a

where a.QuizName ='Back Injury Competancy'

group by ...

Can you view the mdb file with Access to list its contents? I hope you have a backup.

Hello,

You could build a tiny table with the translations to join with. Since the values are hardcoded in INFORMATION_SCHEMA.TABLE_PRIVILEGES it isn't likely that the translationtable is already there.

If you lookup...

First thing to check is that dbareport actually has access to the database. Is the server online?

Hello,

You could relocate

AND BE.EmpTypCd = 2

AND StatusDesc.Typ = 1099

AND MoveTypeDesc.Typ = 1102

(BE.EmpFirstNm Like 's%' OR BE.EmpFamiliarNm LIKE 's%')

AND (BE.EmpPrevLastNm LIKE 's%' or BE.EmpLastNm Like 's%' )

AND CF.CustFileStatusDt >= CONVERT(DATETIME, GETDATE()...

Also using mm/dd/yyyy as dateformat is risky since it could be dd/mm/yyyy. Safest way is to use yyyymmdd

Permissions needed (from the books online):

TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are...

What servicepack does the Access97 have, SP2?

Hello,

Did you get an error message?.

Moving one database to another:

Possibility 1:

Detach database from source server, copy files to destination server, (attach databases back at sourceserver),attach database at destination server.

Possibility 2:

Backup...

We overdid the separation a few years ago and tend to integrate databases back into larger ones (from 35 to 3) except data from foreign sources. The main reason is...

Also thanks for the sqlprompt bundle. Enjoying the site everyday.

It is still a tricky matter since administrator's can do everything. (shutting down service,...)

My current solution:

*Sqlserver run under an administrator account "blabla" different than "administrator"

*Blabla added it to the sql...

The computername wasn't renamed in the past?

The securitydescriptors in master can be out of sync with a restored database. If you look in a database the login for a certain user is Null instead of user...

I...

sorry, a bit in a hurry.

check if your scripts fetches all data and are not holding transactions.

You might check this one out

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