Administering

• Topics

  Started by

  Posts

  Last post

• how to delete a single publication

  i am unable to delete the publication...it is throwing the error "the publication does not exist" b…

  shanila_minnu

  2 replies

  17 years ago

  By: Eswin

• SQL Srever 2000 authentication problem

  I have SQL Server 2000 installed on a DB server placed on LAN. Authentication mode is set to mixed …

  Atif

  6 replies

  17 years ago

  By: EdVassie

• Data Replication - Central Subscriber

  Hello guys, I need some help with my replication architecture. I really do not know which strategy …

  stelianx

  1 replies

  17 years ago

  By: mat-969817

• Flat File row import

  Hello all I have a flat file that that has a parent row (Customer data) in rows 1,3,5,7... etc and …

  grs

  1 replies

  17 years ago

  By: LutzM

• sql server cluster installation failed...

  Hi, Iam installing sql server 2005 in an active/passive cluster setup. The installation is failing …

  klnsuddu

  2 replies

  17 years ago

  By: klnsuddu

• Reporting Services Sheduled job Failing

  On SqL Server 2005 Std Edition Along with reporting services with sp2 we have more that 50 reports …

  sbvenkatesh77

  3 replies

  17 years ago

  By: Gift Peddie

• Index fragmentation

  I query the avg_fragmentation_in_percent of sys.dm_db_index_physical_stats. One of the index was 8…

  Loner

  10 replies

  17 years ago

  By: Clive Strong

• see this is my view , i want to apply the non clustered index, why because i cant apply the clustered index because there is an aggrigate functions , so i want to minimize this by applying the non clustered index on tables columns , please check the below view and revert back

  SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER VIEW [dbo].[vwOppValue] AS SELECT tblLeadMas…

  SAT_SQL

  16 replies

  17 years ago

  By: Gail Shaw

• not able to connect remote named instance in sqlserver 2005

  Hi i have installed sqlserver 2000 exp edition (default instance )and sqlserver 2005 dev edition as…

  karan457-979314

  1 replies

  17 years ago

  By: abishekshroff

• help on trigger creation

  Hi, is it possible to create a single trigger for multiple tables. 🙂

  SQL*

  3 replies

  17 years ago

  By: SQL*

• No Import/Export option in sqlserver2005

  when i right click on databases then there is not any option of import/export data in allTasks opti…

  harpreetkaur32186

  5 replies

  17 years ago

  By: bob amy

• SP3 installation in clustered environment

  Hi, We are planning to install SP3 in clustered sql server 2005. From the Readfile of SP3: Failove…

  madhu-686862

  6 replies

  17 years ago

  By: Leon . Orlov .

• Clustering\Mirroring endpoint setup

  I want to set up mirroring on a 4 node clustered (A,A,A,P) environment. Im new to clustering and m…

  sjdaless

  1 replies

  17 years ago

  By: sjdaless

• Shared disk on a cluster

  Hi Could anyone tell whether we can use a common shared disk for backup which can be used by the mu…

  SQLBuddy123

  6 replies

  17 years ago

  By: SQLBuddy123

• Problems using db_ddladmin role

  HI, I have a developer who is working in a test environment and I assigned him to the db_ddladmin r…

  Juanita

  2 replies

  17 years ago

  By: Juanita