Administration

• Topics

  Started by

  Posts

  Last post

• CREATE DATABASE Adds extra backslash to Data File Path

  Hello  All - I have a strange problem that is causing headaches with our backup software (Bac…

  Ben Blum

  9 replies

  19 years ago

  By: btio_3000

• DBREINDEX

  Hi,    I have a number of Databases on the same server, each with 20/30 Indexes, dif…

  Colin Betteley

  5 replies

  19 years ago

  By: JeremyE

• Size of Table

  How to identify and restrict size of a table in db?

  Shah_hs

  2 replies

  19 years ago

  By: Jeff Moden

• DBCC Reindex Question

  Hi, Can anyone let me know if DBCC Reidex update stats? Thanks  

  pinky

  9 replies

  19 years ago

  By: shrikant-279400

• Copy everything from an old SQL server to a new SQL server

  Hi everybody, We are trying to copy everything including all databases, logins, jobs and DTS's from…

  SGUO

  5 replies

  19 years ago

  By: SGUO

• Problem with linked server to MS Access

  I'm getting Error 7399 OLE DB provider 'Microsoft.JET.OLEDB.4.0' reported error. OLE DB error trace…

  swede

  4 replies

  19 years ago

  By: swede

• Procedure/steps to update one table if another is changed

  Have two tables table1 name ssid location network table2 name ssid location network firstname last…

  mngong

  1 replies

  19 years ago

  By: Ian Cook

• resolving blocking automatically

  is it possible to automatically identify a block situation and kill one of the spids after a certai…

  sqlstar2011

  3 replies

  19 years ago

  By: mikedotnet

• Setting up Transactional Replication

  I am planning to setup transactional replication and would need suggestions as this is the first ti…

  pinky

  1 replies

  19 years ago

  By: Michael Earl-395764

• Log Sequence no

  Hi gang i would like to know when the lsn no  changes in a sql 2000 database.I know it changes…

  Low Rider

  1 replies

  19 years ago

  By: shrikant-279400

• Turning Log Shipping Back on with no issues

  I have a situation where I need to do the following - Take the destination server out of warm stand…

  Shark Energy

  6 replies

  19 years ago

  By: george sibbald

• XP_Cmdshell list of files

  Hello I am attempting to list all of the files in a specific directory using xp_cmd shell EXEC mast…

  Fishbarnriots

  2 replies

  19 years ago

  By: Fishbarnriots

• Troubleshoot Error 701 on SQL 2k

  Hi Folks I am trying to troubleshoot Error 701 ; it occurs when i try to backup logs. Can please so…

  fssherwani

  1 replies

  19 years ago

  By: John Rowan

• Database Health

  Hi everyone,         I need to monitor the health of  74plus dat…

  coenzyme77

  2 replies

  19 years ago

  By: David Scotland-132255

• Users getting timeouts

  Hi, we have two separate database servers and a web server.  Users or processes are recei…

  Dana Bibeault

  7 replies

  19 years ago

  By: Omri Bahat-433962