Administration

• Topics

  Started by

  Posts

  Last post

• 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, 5 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, 5 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, 6 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, 6 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, 6 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, 6 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, 6 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, 6 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, 6 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, 6 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, 6 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, 6 months ago

  By: hemanth.damecharla

• Backup linked server

  Hi, We intend to reformat and reinstall the O/S and SQL server 2000 SP4 in one of our database serv…

  Lanny Irwan

  4 replies

  17 years, 6 months ago

  By: MANU-J.

• Audit DROP DATABASE

  We inadvertantly had 6 DB's DROPPED from a non-prod environment. How can I tell who (or what proce…

  Express12

  1 replies

  17 years, 6 months ago

  By: Gail Shaw

• XML problem- a bugger!

  A user wants me to send them a formatted XML file. The "for xml, auto,elements" seems to create the…

  fizzleme

  1 replies

  17 years, 6 months ago

  By: Matt Miller (4)