SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Create new folder and copy file using xp_cmdshell

  Hello All, I have to copy file daily from SQL job to the file server. The SQL job should create a f…

  indinfo2011

  12 replies

  14 years ago

  By: Orlando Colamatteo

• Slipstream SP1 + CU2 - SQL Server 2008 R2 RTM

  I have a few instances where I have installed SQL Server 2008 R2 RTM. I want to apply SP 1 + CU2. I…

  arr.nagaraj

  2 replies

  14 years ago

  By: arr.nagaraj

• How to backup all SSAS databases ?

  We can easily backup one SSAS database by using the management studio , but how to create a job to…

  awu

  3 replies

  14 years ago

  By: Arjun SreeVastsva

• Blocking

  Hi we have SQLServer 2005 in my environment. currently we are facing the issue with blocking. Here…

  Simha24

  4 replies

  14 years ago

  By: salum

• Restricting access to SQL Server instances based on source IP or hostname?

  Is anyone doing this? I am attempting to restrict access per instance (multiple instances per SQL …

  Chris Metzger

  8 replies

  14 years ago

  By: okbangas

• Report for highly used process and queries for a day

  Hi All, Need to create a report for top used processes and queries in same day and send out to admi…

  neeraj.logix

  2 replies

  14 years ago

  By: neeraj.logix

• Policy Based Management SQL 2008 R2

  I am creating a list of policy that need to enforce my environment . One of the security requireme…

  stanley_1982

  2 replies

  14 years ago

  By: Orlando Colamatteo

• Does SQL 2005, 2008, 2008R2 install different files/DLLs based on Intel or AMD processors?

  Hello Everyone, I'm looking at getting an answer to this simple question. When installing SQL 2005,…

  Rudy Panigas

  7 replies

  14 years ago

  By: MysteryJimbo

• Replication Script Question

  I would like to create two scripts, one to create a publication and a second script to create a sub…

  mpdillon

  4 replies

  14 years ago

  By: MysteryJimbo

• Bug in SSMS 2008 R2 SP1

  Ever since I installed 2008 R2, I have been noticing that SSMS crashes sometimes when I go to view/…

  SQL_Surfer

  3 replies

  14 years ago

  By: SQL_Surfer

• Installing 2008 instance on 2005 box

  I want to install an instance of 2008 R2 on my development box that already is running 2005. Any su…

  homebrew01

  3 replies

  14 years ago

  By: EdVassie

• Integrity check works running maually but not from sqlagent

  Hi, I'm using the below procedure IntegrityCheck to check the database Integrity. I'm running the p…

  Mani-584606

  4 replies

  14 years ago

  By: Suresh B.

• SQl Server SSIS Job Monitor

  I am running a SSIS job which contains 10 Data Flow Tasks as a SQL Agent job The job has been runni…

  rka

  2 replies

  14 years ago

  By: Orlando Colamatteo

• What is the "ideal" hardware configuration for SQL Server 2008

  Hey Guys, My company is looking to upgrade to 2008 and purchase new hardware as well. Being that I …

  bdavey

  19 replies

  14 years ago

  By: Keith Hays

• COMPATIBILITY_LEVEL question: Upgraded to 2008 R2... Sort of... or "Is there a tool that will tell me what this upgrade broke?"

  Here's the background: We recently upgraded our DB Servers to SQL 2008 R2, HOWEVER... The COMPATIBI…

  krushkoder

  15 replies

  14 years ago

  By: Orlando Colamatteo