This can get very confusing as you move databases around.  To correct the problem use this command:

alter database dbname  MODIFY FILE (NAME = logical_file_name, NEWNAME = 'new_logical_name')

You don't have to...

CONVERT(Varchar(12),GetDate(),101) - sort order is incorrect

If you use 102, the sort order will be correct. 

I this something like this should work:

SELECT  BusinessDate,

 SUM([OrigCount]) as OrigCount,

 SUM(CorrectedCount) as CorrectedCount

FROM    (

 select   CONVERT(varchar(10), TD.CreatedDateTime, 101) AS BusinessDate,

           1 as OrigCount, 0 as CorrectedCount

 FROM  TransactionDetail...

Sorry, don't know why this happens. 

Here is a query to find records without an out punch:

select employeeID, punchtime from clock i where

punchtype = 1 and not exists(select * from clock where punchtype = 0 and...

I don't know if you can detach system databases, but you can try this:

1.  Shut down the SQL services

2. Copy the system ldf and mdf files

3. Install SQL Server to same...

Here is an easy way to do it:

sp_msforeachtable @command1= 'print ''?''', @command2 = "select count(*) from ?"

I found this in

http://www.sqlservercentral.com/columnists/rsharma/countrecords.asp

It only works on user (non-system) tables and set...

Look up  DBCC UPDATEUSAGE in Books On Line. 

Here are the tables I used:

create table employee (id int, firstName varchar(20), lastName varchar(20))

go

create table clock (employeeID int, punchTime dateTime, punchType bit)

go

Here's my test data:

id firstName lastName

1 John Smith

2 Harry Jones

3 Mary Johnson

employeeID punchTime punchType

1 1/2/2004 8:00:00 AM 1

1 1/2/2004 5:00:00 PM 0

1 1/3/2004 8:03:00...

I would try attaching the mdf, sometimes this will create the ldf for you.  Also see this thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=153901

sp_password can be used to change passwords. 

sp_password @old = 'oldPassword', @new='newPassword',@loginame='sa'

One option is to buy the Professional version of SQL LiteSpeed to do your backups.  You can do password protected and encrypted backups.  The backups also are compressed.

how can i use the sp_executesql in the master DB against my db or, how can i copy it to my db ?

You should be able to use sp_executesql in...

When using the debugger, the date parameter should be yyyy-mm-dd .  Don't include the quote marks.  Think of it as similar to filling out a form, you don't use quotes.

I have done lots of Access/SQL development but never got into the Access Projects.  Is this a Project or the old fashioned mdb?  My advice is for the old fashioned type, so diregard...