SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• How to ping a SQL Server datbase?

  i have 30 databases in 5 iInstances. (2 are sql server 2000 and 3 are sql server 2005) i want to pi…

  theunique1011

  1 replies

  14 years, 8 months ago

  By: LutzM

• Migration Strategy for my environment

  We are planning to migrate from SQL 2k5 to SQL 2k8. We have three databases in each of our three sq…

  sql_butterfly

  6 replies

  14 years, 8 months ago

  By: Marios Philippopoulos

• Connection pooling troubleshooting in SQL 2008, client unable to reuse a session with SPID...

  Hi folks, we have recently moved four SQL 2000 servers to three SQL 2008 servers. These are server…

  GabyYYZ

  7 replies

  14 years, 8 months ago

  By: Caruncles

• Transaction Replication

  HI All Below is a Production Server Issue: 1.Due to some reason , the transational replication set…

  koustav_1982

  1 replies

  14 years, 8 months ago

  By: koustav_1982

• Top Wait stats

  Hi friends, I collected Top wait stats as follows, if clear these waits stats by using DBCC SQLPERF…

  SQL Galaxy

  3 replies

  14 years, 8 months ago

  By: mazzz

• SCHEMA ISSUE

  Hi All, I took the backup in sqlserver 2000 database and restore into sqlserver 2008. Then created …

  balaji.ganga 68339

  3 replies

  14 years, 8 months ago

  By: balaji.ganga 68339

• Says invalid object name after renaming proc..

  I have a proc in my sql server 2005 db which was accidentally renamed by pressing F2 on sql object …

  NewBeeSQL

  25 replies

  14 years, 8 months ago

  By: Evil Kraig F

• Error using the wizard to copy SQL 2005 db's to fresh sql 2008 instance

  ALL, INFO - I've got a brand new server and am trying to figure out the best way to switch to this …

  MyDoggieJessie

  3 replies

  14 years, 8 months ago

  By: UMG Developer

• Performance Problem running Nav5.0SP1 on SQL2k8R2

  Hello, we have a performance issue with our Nav6.0SP1 Database Server. After installing two new Ser…

  michael.seifert

  1 replies

  14 years, 8 months ago

  By: danschl

• Duplicate a "model" database

  Sql 2008 R2 Enterprise 64 bit, no true DBA, my access = sa The situation is that we have a web appl…

  Mad Myche

  4 replies

  14 years, 8 months ago

  By: Mad Myche

• Database I/O and Activity Monitor

  Hi ALL, When I open up the Activity Monitor I see spikes in the Database I/O every 20 seconds. Wha…

  suri.yalamanchili

  1 replies

  14 years, 8 months ago

  By: MyDoggieJessie

• SQL Server Testing

  Hello All, I'm looking a tool which will help me test configuration changes that I make at an O/s l…

  Gingkoo

  1 replies

  14 years, 8 months ago

  By: Yelena Varshal

• add identity to existing primary key column

  hi folks, can any one help in adding identity to existing primary key column and that key is referr…

  AK1516

  1 replies

  14 years, 8 months ago

  By: ChazMan

• SQL Server 2008 R2 can't modify Management Plan

  I just performed two SQL Server 2008 R2 installations. The servers are both running Windows Server…

  gary.dunn

  5 replies

  14 years, 8 months ago

  By: M&M

• sys.dm_tran_locks query gets hung - what could be the cause?

  I'm in the process of troubleshooting a blocking issue on a production server. However, the followi…

  Marios Philippopoulos

  1 replies

  14 years, 8 months ago

  By: danschl