Administration

• Topics

  Started by

  Posts

  Last post

• Recovering Suspected database

  I have a situation where in a production database has been marked suspected by the SQL server. I ha…

  baba2207

  3 replies

  22 years ago

  By: Steve

• Stored Procedure fails on shared server

  I have a stored procedure which runs on my computer but fails to bring up related fields on my shar…

  gbeasley

  4 replies

  22 years ago

  By: gbeasley

• Moving tables from one SQL server to another

  Hello all, I have a question and wondering if anyone here can help. I have a database that I have d…

  gaaq

  8 replies

  22 years ago

  By: gaaq

• Database Scripting Issues

  I need to fix a database which someone has inadvertently messed up. I cannot fix the one with the e…

  e_h2324

  5 replies

  22 years ago

  By: e_h2324

• sp_resetstatus

  tried to sp_resetstatus ' dbname' and then restart sql services ? JV JV

  jvElecenter

  1 replies

  22 years ago

  By: Allen Cui-55137

• Use of Cursors

  Can someone tell me or direct me to a good article on why one should not use cursors in stored proc…

  loperp

  9 replies

  22 years ago

  By: Chris Hedgate

• Filegroup Change

  How to change the filegroup of a table through TSQL, when table does not have an index on it? A scr…

  dipak_padhy

  3 replies

  22 years ago

  By: Frank Kalis

• Usage Memory in SQL

  Hello!!! I had one SQL Server 2k with Windows Server 2k and in the last two days a go they started …

  hgranja

  2 replies

  22 years ago

  By: hgranja

• Volumes, disks and indexes

  I have an interesting dilemma. Let us say I have a fixed number of disks attached to my SQL Server.…

  sxg6023

  2 replies

  22 years ago

  By: colin.Leversuch-Roberts

• Help recovering database!!!

  I received this message in SQL logs: SQL Server detected a DTC in-doubt transaction with UOW {3692…

  kbbass

  1 replies

  22 years ago

  By: kbbass

• Filegroups and MSDE

  Can someone explain the benefits of splitting my MSDE database across two filegroups? Our server h…

  karenlopez

  6 replies

  22 years ago

  By: jxflagg

• Why does "Space Availalbe" option show 0MB?

  Hi, All I have a q for U. One of my database shows 0MB space available in the General tab even thou…

  GivThx

  8 replies

  22 years ago

  By: caneja

• Alert: Unauthorized use Flow

  Hello All, I am trying to detect any unauthorized attempts via either Web or QA. I've been using al…

  barsuk

  1 replies

  22 years ago

  By: barsuk

• Moving databases to new development box

  I recently setup a new dev box and installed SQL Server 2000. I thought I would have to run sp_atta…

  unclebaby

  3 replies

  22 years ago

  By: Steve Jones - SSC Editor

• DBA Operations Manual

  Hello all, Does anyone happen to have a DBA Operations Manual or Run Book that you are willing to s…

  dgbrown

  3 replies

  22 years ago

  By: dgbrown