The director is correct in implementing the security model.

This will be the case in typical banking environment. No DBA will be given acess to server inturn to the data, without...

I have aborted the installation as I wanted to install SP1 and test it before going to SP4.

Are there any specific key that need to set..?

By the way what are...

Max number of worker threads is one of the configuration options in SQL Server. You can configure that in Enterprise manager Server properties or by using sp_confiure.

The typical setting would...

I've tried using very complex passwords such as "sasdjAdidiE594" which are very difficult to remember indeed.

I've a doubt here.

I should create SA login for the MSDE..no I suppose.

Harris.

I also didn't understand the problem at all.

Is that related to SQL Server database backup at all..

Harris/

Thanks Michel.

But im working with SQL Server 2000 Enterprise Edition.

Harris.

Yes we can do that with the help of maintenence plan.

And also typical design is that a job is created for taking the backup for...

Thank you very much..

Though I wanted to work from the same command promt, its ok I can work out from a different.

If the server...

I don't want GUI tools at all.

All I want to use is only cmd line..

Meaning I dont want to use 'mstsc' to connect.

Is there any other way??

Harris

When SQL Server is using the memory dynamically it queries the system periodically to get the amount of free phisical space available.

SQL Server grows or shrinks the buffer cache to...

Its not only the property of the Windows Server 2003 to allocate pysical memory depending on the need but also the property of SQL Server to gain or loose memory...

By remote sevice I mean service on a remote sever.

May I know the reason why you are taking a restore from the full backup and differential backup??

The reason could be database failure. And I guess while restoring in such...