SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• How to search for replication information messages e.g "The initial snapshot for publication is not yet available."

  I have been working a lot with replication the last few weeks. The replications I was working on ar…

  DennisPost

  4 replies

  11 years, 6 months ago

  By: DennisPost

• Procedure execution count\Time

  Hi Experts, When I ran the below script , I got result of around 1700 rows and when I removed the w…

  VastSQL

  3 replies

  11 years, 6 months ago

  By: Gail Shaw

• Object already exists, but can't drop it!

  Hi All, My client has just started getting a problem with their SQL server. All of a sudden many …

  ty 54262

  16 replies

  11 years, 6 months ago

  By: Brandie Tarvin

• sql 2008 Extended Events help

  Hi Guys, ive just recently joined the forum and wanted some helpwith Extended Events in SQL 2008, t…

  evolves40

  1 replies

  11 years, 6 months ago

  By: Grant Fritchey

• error 824 severity 24 state 2 trying to attach database

  Got this trying to restore a DB from archive. What are my options? You can ignore the part about th…

  sqldriver

  4 replies

  11 years, 6 months ago

  By: sqldriver

• User can only see default schema in a Database (dbo)

  I encountered a unusual situation where a user can only see default schema in a Database. She is a …

  Welsh Corgi

  2 replies

  11 years, 6 months ago

  By: Welsh Corgi

• SSRS 2008 R2

  I have created reports in SSRS 2008 R2 and i created data-source with remote server database (datab…

  sri2015

  5 replies

  11 years, 6 months ago

  By: David Burrows

• 1 Server multiple instances or 1 instance or even Multiple servers?

  I am a new DBA working for a charity and I have project to consolidate the multiple databases scatt…

  markpalfrey

  6 replies

  11 years, 6 months ago

  By: Brandie Tarvin

• How to Unlock the Database

  Hi All, How to Unlock the database in sql 2008. is there any Query to Unlock database.... Regards …

  Chowdary's

  7 replies

  11 years, 6 months ago

  By: Grant Fritchey

• SQL Server 2008 R2 in hung state. Need help in analyzing the log.

  2014-04-20 20:02:08.51 spid5s SQL Server has encountered 28 occurrence(s) of I/O requests taki…

  vsan82

  9 replies

  11 years, 6 months ago

  By: Gail Shaw

• How To Optimize a Query in SQL2008

  Hi All, Am Using SQL2008, I want to Optimize a Query,Where can i check the Recommendations like whe…

  Chowdary's

  2 replies

  11 years, 6 months ago

  By: Grant Fritchey

• change datasource of server in [sys].[servers]

  We will shutting down an older sql server and standing up a newer 2008 version using the same serve…

  TJ-356724

  7 replies

  11 years, 6 months ago

  By: TJ-356724

• SP redundant call

  Hi Experts, How to Check the stored procedures to find redundant calls within it? Thanks in Advance.

  VastSQL

  4 replies

  11 years, 7 months ago

  By: Lowell

• SQL Server 2008 on windows 8

  Hi Experts, I want to install SQL Server 2008 Enterprise edition 32 bit on Windows 8 64 bit, I am n…

  ksr39

  5 replies

  11 years, 7 months ago

  By: EdVassie

• Migrating Reports and Subscriptions to another server

  Hi, I have looked around and it doesn't seem possible, at least through a GUI but I'm going to ask …

  lmacdonald

  1 replies

  11 years, 7 months ago

  By: Joie Andrew