Can you please let me know how do we free up the memory and how frequently you do that?

thanks for the information.

Client tools means again i need run setup.exe?

thanks for the information.

so many jobs running under the owner as SA, will it be any problem if i change the sa password?

I have created a login with sysadmin role....

thanks for the information.

os:windows server2003 standard edition 32bit with sp2

is it workout?

any help on this?

The logs have already wrapped around so we can’t see who logged in before .

Hi Phanindra,

I am intresting .

Can you please send me email at kiran41@gmail.com and course outline you will cover in 70 hour traning.

Thanks&Regards,

kiran

i am talking about sqlserver clustering .

Actually I want to know ,Do we have any agents in clustering

I have configured my database mail already with a profile.

what about the job step?

I need the logic.

It is a active\passive cluster server.

yes.

can you provide any script for drop the user from all the databases?

i have 400+ databases.The login have read access to all the databases.

There is no eventlog and sqlserver errorlog for this .

I have restarted the services then tried to detach then i got the same error "The data base is in use".

any help?