Administration

• Topics

  Started by

  Posts

  Last post

• Problems with Microsoft OS Patches, KB890830 and KB950749

  One of our DTS packages was performing fine until our monthly maintenance window in May. The only …

  pharford-sindorf

  2 replies

  17 years, 2 months ago

  By: kcole-825674

• Optimization Job failed????

  Hi, we are using Sql Server 2000 standard edition on windows 2003 enterprise edition. We got the fo…

  Mani-584606

  6 replies

  17 years, 2 months ago

  By: Mani-584606

• DBCC DBREINDEX/IDEXDEFRAG and Transaction Log

  Hi all, this is the scenario (I apologize for the length of that story, but I'd like to be detailed…

  stryk

  3 replies

  17 years, 2 months ago

  By: stryk

• Email for Jobs is greyed out on sql server 2000 -SP3 for my users

  I've given access to my users to able to run , edit jobs on the sql server agent. This all works f…

  altafhahmed

  2 replies

  17 years, 2 months ago

  By: altafhahmed

• XML Returning Large Result Set Taking unmanageable time

  Hi, I have been facing a strange problem in nmy ssis package since last week. The package has a dat…

  qhjghz

  2 replies

  17 years, 2 months ago

  By: qhjghz

• dbcc sqlperf(waitstats)

  MISCELLANEOUS5199.00.00.0 LCK_M_SCH_S5.029969.00.0 LCK_M_SCH_M2.01765.00.0 LCK_M_S201.06…

  SQL Galaxy

  2 replies

  17 years, 2 months ago

  By: SQL Galaxy

• current sessions in database

  hi, How do find current sessions in database access through sql server 2000? not in sql profiler. t…

  SQL Galaxy

  2 replies

  17 years, 2 months ago

  By: ps.

• Unable to bring the database from read_only to read_write

  Hi, I have database in readonly mode.I need to bring it to readwrite mode and take the backup. I al…

  AAkula

  3 replies

  17 years, 2 months ago

  By: george sibbald

• OS upgradation from 2000 to 2003

  HI I am having windows 2000 server with sql 2000.Now I am planning to upgrade the os to 2003.whethe…

  binu.m a

  1 replies

  17 years, 2 months ago

  By: Steve Jones - SSC Editor

• sql server 2000 Query analyzer

  Hi I've used this product (version 6.5, 7, 2000 and 2005) for years and never encountered this issu…

  nikhil.verma

  2 replies

  17 years, 2 months ago

  By: Steve Jones - SSC Editor

• database size growing

  Hi, I have notice that one of the our sql 2000 production server database size is increasing daily,…

  SQL Galaxy

  4 replies

  17 years, 2 months ago

  By: MANU-J.

• Latest SQL Server vunerability sp_replwritetovarbin

  The latest vunerability released today for SQL Server says to disable this SP... question is now an…

  Anonymous

  2 replies

  17 years, 2 months ago

  By: Anonymous

• Question: Is there a way to capture when a Database Auto-grows

  Hi there, Is there a way to capture/log when the database performs an auto grow command in SQL Serv…

  Brian Munier

  7 replies

  17 years, 2 months ago

  By: Brian Munier

• Log file is in Use

  Hi. I have taken a database backup from production and restored it in Dev server.The database size …

  Bilichi

  2 replies

  17 years, 2 months ago

  By: Gail Shaw

• Grant Alter View,Proc Permission without being a DDLAdmin

  I want to give users the ability to create views and procs and alter them but not alter the DB. I …

  AVB

  4 replies

  17 years, 2 months ago

  By: hemanth.damecharla