Administering

• Topics

  Started by

  Posts

  Last post

• ghost cleanup blocks checkpoint

  Sql 2005 64-bit Enterprise on Sql 2008 R2 64GB memory I've never seen this issue on any of our othe…

  Indianrock

  5 replies

  4 years, 8 months ago

  By: Jeff Moden

• How to find databases allocated and unallocated space per instance

  I need the following information: Space Allocated and unallocated space for each database, Can you …

  Narine M

  6 replies

  4 years, 9 months ago

  By: Sue_H

• OLE DB provider "SQLNCLI10" for linked server "XXX" returned message "The partner transaction manager has disabled its support for remote/network transactions.".

  Hi, I have two SQL Servers Server A and Server B. ServerA has SQL Server 2008 and ServerB has SQL S…

  garima.arya

  10 replies

  4 years, 9 months ago

  By: John D

• MSS SQL 2000 DTS Package Problem

  Hi Experts, I have one old server which runs on MS SQL 200 and using some DTS package , When I am e…

  ichbinraj

  12 replies

  4 years, 10 months ago

  By: as_1234

• See the query in sp_execute

  I'm supporting an application that is big about using sp_prepare and sp_execute. I need to reverse…

  Ninja's_RGR'us

  28 replies

  4 years, 10 months ago

  By: jk.capoeira

• 'profile name is not valid' error with sp_send_dbmail

  I am currently migrating our sql2000 instance to sql2k5 on a new server. As part of this migration…

  J-Hob

  2 replies

  4 years, 11 months ago

  By: cms4j

• Cannot shrink log, simple recovery model, no open transactions, tried checkpoint, etc.

  We have a database which is just a backup/snapshot of some data. The log grew very large while loa…

  tim.steorts

  13 replies

  4 years, 11 months ago

  By: Chris

• Setting up Database mail using gmail account

  Hi,, any one any idea about this? I am trying to set up Databases mail on my laptop and I have a gm…

  Achtang

  49 replies

  5 years ago

  By: Lindsay

• Log Shipping Agent Error Message

  Hi all, I am trying to configure log shipping and getting following error in agent job history.(SQL…

  sidewing

  3 replies

  5 years ago

  By: Leo.Miller

• Need a trigger to stop a restore with replace

  I have created a trigger to stop someone from dropping or creating a new database that works fine. …

  lmacdonald

  13 replies

  5 years, 1 month ago

  By: Hany Helmy

• Loading Data from a Linked Server - SQLNCLI errors

  I administer a local SQL Server 2005 database that was recently updated from SQL Server 2000. Ther…

  daren_sanborn

  12 replies

  5 years, 2 months ago

  By: vanu

• What is the OFFICIAL Microsoft response/fix to "Unable to load client print control" with reporting services

  Hi, We need OFFICIAL Microsoft response/fix to "Unable to load client print control" with reporting…

  gary1

  33 replies

  5 years, 2 months ago

  By: Vijay Badhe

• Instance Failure (System.Data) after configuring hostname alias

  Hi, I have configured hostname aliases for 3 different instances (2 2008r2 & 1 2012) on the sa…

  daigia_dzadzich

  2 replies

  5 years, 2 months ago

  By: patilmah

• How To Get Last Inserted Record Value In SQL Server

  How To Get Last Inserted Record Value In SQL Server The table have no Primary key, identity, it hav…

  Vijay Sinha

  20 replies

  5 years, 3 months ago

  By: drew.allen

• Lost in sp_executesql

  I want to read the SpaceUsed property for a file in another database then the database I'm currentl…

  Marco

  10 replies

  5 years, 3 months ago

  By: planetmatt