Administering

• Topics

  Started by

  Posts

  Last post

• SQL Configuration Manager Problem

  hello all. i have sql server enterprise 2005 on cluster server. my windows user is sysadmin on the …

  mobasha

  12 replies

  11 years ago

  By: SanjeevBaranwal

• Installing Mirroring on database that are already log shipping.

  Hello, I hope someone can offer a little insight. I have read an article that outlines how to put l…

  Duran

  2 replies

  11 years ago

  By: Duran

• how can i pass multiple instance names( multiple server names) in SQLCMD

  Hi, I need to use multiple server names in sqlcmd on command prompt In my batch file i am using the…

  kommagoni

  1 replies

  11 years ago

  By: Jack Corbett

• Becoming a DBA inSQL

  Hi - For the last year and a half I have been working as a QA analyst in a company. However I am no…

  print_mug

  4 replies

  11 years ago

  By: Alan Burstein

• 2005 msdb..backupset table still large after data purge

  Hi all, So I've found a instance with a nice 5gb msdb, most of it was from backupset. After runnin…

  Staggerlee

  5 replies

  11 years ago

  By: srikantmeister

• fragmented indexes cause TEMPDB growth?

  If there is fragmentation in some of the indexes being used in a multi-table join query, would that…

  sqlenforcer

  3 replies

  11 years ago

  By: srikantmeister

• Add computer name as a login in sql server

  Hi All, I have very strange request from my application team and they want to add the server name a…

  Nimesh T Mathews

  5 replies

  11 years ago

  By: antikillerpc2014

• Can default and named instance of sql server have same port number?

  Hi! I want to know by default sql server runs on port 1433.So, if the server has default and named …

  PJ_SQL

  3 replies

  11 years ago

  By: Eirikur Eiriksson

• Database in 'Recovery Pending' State -Error 945

  From a wise member: "Recovery pending means that for some reason SQL cannot run restart recovery on…

  Vertigo44

  35 replies

  11 years ago

  By: Brandie Tarvin

• Unable to cast COM object of type ‘System.__ComObject’ to interface type

  Good morning, On our SQL Server 2005 box when someone is connecting to the SQL Server Management S…

  TSQL Tryer

  5 replies

  11 years ago

  By: TSQL Tryer

• Re-Indexing a large table

  I need to reorg/rebuild the indexes on a large table (8.7 billion rows of data), should I rebuild t…

  ReamerXXVI

  6 replies

  11 years ago

  By: Jeff Moden

• Log Shipping Secondary Server Restore problem

  Hello, I'm having some problems with Log Shipping. I've made it work normally. The problem happens …

  George Silva

  32 replies

  11 years ago

  By: abhishekreddy62

• creating How do i create Temp table with declarations<!-- 864 -->

  I finally got it to work so basically what i was trying to do example is to change one column to a …

  suriaho

  6 replies

  11 years ago

  By: Sean Lange

• Indexing Question

  My MailingAddress table currently has a Non Clustered index on the ProcessID column. Using a Missi…

  GBeezy

  3 replies

  11 years ago

  By: Jack Corbett

• Automate SQL server restart in a clustered environment

  All, I need to automate SQL server restart(daily due to performance issue- outside sql) in a cluste…

  SQL!$@w$0ME

  5 replies

  11 years ago

  By: SQL!$@w$0ME