Thanks for u r advice. But the recovery model is full,log file size is reach around 25GB. and move the log file to another system also failed.

Is any other menthod...

Hi All,

Thanks for your suggestion. Is any driect way in SQL Server to Block users...

Dear pankaj

I also try to create a application role. But I face some problems they...

Dear Rama

I need some users like sa and some application users have to connect sql server using SQL Query Analysier and other users do not connect the SQL Server using...

Pls check your workstation login have access to  sql server. If not you have to assign your workstation login to SQL user name( using EM->Security) and check your...

Please use the following details

http://support.microsoft.com/kb/283037/

http://support.microsoft.com/kb/274750/

Use of the /PAE switch in the Boot.ini and the AWE enable option in SQL Server allows SQL Server 2000 to utilize more than...

If u r not enabled PAE/AWE, OS will allocate only 2 GB for SQL Server and remainig for OS.

For your min server memory (MB) is more than what OS...

Dear

Can you please send the output of Sp_Configure.

I think u are assigned wrong values in Minimum Server memory (MB) and Maximum Server Memory(MB).

Regards

Mathew

It is a good Idea

If you create a user and using that user create a database you can remove all other system administrator from your database expect ‘SA’.

Regards

Mathew

I need to use same database from 2 different nodes of cluster. It is same database and same users in both nodes of cluster.

Two clutser nodes access same database same...

Dear All,

I am taking about SQL Server Clustering.

We configured windows cluster with active – passive and sql server installed in the storage. This time users are connect to the...

Dear

My object is , if a table have 10 columns and these 10 columns...

Dear

Thanks for your reply.

I have one field in...

Dear All,

Pls provide any ways to trace Update,Insert and Delete of a specific tables.

Yes, My server have around 60 GB free. So I will keep in one file.

 But my doubts that if...