remember that a stored proc is really just a formula, just like A² + B^{2 =} C^2;

A,B and C would have a datatype you can discover, but they do not...

here's a procedure that you pass the tablename...it cursors thru every column in the table, and if any column is null, adds it to the results table, and finally returns...

also, check the actual values:

If rsLogin("UserType") = "user" OR rsLogin("UserType") = "cust" Then %>

if rsLogin("UserType")  is NULL, an error would occur. check the table that contains the column UserType and...

based on the error messge, it sounds like the function is calling a sotred proc in it's body; if you want to send me a priv message witht eh function...

I think it's because your server name has single quotes in it, which is invalid. i know you can use double quotes, but not single.

bad:  DRIVER={SQL Server};SERVER='ISERVER';UID=sql_dba_link;PWD=MyPwd;Initial Catalog=SQL_DBA

good:  DRIVER={SQL...

does this return a value? this should do the same thing you did when assigning it to the @x variable.

SELECT dbo.fnCalcBusHours( 1, 1, '8/31/2004 10:18:30 PM'

this might help: it shows each table, and what filegroup a table belongs to. if you only have ONE datafile per filegroup, then the table is contained in that datafile.

if...

i believe xdate1 is creation date, while xdate2 is last changed date?

this would list all users that havne't changed their pass in >60 days i think. yould probalby use this...

pretty much all functions have to be preceeded by the owner (usually dbo.)

this will work:

select Incident_Number, dbo.fnCalcBusHours(Cust_Id, Service_Id, open_time, close_time)