Administration

• Topics

  Started by

  Posts

  Last post

• AWE

  Dear All, We have a Database Server, the environment is Microsoft® Windows Server® 2008 Enterprise …

  ravisamigo

  11 replies

  15 years ago

  By: ravisamigo

• Bring online a database without stand by file

  hi guys, I have lost the standby file of an old database, and I need to bring online that database,…

  @fracionero

  4 replies

  15 years ago

  By: @fracionero

• Moving database from SQLServer 2008(Enterprise edition) to SQLServer 2000(Enterprise edition)?

  Dear All, How to move database from SQLServer 2008(Enterprise edition) to SQLServer 2000(Enterprise…

  ravisamigo

  1 replies

  15 years ago

  By: C.K.Shaiju

• Checkpoint and data/log file timestamps

  I'm running SQL 2000 with simple recovery. I am confused by the timestamps I am seeing on the log …

  Deanie

  2 replies

  15 years ago

  By: Deanie

• SQL TRIGGER.. HOW TO STORE WHERE CONDITION

  Hello Friends, I need your help for enhancement in the TRIGGER which i have scripted for my organiz…

  Ritesh Mehta

  4 replies

  15 years ago

  By: Lowell

• Trigger

  Can I create a SQL2000 TRIGGER that will capture the HOSTNAME of what Triggered my event?

  rew-370421

  3 replies

  15 years ago

  By: Derrick Smith

• distributor_admin login missing for replication

  Hi there, We are currently in the process of moving an SQL instance from one server to another. Whe…

  kangarolf

  5 replies

  15 years ago

  By: Ronzo

• Queries running slow

  Every time I'm trying to run a query it is taking too long to run the simplest query, in order to r…

  tt-615680

  5 replies

  15 years ago

  By: Ninja's_RGR'us

• Scalar valued function compatibility issue.

  I have created a function in SQL server 2005 to return the values without any space, my client syst…

  Ashwin M N

  1 replies

  15 years ago

  By: Lowell

• EventID's 3024, 3018, 3036, 3024, 3019, 4103, 7045 in Event Logs

  Hi All, I have the following error messages in My event logs, not been able to resove the issue. Ca…

  michae1.chapman

  2 replies

  15 years ago

  By: michae1.chapman

• SQL Profiler vs Sys stored procedures

  Hi DBA's I am trying to run a trace on SQL server 2000 named instance using System Sp's (Sp_create…

  dbadotraghu

  9 replies

  15 years ago

  By: Hardy21

• Error while running 2005 upgrade advisor

  Hi, When I am trying to run 2005 upgrade advisor wizard for my sql 2000(devloper edition) its faili…

  MANU-J.

  21 replies

  15 years ago

  By: angelbischoff

• ReIndexing without Log File Growth

  Is there a way to rebuild indexes on a table without the log file growing too big. There is only on…

  The_SQL_DBA

  10 replies

  15 years ago

  By: Apollo74x

• Server slowness

  One of our critical servers started to perform very slow since yesterday. Here is the detail: SQL S…

  ps.

  1 replies

  15 years ago

  By: ps.

• maintaining fragmented tables

  Hello I am not very familiar with the inner workings of SQL. I ran showcontig on our production DB …

  Manny Cruz

  1 replies

  15 years ago

  By: JeremyE