the pass through query in access is execute spfiscalsocialstatsnotsatorholidays forms!f_main!txtbegindate, forms!f_main!txtenddate

this is to open the stored procedure in sql server whose code is

ALTER procedure [dbo].[spFiscalSocialStatsNotSatOrHolidays]

@startdate date,

@enddate date

as

select member_number from member_time...

no it gives the identical same error as described above.

that did the trick did not have enough parens.

thanks

thanks that works.

Thank you. This seems to be the trick. Now to get the query to give info that the manager wants.

USE [BtcSystem]

GO

/****** Object: Table [dbo].[member_time] Script Date: 01/10/2012 16:11:15 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[member_time](

[id] [int] IDENTITY(161657,1) NOT NULL,

[member_number] [int] NULL,

[date] [datetime] NULL,

[time_in] [datetime] NULL,

[time_out]...

the datatype is datetime in the sql table. Thank you for your responses.

Ok I stopped sql services and the file became unlocked. I deleted it and then restarted sql services and backed up my live transaction logs and another file by...

no it does not have a green arrow by it. if i want to do a point in time in the script would it look like STOPAT = 'mm/dd/yyyy...

Ok thank you for all of your help. This script

RESTORE DATABASE [LOS_DocumentationSQLTest2] FROM DISK = N'C:\data\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\backup\BtcSystem_backup_2011_12_23_190003_9638931.bak' WITH FILE = 1, NORECOVERY, NOUNLOAD, ...

i restore from a backup with recovery and then i try to restore from transaction log file back up which i named transactionLogBackup.bak. It is that file that is...

ok i restored the dbase from backup and then tried to restore from my transaction log backup and it is still saying that the file can not be processed because...

yes with norecovery and how do i check if it is a part of log shipping

Ok thank you. turns out i have not backup transaction logs. so i did that and now have a transaction file to restore from but when i try...

yes it was