Administering

• Topics

  Started by

  Posts

  Last post

• Backup error

  Hi guys. I have been trying to take a maual bkp on the local drive. But the bkp terminated abruptly…

  na1774

  2 replies

  14 years ago

  By: na1774

• Altering the collation at a database level

  We have a problem with a database (CRM) was installed through a third party supplier, they've insta…

  RedDoorSQL

  3 replies

  14 years ago

  By: RedDoorSQL

• SA Login and user/schema mapping

  Hi all, I've got a problem right now that is making me want to pull hair out. Here's the situatio…

  venoym

  1 replies

  14 years ago

  By: venoym

• Replication D/R Error

  I am getting error on Transactional replication in sql server 2005, once Publisher server goes down…

  solomon.jernas

  2 replies

  14 years ago

  By: Steve Jones - SSC Editor

• Database file size 100% utilized?

  Hi Experts, On daily db monitoring i found some of my databases showing Database file size 100% uti…

  MSQLDBA

  8 replies

  14 years ago

  By: Suresh B.

• Spid value showing -3 unable to kill

  I'm having a problem after restarting my sql server instance. I've discovered through sp_who that…

  RedDoorSQL

  3 replies

  14 years ago

  By: RedDoorSQL

• KB970894 on SQL server 2005 SP3

  I have applied Security update KB970894 on SQL server 2005 SP3 system it is succeeded on SQL Server…

  Nag469191

  2 replies

  14 years ago

  By: george sibbald

• Query to get records which are GETDATE()-60 DAYS

  I need to retrieve records whose DATEFIELD is less than 60 days. select top 1 * from TABLENAME wher…

  balasach82

  5 replies

  14 years ago

  By: balasach82

• extact last 3 characters from a string

  i wish to extract last 3 characters of a string, in sql server 2005,. substring doesnt accept -3 a…

  shiwani2002sg

  23 replies

  14 years ago

  By: dandanaveenreddy

• Server side Trace

  I'd like to set a filter on resource database in my server side trace. Could someone please tell me…

  sunny.tjk

  11 replies

  14 years ago

  By: sunny.tjk

• Interpret Showplan Statistics Profile - SQL Profiler

  Usually i would use 'Showplan XML statistics profile' inside profiler trace to get the execution pl…

  curious_sqldba

  4 replies

  14 years ago

  By: curious_sqldba

• about replication and synchronization

  Hi can anyone please guide me about synchronization and replication in sql server

  praspras42

  1 replies

  14 years ago

  By: homebrew01

• Execution Plan Creation Time > Query Execution Time

  Hello all! I have a query(from a third party application) where the time to create the execution pl…

  MDave

  2 replies

  14 years ago

  By: Grant Fritchey

• Database encryption in SQL 2005

  Is it possible to encryp whole database in SQL 2005? How to implement?

  tyang

  4 replies

  14 years ago

  By: MasterDB

• MSDB Over 6 gig in size has never been cleaned up I want to run this Script

  MSDB Over 6 gig in size has never been cleaned up I want to run this Script. Will this impact my us…

  twdavis-893252

  3 replies

  14 years ago

  By: Perry Whittle