sntiwary | SQLServerCentral

sntiwary

Forum Replies Created

Viewing 11 posts - 31 through 41 (of 41 total)

RE: Databse restore problem if one of the middle transaction log backup file get deleted?

I have all the Transaction log backup files till 6 am except the one file of at 2:30 AM.
-sntiwary

March 22, 2004 at 7:53 am

#499756
RE: How to configure MOM for monitoring Sqlserver ?

Hi Steve,
Thanks for the information. Actually I am looking for information or examples more related to setup processing rules to capture different type of events and generating alerts. Please let me know...

March 9, 2004 at 10:13 am

#498009
RE: Suspect databases

This is the error :

17052 : Device activation error. The physical file name 'D:\MSSQL\Data\store_Data.MDF' may be incorrect.
17204 : FCB:

February 14, 2004 at 9:59 am

#494092

RE: Errorlog grows quickly

Thanks a lot for your information. Sqlserver has already SP3. I have mentioned the information asked by you.

Windows 2003 Enterprise Edition (windows version 5.2)

SQL Server 2000 Enterprise Edition with SP3 (8.00.811)

Yes,it...

January 20, 2004 at 8:15 pm

RE: Sqlserver not using all the processor

quote:
version is 8.00.760(SP3)

December 9, 2003 at 2:59 am

RE: Sqlserver not using all the processor

quote:
All the CPU's are selected for parallel execution.
cheers
sntiwary

December 9, 2003 at 2:20 am

RE: Sqlserver not using all the processor

This is the result of Sp_configure:

affinity mask-2147483648214748364700

allow updates0100

awe enabled0100

c2 audit mode0100

cost threshold for parallelism03276755

Cross DB Ownership Chaining0100

cursor threshold-12147483647-1-1

default full-text language0214748364710331033

default language0999900

fill factor (%)010000

index create memory (KB)704214748364700

lightweight pooling0100

locks5000214748364700

max degree of parallelism03200

max...

December 9, 2003 at 2:16 am

RE: Connecting remote sqlserver 2K via EM problem

Using the same login for both and connection is ok.

-sntiwary

October 13, 2003 at 7:36 am

RE: How to restrict databases in Enterprise manager?

quote:
Suppose client wants to connect to a server using his EM by registering the server with his userid which has only access...

September 24, 2003 at 7:20 am

RE: Restore large number of database on a server.

Thanks for your reply.

September 24, 2003 at 1:22 am

RE: Replication of data

thanks for ur reply

But can we make sql script for replication.

tiwary

May 24, 2002 at 3:59 am

Viewing 11 posts - 31 through 41 (of 41 total)