Hi buddy,

The osql-l will give u the listing of sql server whose services are on but doesnt give the server name whose sql services are stopped.

for details i had discussed...

I buddy,

If u want to know how many users are presently connected to ur SQL Server.

The u can know it from a procedure called sp_who2 this will give u the...

Dear ,

I know there are number of counters given in the performance counter window.I need to know where i can find the counter written in my question.

Total Server Memory counter...

Dear,

I download sqliostreee.exe from a website and read the document and in that there it was written that the stress test is basically to check the drives there is no...

Dear Arul,

Related to sql server2000.

from

Killer

Hi Helen,

Did ur restore team restored the Database on the existing database?

Refresh the management consol.Or put the database online.

It must be in single usermode.Get it configured for multi users.

from

Killer

Hi,

Before u kill any process have a look what type of lock that particular table holds.

As ur query have 3 locking effects Intent Exclesive (modifying the data),Exclusive Lock(X) locks the...

Hi,

Also check do the server is running under Fiber mode.If not then enable  light weight pooling.

Set the value to 1.

I am sure that the SQL user is mapped to Domain...

Hi,

Create the linked server then execute the query like this

exec [192.234.5.3].[master].[dbo].[sp_who]

from

Killer

hi,

exec sp_configure

u have to enable permission to update system tables then u can enable light weight pooling

from

killer

Hi ,

Pls check lightweight pooling is enabled.

If it is disabled pls put it on.

HTH

Killer

Hi Lucky,

Thanx for ur reply.

The version of Sql Server is :

Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on...

hi ,

in simple recovery mode u cant shrink the file it should be in full or bulk mode.

Secondly before u run the shrinkfile command run backup log command.

before u do...

Dear Rudy,

U are write one the point but also wrong.

First the checkpoint is issued and then the lazy writter writes the data from buffer cache to the disk.

The reason i...

hi,

are u executing the dbcc checktable command on the right database.

Pls check the database name .

HTH

from

Killer