Administering

• Topics

  Started by

  Posts

  Last post

• Deploying Hotfixes or SP using WSUS

  Fellow DBA's Has anybody used wsus to deploy Sql Server Hot Fixes or Service Packs using WSUS? if s…

  chinn

  13 replies

  14 years ago

  By: avindia

• SQL server Tempdb + SSD

  Hi All, Could you please let me know your comments/advises on the below mail received from my dev t…

  ravisamigo

  7 replies

  14 years ago

  By: Adam Seniuk

• Unable to Transfer .Zip file to the another Server using xp_cmdshell in SQL Job

  [font="Courier New"]Hi Everyone, I have created a batch file which runs on remote server via SQL jo…

  bhushan_juare

  1 replies

  14 years ago

  By: Lowell

• indexes (non-unique,clustered)

  Hi I have a Table (Below) where i need to create indexes (non-unique,clustered) on columns job_id,p…

  Steve Dell

  6 replies

  14 years ago

  By: jaco-1011483

• Reg: Net work related or Instance Specific Error

  Hi In my production server i am using sqlserer 2005 enterprice edition service pack3.op…

  vs.satheesh

  4 replies

  14 years, 1 months ago

  By: vs.satheesh

• installing multiple instance on same IP address and port

  Can i install multiple instance of SQL Server 2008 R2 on same IP Address with same port number say …

  pankaj.kota

  4 replies

  14 years, 1 months ago

  By: pankaj.kota

• Event class in Trace

  Hi IS there a way to display the event Class in text rather than the event id's in the table. Basic…

  sanra001

  5 replies

  14 years, 1 months ago

  By: RobNicholson 27470

• SQL WMI Alert Error 17001 17003 17005

  Hi, I created a WMI alert which actually monitor any DDL event on a database. Like when ever a Data…

  GURSETHI

  12 replies

  14 years, 1 months ago

  By: BudaCli

• Remove/Delete Cluster Resource

  Hi All, Server : SQL 2005 O.S : Windows 2003. This is a Active/Passive Cluster server. I've adde…

  SqlSavy

  1 replies

  14 years, 1 months ago

  By: SqlSavy

• Can we configure logshipping 2005(Enterprise edition) and 2008(Enterprise edition) with standby mode?

  Hello, Can we configure logshipping bitween 2005(Enterprise edition) as primary server and 2008(Ent…

  M@hesh

  1 replies

  14 years, 1 months ago

  By: Gail Shaw

• Altering char to varchar

  Hi, I have inherited 90+ databases. On the front end there are mostly VB6 applications. The norm wa…

  Dennis Post

  3 replies

  14 years, 1 months ago

  By: Orlando Colamatteo

• Instance server

  hello, i have few instance server on my server i want i want to change my default instance to an ot…

  eboucicaut

  4 replies

  14 years, 1 months ago

  By: Steve Jones - SSC Editor

• Problems resetting sql password - database deleted

  I have a sql login which is used by an application on several databases. Some time ago one of the …

  khowlette

  6 replies

  14 years, 1 months ago

  By: jack.rider.rider

• Rerporting server Moving to new domain

  Hello, we have more or less 1500 reports till date and we are moving to new domain in a month or tw…

  durai nagarajan

  10 replies

  14 years, 1 months ago

  By: durai nagarajan

• Select blocked sometimes

  Hi, Sometimes, some action, triggered for someone blocks the database, in other words, querys that …

  denisribeiro

  6 replies

  14 years, 1 months ago

  By: denisribeiro