I used

select name, id from sysobjects where name = 'get_emp_list_FY06'

to get my objid. then I run this

select bucketid, cacheobjtype, objtype, objid, dbid     

 from master.dbo.SYSCACHEOBJECTS

 where ...

I did not have SQL server 2005. I used the first method.

select *

from dbo.Employees E

where not exists (select *

  from dbo.ModuleLog L

  where L.EmployeeName = E.EmployeeName

   and L.DOB = E.DOB).

Since I felt no...

Thanks. It is well done.

Thanks.

Thanks. Right now I use 

 select cast(left(score,len(score)- 1) as smallint) from [Doctor Quiz Log]

it is good to know.

I do not know what kind of the report you want to create. There are plenty link in the interent. If you more specify, It will more easy for other...

Thanks. But in the Virtual Directory properties , It seem no way for me to get into the property. Thanks.

I actually want to link to view. Since I have employee table which contain SS and other info I want to set up in the SQL . Weekly I compared...

I tried to connect the MS ACCESS to link the SQL server table using DSN-less connection since I do not like to go to different computer to set up the...

how do  i edit the table which have data there. Do I need to define bit_const. If I want to defaut value as 1. Can I do that in the...

how do  i edit the table which have data there. Do I need to define bit_const. If I want to defaut value as 1. Can I do that in the...

I used DSN to link the sql table in ACCESS. I do not know what is the disadvantage of that.

Thanks. That is what I need. I need to combine two application together by figuring out how other people accomplish that.

SET CONCAT_NULL_YIELDS_NULL { ON | OFF } did not work in my case since I need to make the decision according to the value null or not.