Thanks everyone I will check out both

George

yes I'm sorry I did mean the service password. not sure what it is and need the password for permissions to a different server.

Thanks Steve

Thanks for the response but i used cast(convert(char(10),JOIN_DATE,121) as date) as day in query and got the resluts i was looking for

sum is probably incorrect what I need is the total for each day

Thanks Loudclear but the count returns as 1 need the count sum for each day

Thank you Lowell this worked great. Just what i was trying to create myself with no success.

Thanks Fraggle i'm going to try it now

got it had to do the following:

To assign a TCP/IP port number to the SQL Server Database Engine

Using SQL Server Configuration Manager

1.In SQL Server Configuration Manager, in the console pane,...

Thanks SS I will check the config.

Thanks GSquared

Thanks Sean I will relay the message

Thanks Lowell tha worked. I like the idea of the views

Thank you Cphite that worked perfectly

George

cphite thank you for your reply,

The service is running, but how do you tell if it has access to a folder?