Administration

• Topics

  Started by

  Posts

  Last post

• DB Availability

  Hi All, How to check the db availability without access any tables in the database. Are any system …

  karthikeyan-146504

  4 replies

  16 years, 8 months ago

  By: Gail Shaw

• Release the allocated space in sql server 2000 database

  Hi, Can anyone help me out in releasing the unused space of the MDF file in SQL Server 2000 databas…

  tilakat

  1 replies

  16 years, 8 months ago

  By: Renuka__

• sqlserver 2000 instances

  Hi , 1) i would like to know for sqlserver 2000 EE how many instances we can create. 2) in my serv…

  karan457-979314

  2 replies

  16 years, 8 months ago

  By: karan457-979314

• "Timeout expired. The timeout period elapsed prior to

  Hello Guys, I am experiencing following SQL error frequently on production server 2000 but we are u…

  anurag.sharma

  5 replies

  16 years, 8 months ago

  By: Florian Reischl

• Timeout expired......Net SQL Client Data Provider ConnectionRead(WrapperRead())."

  Hello Guys, We are experiencing following SQL error frequently on production server 2000 but we a…

  anurag.sharma

  14 replies

  16 years, 8 months ago

  By: anurag.sharma

• Script needed - to create a subdirectory using a database name

  I want to schedule a job to create subdirectories named by the user database names under K:\myfile.…

  Vivien Xing

  9 replies

  16 years, 8 months ago

  By: Robert Davis

• Some User Databases gone suspect during SQL Server 2000 Service account change

  While replacing the SQL Server Service account with new Windows Domain account getting the below er…

  sivaprasad

  2 replies

  16 years, 8 months ago

  By: sivaprasad

• Find size of the device or the backup file

  Hi, I have got 3 servers. 1 live ,1 hot, 1 cold Every 15 mins a job is made that the transaction lo…

  HBhagat

  3 replies

  16 years, 8 months ago

  By: HBhagat

• Case sensitive database instance

  Hi All, Just noticed on an instance of a customer database, I have noticed that objects (databases …

  Dean Jones-454305

  1 replies

  16 years, 8 months ago

  By: MarkusB

• FCB::Open: Operating system error 3(The system cannot find the path specified.) occurred while creating or opening file 'E:\DATA\xxx\xxxxx.mdf'. Diagnose and correct the operating system error, and retry the operation

  Can some one help me in finding the route cause of the issue and the solution for the below error F…

  nagendrareddy.kolli

  3 replies

  16 years, 8 months ago

  By: Gail Shaw

• FCB::Open: Operating system error 3(The system cannot find the path specified.) occurred while creating or opening file 'E:\DATA\xxx\xxxxx.mdf'. Diagnose and correct the operating system error, and retry the operation

  Can some one help me in finding the route cause of the issue and the solution for the below error F…

  nagendrareddy.kolli

  1 replies

  16 years, 8 months ago

  By: Gail Shaw

• Buffer Cache Hit Ratio

  How can I see Buffer Cache Hit Ratio ?

  Krasavita

  1 replies

  16 years, 8 months ago

  By: george sibbald

• Does DBCC DBReindex automatically update statistics?

  Does DBCC DBReindex automatically update statistics? I'm running DBCC DBReindex for each table in t…

  Express12

  5 replies

  16 years, 8 months ago

  By: Wayne West

• White space in the table

  I was told that the database have lots of white space in the table and I need to clean it. Why is i…

  Krasavita

  4 replies

  16 years, 8 months ago

  By: Krasavita

• Running out of memory

  Can some one tell me what tools can I use to monitor if the drive is running of out space for leavi…

  Krasavita

  5 replies

  16 years, 8 months ago

  By: Steve Jones - SSC Editor