Administering

• Topics

  Started by

  Posts

  Last post

• Service Packs

  Hi All, We have installed SQL Server 2005 with SP2, later some time upgraded it to SP3, then applic…

  Raghavender Chavva

  2 replies

  15 years ago

  By: Anonymous

• Adding new tables to existing Replication

  Hi Experts, Can anyone please guide how to add new tables to an existing replication?? TIA

  VastSQL

  1 replies

  15 years ago

  By: happycat59

• Unable to open Management Studio after upgrade from Workgroup to Enterprise

  Unable to open Management Studio after upgrade from Workgroup to Enterprise We upgraded from SQL Se…

  Phil-475076

  1 replies

  15 years ago

  By: Phil-475076

• Script to generate only constraints

  Hi, Does anyone know how to script only constraints ( pk, fk, defaults ) and indexes only…

  Nikita-395727

  5 replies

  15 years ago

  By: WayneS

• configure log shipping between 2 sql servers stand alone

  Hi, I am trying to configure log shipping between two standalone servers (they are no joined to a d…

  csalazar-607991

  1 replies

  15 years ago

  By: SQLRNNR

• Upgrade MDAC

  I need to upgrade MDAC from Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413…

  Krasavita

  1 replies

  15 years ago

  By: David Benoit

• Need help with SQL Browser and Non-Std Port for Default Instance

  I have a Server 2003 R2 SQL Server 2005 SP3 CU 11 Default Instance Enabled Protocols: TCP/IP Remote…

  Hawkeye_DBA

  14 replies

  15 years ago

  By: Hawkeye_DBA

• slow performance in sql server 2005

  Dear Sir, I am working in Sql Server 2005 Enterprises Edition And I am dealing billion of data at p…

  deba_20032004

  3 replies

  15 years ago

  By: Jim Murphy

• table is slow

  When I poen a table is very slow, what I should? how can I check why and fix the problem?

  Krasavita

  15 replies

  15 years ago

  By: maroon-78

• same data/schema/indexes/statistics - different execution timings?

  I am so lost here. I dont know what to do. I have a table1 inside a db1, the view using table1 comp…

  curious_sqldba

  10 replies

  15 years ago

  By: sreedharan.surendran

• Trigger is causing a lock in a system

  Trigger is causing a lock in a system. I have a table which have trigger to call stored procedure, …

  Krasavita

  3 replies

  15 years ago

  By: Krasavita

• Sql server 2005 Mdf File Shrinking on Windows environment

  Hi All, I am newbie in MSSql 2005 and trying To shrink my mdf file. Currently Total mdf size is 43G…

  pradies

  4 replies

  15 years ago

  By: pradies

• Shrink 1TB SQL 2K - how long should it take?

  I have a 1TB database that I've been shrinking for over 15 hours. I'm wondering if it really is wo…

  jnichols-797753

  9 replies

  15 years ago

  By: MG-148046

• Record containing minimum value where there is overlap

  Hi, I am after the best records from a dataset that will contain overlaps and changes. I guess the…

  jkeys-972541

  1 replies

  15 years ago

  By: spaghettidba

• Application Slow

  Dear All, My management asked me to prepare the document on performance tuning. Please advice what …

  ravisamigo

  1 replies

  15 years ago

  By: Gail Shaw