you can write the script to call the .bat file

To add to the acceptable use by dcpeterson.

in enterprise you can have more db connections than in the dev otherwise dcpeterson has covered all that you need to know

i think i will hunt this office space that all you geeks are talking about. my choice for the moment is matrix, it was really cool.

i would go for point 3.there is replication in sql server you might want to read on that

i think restarting the sql server will solve the problem. i can't think of any other way.

you can an update trigger as suggested by noel or if you prefer you can use the update statement when you are updating your data to just update the...

joemai i can't understand what it is you are requesting.

please put provide ddl and sample data as carl has said

i would suggest

SELECT DATEDIFF(mi, CheckInTime, CheckOutTime) AS MinutesWorked

the datatype would be integer and then when you are displaying the hours worked in a report you convert to hours...

once had a problem with the date conversions.i ended up changing to 126 from 103 because of logical errors in reports that where being generated.

you can also use visual studio .net

select * from tbl for xml auto

this will return an xml string

refer to bol for more info

how do you take care of the reporting side of things.

maybe you should go ahead and do the article.in this ever evolving world of changing requirements i think i don't mind the redundancy of two or more articles on auditing.

as...

nice website

i have had a similar error msg before.the problem was that i was trying to use windows logon credentials on an sql server in another domain.my machine is in a...