Administration

• Topics

  Started by

  Posts

  Last post

• xp_cmdshell

  Hi Expertz Can anyone please tell me how to check whether "xp_cmdshell" in enabled in sql server 20…

  Eswin

  3 replies

  17 years ago

  By: george sibbald

• Problem in modifying DNS alias on SQL 2000 cluster

  Hi, we're moving our sql2000 db server to a new server. The source server has SQL2000 active/activ…

  flyme4ual

  1 replies

  17 years ago

  By: EdVassie

• Mimicking partitions in SQL 2000

  Hi everyone, We have an archive table that captures sales and is over 340 million rows on our SQL 2…

  GabyYYZ

  7 replies

  17 years ago

  By: GabyYYZ

• AWE Memory - is the extra memory being used?

  I've come across a SQL Server 2000 box with 6GB of RAM running under Windows 2000 Advanced Server. …

  JamesNZ

  7 replies

  17 years ago

  By: hi_abhay78

• DBCC DBReindex with "Sort In TembDB"

  First and to be sure, this is for an SQL Server 2000 Enterprise Edition. One of the Systems DBA's t…

  Jeff Moden

  5 replies

  17 years ago

  By: Jeff Moden

• Adding /3GB /PAE in Boot.ini?

  Hello, I upgraded the memory from 8GB to 16GB last week and according from Microsoft forum, I add t…

  Leo-696352

  3 replies

  17 years ago

  By: SQLBalls

• SQL Server 2000 - Connecting to a named SQL 200 instance

  Morning I have a Server running SQL Server 2000 SP4 which has both a default and named instance ins…

  Gary Cobden

  5 replies

  17 years ago

  By: george sibbald

• Test your problem solving skills!

  I have already developed a solution to this but I would like to determine if anyone out there has a…

  TravisDBA

  29 replies

  17 years ago

  By: GSquared

• How to send certain datbase error msgs to server log

  Hi All, Whenever we have database errors such as permission issue (new db objects deployed without…

  Kimba

  2 replies

  17 years ago

  By: Kimba

• Access to Profiler

  Hi One of the user needs Profiler access to run the traces.My instance is sqlserver 2000.How can …

  sudarram

  1 replies

  17 years ago

  By: Chand00

• Same replica server, same schema objects but different execution plans.

  Hi All, I was wondering if it is normal to have two replica copies of the same hardware and same sc…

  Dean Jones-454305

  1 replies

  17 years ago

  By: Adi Cohn-120898

• Remote connection issue to sql server 2000

  Hi Expertz. I had to install an sql server 2000 in machine. There was already a sql server 2005 exp…

  Eswin

  5 replies

  17 years ago

  By: Eswin

• Differences between Unicode Text and ASCII text file

  There is an option to script SQL's into Unicode or ASCII text file, but both are generating .sql fi…

  jagadish_sds

  8 replies

  17 years ago

  By: Jeff Moden

• Insufficient Memory???

  Hello Everyone, I have a strange message in my SQL Logs this morning when I checked the daily DB ba…

  Leo-696352

  2 replies

  17 years ago

  By: Carl Federl

• Failed Login trace with little data

  Greetings, I'm trying to track down the source of some failed logins, but my trace isn't showing mu…

  T_Peters

  3 replies

  17 years ago

  By: RBarryYoung