Search results for query: *

Hi Appreciate any help with the following, fairly new to SQL Server: I have a stored procedure for a report that runs a query against a view using parameters supplied by the user (in this instance, an example being the JobID). The view is fairly complex as it is a Job Costing report. When...

Hi Would appreciate any help offered on the following: We have a production database set to Full Recovery Mode, with transaction log backups, differential backups and a daily full backup. The daily full backup (which backs up to a separate server) normally takes around 4 minutes to complete...

Hi I have been asked to write to an Audit Table every time an access report is printed. The print command for all the reports in the database displays the standard print dialog box. I can obviously capture that the print button has been clicked (which then displays the print dialog box), but...

I have been asked to record user activity for a specific database, to track who logged in/out and when. I want to write this data to an 'Audit Table'. Being new to SQL Server (2005) could someone assist and point me in the right direction. Is there a sp that can be used to capture this info or...

I have read a number of threads on this, however any clarification of the following would be very much appreciated: I have been asked to move a database to a new drive on the same server, and am aware this can be done using sp_detach_db and sp_attach_db. The question is once this has been done...

We have a call-out schedule which details the employee on call for any day by the hour, the table looks something like this ID EmpID CallDate CallHr 1 55 2006-12-01 1 2 55 2006-12-01 2 3 55 2006-12-01 3 4 55 2006-12-01 4 5 55 2006-12-01 5 6 55 2006-12-01 6 7 55 2006-12-01 7 8 55 2006-12-01 8...

Hi I have been asked to upgrade an Access 2000 Application to use SQL Server as the back end, tables are linked using ODBC and testing has gone quite well (after a few code amendments), however one issue I am getting is adding a new record using recordset operations then opening a form using...

Hi I have been asked to create a facility for Accounts to allocate a number of costs against an employee, these multiple costs then need to be converted into a total cost by effective date, an example below may explain more clearly: EmpID Type EffDate HourlyCost 1 Lab...

Firstly - Happy New Year To All Below is some code that populates a Contact list box for a Customer: SELECT CustomerContactTbl.CustomerContactID, CustomerContactTbl.CustomerID, [CustomerContactTbl]![Title] & " " & Trim([CustomerContactTbl]![FirstName] & " " & [CustomerContactTbl]![Surname])...

I have a problem with the following procedure. It works fine for adding tasks to Outlook for the user, but when they try and assign a task to somebody else it works if they have Outlook open but fails if Outlook is not open with the message: -2044706811 the task "" is stored as a file, not as...