Administering

• Topics

  Started by

  Posts

  Last post

• Moving databases from one server to another

  Hi , Can anyone tell what problems might occurs when I need to move all production  databases …

  Chami Rstnayake

  3 replies

  21 years, 11 months ago

  By: sharrell

• Backup DB with . in the title.

  Hi, I have a job running on my SQL Server to backup all the databases on a nightly basis. The scrip…

  ta_holder

  2 replies

  21 years, 11 months ago

  By: ta_holder

• Yukon KIT

  Can any body tell me. Where can I download the beta version of SQL SErver 2005(Yukon).

  aiyerganapas

  1 replies

  21 years, 11 months ago

  By: rajkumar_rs

• Space available 1644MB

  In EM it shows that: Size:  5036MB Space available:  1644MB Even if click on Shrink datab…

  JMI

  1 replies

  21 years, 12 months ago

  By: billkamp

• Connection Problem

  I have not been administering for awhile so I am having some memory lapses. I am trying to connect …

  Cheryl Wallace

  2 replies

  22 years ago

  By: Cheryl Wallace

• HELP RESTORE DROPPED TABLE!!!

  I HAVE JUST INADVERTENTLY DROPPED A MAJOR TABLE WITHOUT BACKING UP MY DATABASE. I HAVE LOST 10 DAYS…

  Gannonator

  9 replies

  22 years ago

  By: DanaH1976

• Import Oracle Data into SQL 2000

  Hi, I need to import data from a file generated by Oracle Full DB Export utility. Can I use&nb…

  Madhavi Joshi

  1 replies

  22 years ago

  By: vision59

• Transaction Log

  I am new to SQL administration.  I have a Transaction log that has grown to over 34 GB.  …

  Shelley Allen

  8 replies

  22 years ago

  By: Shelley Allen

• DBCC ShrinkFile

  Hi everyone... I´m trying to compact my log database file using dbcc shrinkfile but nothin hap…

  Eduardo-135196

  2 replies

  22 years ago

  By: Eduardo-135196

• Select Statement Returning the first 50 Records

  Can somebody please give me the correct syntax to return the first 50 records using a SELECT Statem…

  dbatele

  2 replies

  22 years ago

  By: Fallen Angel

• Attaching to a database .MDF file on a mapped drive

  We need to access about 300 Giga bytes of data from a database on a remote server. We have SQL Serv…

  kwitzell

  2 replies

  22 years ago

  By: kwitzell

• problems sending emails from SQL Server

  HI, I have set up a mail profile (Outlook which is the default profile) for SQL server Agent. when …

  Behar Haziri

  9 replies

  22 years ago

  By: philcart

• Question about MSDTC

  I have a client that is using two stand-alone servers (not in a domain).  One is an applicatio…

  Steve Croll

  1 replies

  22 years ago

  By: Nicholas Cain

• how to backp or copy my stored procedures to another server

  Hi all I have  about 68 SP's created need to transfer to  a new sql server  ; associ…

  Chami Rstnayake

  3 replies

  22 years ago

  By: DanaH1976

• Making a Dedicated SQL 2000 server

  Hi all My company have  a requirement to Create  a one dedicated sql server me being …

  Chami Rstnayake

  3 replies

  22 years ago

  By: gdefi