Administration

• Topics

  Started by

  Posts

  Last post

• transaction Log space of temdb is 700MB and grows up. What does this mean?

  Our sqlserver from our website is running very slow. From time to time we have timeouts in sqlstate…

  MarkusHearing

  3 replies

  22 years ago

  By: devereauxj

• Msg 18204 ... Cannot find the file specified

  Hi All, I am running SQL Server 2000 (SP3a) on Win 2003 and have created Maint. plans to backup dat…

  Bidec

  2 replies

  22 years ago

  By: Bidec

• Move system tables to a new filegroup

  Hi all, Could you help me move the system tables to a new filegroup? Otherwise, I have to move all&…

  chefi

  2 replies

  22 years ago

  By: chefi

• single file in secondary filegroup cannot be removed ???

  DBCC SHRINKFILE     ( ALZDBA_Data_ObjectsDD20031130 , EMPTYFILE ) --DBCC execut…

  Johan Bijnens

  2 replies

  22 years ago

  By: Johan Bijnens

• Inconsistent performance using sprocs

  I am currently testing putting some long running reports which would have the same execution plan o…

  cortec

  7 replies

  22 years ago

  By: Antares686

• Disable trigger without using ALTER Table

  Hi to all... I need to disable a trigger in my database of a table that it is published by a transa…

  Rodrigo Acosta

  1 replies

  22 years ago

  By: gljjr

• Failed Database Copy Wizard Problem

  I am copying a Database on SQL 7.0 on Win NT 4.0 Server to SQL 2000 on Windows 2000 Server. The log…

  eletuw

  3 replies

  22 years ago

  By: Katya-130420

• Cannot Edit or Delete Job

  Hello, I have a problem with EM and the msdb. I get an error message 14274 when I try to edit …

  cdun2

  5 replies

  22 years ago

  By: cdun2

• Make DB Suspect

  For testing purposes, how do I make a database 'suspect'? Thank you!

  wmp789

  4 replies

  22 years ago

  By: wmp789

• Installing SQL Server 7.0

  I am trying to install SQL Server 7.0 on NT4 with SP6a. The install runs until it tries to attach t…

  Keith Howell

  7 replies

  22 years ago

  By: Katya-130420

• Can a SQL Server 7 DB be Attached into SQL Server 2000?

  My NT administrator is performing an in-line upgrade from NT 4.0 to Win2K.  I was then going t…

  DarylAndDaryl

  7 replies

  22 years ago

  By: Anonymous

• File Transfer Strangeness

  Ok here's the deal: We have a set of maintenance plans that include within them database and transa…

  Mat Elkington-143276

  2 replies

  22 years ago

  By: Mat Elkington-143276

• Microsoft SQL-DMO (ODBC SQL State 42000)

  Hi, I get an error-- Microsoft SQL-DMO (ODBC SQL State 42000) --- while restoring the complete back…

  Naveen Mehta

  4 replies

  22 years ago

  By: Derrick Leggett

• osql from batch file

  Hello all, I am running the following osql from a Windows 2000 cmd batch file: osql -E -S %2 -d msd…

  Jonathan Matt

  1 replies

  22 years ago

  By: Mike Good

• messed up a system stored proc (changed type)

  Hello, Well I did a big no-no.  While trying to specify a LARGE subset_filterclause for merge …

  Christopher Klein

  3 replies

  22 years ago

  By: hoo-t