thank you for your quick reply, but we don't really have 100 databases , we have only 10.

thank you that is exactly what i needed...

Thank you!!! exactly what i needed, i tried it but for some reason it does not work, can you tell me what i did wrong please, i tried this.....

SET ServerName=<MySQLServerName>

SET...

thanks! so i do have to install outlook in  my sql server box?

Thank you! that is exactly what i needed.. i created a batch file (.bat) with the encrypted command using the new sql server login and passworkd, I created. (i used...

hi guys, how does the user table that i need to create for the permissions look like? what columns do i need besides username and Item Number and how do i...

hi!!! thanks, so what i did was i downloaded the dtsrun.exe from msde2000 and installed it. and it works. one question though.. for it to be able to get no...

Thank you guys soooo much.. i am going to use all of your advice.. i will let you know how it goes...

Thank you Jo... perfect thanks!!! so i could have the same copies of the database front end, but then how do the different switchboards would work? each department has to...

hi, thank you , but still get the same errors:

Server: Msg 207, Level 16, State 3, Line 1

Invalid column name 'MinofInvoice_Date'.

Server: Msg 207, Level 16, State 1, Line 1

Invalid...

i really apreciate your full explanation and examples.. thank you sooo much.. now i am clear in the difference. I have been reading about this for a while and never...

thank you so much.  that is exactly how it is set up right now. so it is the right way for computer management to look how it is now: local...

thank you!!! is there a reason why a user who has a sql server login with windows authentication has to be a part of the administrators group? i am having...

sorry i should had been more specific. in sql server 2000 when you go to computer management, under local users and groups there are two folders one that says users...

ok this is my last question... is there a difference between a server administrator role or a login under the administrator folder under computer management?