Administering

• Topics

  Started by

  Posts

  Last post

• Enabling Remote DAC

  Hi Seen lots of stuff about how to enable remote DAC, but I can't find anything regarding the impli…

  Green Armchair

  2 replies

  13 years ago

  By: Orlando Colamatteo

• Issue installing SQL Server 2005

  Hi. I am having a problem installing SQL SERVER 2005 on my windows 7 enterprise 32 bit operating sy…

  LastJedi

  4 replies

  13 years ago

  By: lucas_leon88

• Question about server alias

  We currently have two production servers at my company, let's call them DB1 and DB2, each with a ha…

  cphite

  3 replies

  13 years ago

  By: Arjen Krap

• sprocs executed but rolled back? is there any log?

  if a sproc started executing and then the transaction was killed, is there a way to check which spr…

  curious_sqldba

  4 replies

  13 years ago

  By: Bhuvnesh

• How to see one week before job history

  Hello: I have a agent job running. When I right click this job to view history, only show me curren…

  cc 80999

  7 replies

  13 years ago

  By: hcprasadv

• Can i deete default users and windows authenticated user in sql server 2008 ? or apply restrictions

  We need to allow are client to have access on the views only and nothing else regarding create ,del…

  maida_rh

  1 replies

  13 years ago

  By: Bhuvnesh

• Changing the initial size of db file

  I need to shrink database and log files to less than their inital size, thus change the initial siz…

  TDP

  14 replies

  13 years ago

  By: WHug

• CALL PHONE from SQL Stored PROC/ Alerts

  Is there a way to call phone and give automated msg from SQL server; as notification / alert methd;…

  Joe-420121

  19 replies

  13 years ago

  By: henderson.austin

• The replication agent encountered an error and is set to restart within the job step retry interval. See the previous step history message or replication monitor for more information

  Hi, Im new with SQL, please help me on how to trouble shoot this error "The replication agent encou…

  fatinfzi

  1 replies

  13 years ago

  By: fatinfzi

• Replication in sql 2000

  Hi Guys Whereas I did not find my problem here, I am posting the new one. Actually I set up a trans…

  bahador.nasiri

  1 replies

  13 years ago

  By: Chris Becker

• SQL Server Performance Problems

  Hi Guys Occasionally at peak times of the day I get I/O errors on my SQL server (v 2005, 16 core 2.…

  kiffab

  20 replies

  13 years ago

  By: peterdru401

• What is better: single or multiple datafile (mdf) in user database for better performance?

  Hi, I have a user database with 30GB mdf file. The datafile are in a SAN (RAID 5 with four disk). …

  ico-601891

  5 replies

  13 years ago

  By: ico-601891

• Report is not generated, db and services, report server also online, can you give the suggestions pleaseeee it is urgent, it is production issue, pleaseeeeeeee

  Report is not generated, db and services, report server also online, can you give the suggestions p…

  srinivasduddyala1

  1 replies

  13 years ago

  By: Lynn Pettis

• Log file moving

  Hello friends, I have a question that I have a database "Deparment" in my SQL Server 2008r2 environ…

  jitendra.te

  2 replies

  13 years ago

  By: Gail Shaw

• Ntfs error

  Hi, We have 3 node a/a/p cluster setup for SQL Servr 2005 and getting the below error daily at same…

  gary1

  2 replies

  13 years ago

  By: NMHDBA