Thanks Jack and all , appreciate your help..

You rock , that worked ,thanks much.

thanks to all who responded to help!!

Thanks for your reply. sdate in datetime and stime in seconds

"sdate" ...

Here is the error message due to endpoints

Login 'domain\username' has granted one or more permission(s). Revoke the permission(s) before dropping the login. (Microsoft SQL Server, Error: 15173)