SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• migrating 2008 db to a new host, but there's a catch...

  I have a client I'm doing some work for and they asked me if I could help migrate a db from one hos…

  p63436

  2 replies

  14 years ago

  By: Grant Fritchey

• Scrambling data which has no constraints

  Hi, I would like to scramble two tables( Table A and Table B) for ID columns, which doesn't ha…

  DBA_Learner

  2 replies

  14 years ago

  By: Jeff Moden

• Disk Space Notification

  Hi How can i setup a SQL mail notification when my Database server Disk space is full or near to fu…

  alnawrass2002

  29 replies

  14 years ago

  By: Ant-Green

• Want to start the career path to DBA, suggestions needed.

  Hi everyone, After graduating college and working for about 2 years, I've decided that I wanted to …

  andychurry

  4 replies

  14 years ago

  By: andychurry

• Methods to Restore DB to multiple DB's

  I have a sql server 08 R2 express edition and as per the edition, it supports upto 10GB of database…

  DBA_Learner

  5 replies

  14 years ago

  By: DBA_Learner

• delete .ldf files

  Hi, There are 3 log files(.ldf) in the database. I want to make them into one log file. Could some …

  charipg

  6 replies

  14 years ago

  By: Perry Whittle

• SQL Server 2008 is very slow

  I am running the same SSIS package on both the servers and was very confused that why the server ha…

  balbirsinghsodhi

  2 replies

  14 years ago

  By: Johan Bijnens

• SQL Sevrer Alert Based On Severity Level Not Working

  Hi all. I am new to SQL Server alerts, and I am trying to setup an alert based on the severity leve…

  yoelhalb

  4 replies

  14 years ago

  By: yoelhalb

• Logical File Appears After 2005 To 2008 R2 DB Restore

  Has anyone experienced this: I migrated a database from SQL 2005 SP3 to SQL 2008 R2 SP1. In 2005, t…

  shaun.stuart

  9 replies

  14 years ago

  By: shaun.stuart

• Copy Maintenance Plans from server to server?

  Is there a way to script or copy maintenance plans? I need to setup plans on servers. I need to sy…

  ntcnet

  1 replies

  14 years ago

  By: Ant-Green

• Unable to Linked Server

  Hi All I am using SQL Server Database 2008 and I want to create a linked server and link it to Micr…

  muzokh

  7 replies

  14 years ago

  By: Ant-Green

• Connection Timeout with Named Pipes

  Setup: SQL 2008 R2 Express SP1 on Windows 7 Firewall enabled with exceptions for the following: UD…

  Kim Killian-SiteDataView

  8 replies

  14 years ago

  By: Steve Jones - SSC Editor

• Trying to reproduce production SQL performance issue on dev server and failing...

  I am trying to troubleshoot a performance issue that is happening on our production SQL-2008 server…

  Marios Philippopoulos

  30 replies

  14 years ago

  By: Ninja's_RGR'us

• How can I find out if I have 64- or 32-bit Reporting Services installed?

  Hi, I have SSRS 2008 (SP2) installed on a Windows Server 2008, but I am not sure if I have SSRS 32-…

  mphilippopoulos

  17 replies

  14 years ago

  By: SQLRNNR

• How to not show results of queries that return zero records

  My client has a SQL Server 2008 R2 instance with an accounting package that is using a third party …

  tmummert

  2 replies

  14 years ago

  By: tmummert