Administering

• Topics

  Started by

  Posts

  Last post

• select statement

  Help-My brain is fried- I just can't figure out the last step (six). Write a select statement that …

  textwhisperer

  4 replies

  15 years, 10 months ago

  By: ashish 10950

• Email from DDL trigger

  Is there a way to get this select statement inserted into the email notification? CREATE TRIGGER [d…

  smitty-1088185

  3 replies

  15 years, 10 months ago

  By: smitty-1088185

• a recently applied update, kb955706, failed to install

  installed sp3 on dba and dev servers with no problems. when applying to a stage box, got a recentl…

  Dan Heile

  9 replies

  15 years, 10 months ago

  By: sivaprasad

• Transaction Log error

  Hi, iam trying to delete the records from the table and got the below error........ Error:9002,sev…

  y.koteswarrao-652921

  6 replies

  15 years, 10 months ago

  By: y.koteswarrao-652921

• Shrink Database - Clear free space

  We had a security leak where someone placed a classified document on our sharepoint server. We hav…

  paul_jacobs

  5 replies

  15 years, 10 months ago

  By: Nadrek

• Default Trace

  For how many days does the default trace files be available at the default folder. If we need infor…

  M&M

  5 replies

  15 years, 10 months ago

  By: M&M

• Appsec dbProtect or Idera SQL Secure/Complaince Manager

  As part of our PCI compliance we're required to audit the databases to the nth degree and had a dem…

  ChrisTaylor

  2 replies

  15 years, 10 months ago

  By: ecw_65

• History Cleanup Task not executed

  Hello, I created a maintenance plan (in SSMS) with the tasks 'History Cleanup Task' and 'Maintenanc…

  tutupouet

  10 replies

  15 years, 10 months ago

  By: Jeffrey Williams

• BULK INSERT

  I'm trying to import data from a dat file to a table using BULK INSERT. USE abc GO Truncate table d…

  sunny.tjk

  4 replies

  15 years, 10 months ago

  By: David Webb-CDS

• DB Owner

  I have a server where some user are given access to create database ofcourse it is a development se…

  Tara-1044200

  1 replies

  15 years, 10 months ago

  By: Steve Jones - SSC Editor

• Performance tunning SQL 2005

  Hi Experts, I am not so experianced with SQL server performance tunning process. Can you please gui…

  DBA_2005

  7 replies

  15 years, 10 months ago

  By: tfifield

• Data is gone, how can I know what happened?

  Hi guys, this is my first post, sorry for being so direct, but I'm in a real hurry. Please let's le…

  bigfonx

  15 replies

  15 years, 10 months ago

  By: steve block

• Get rid of duplicate records in a table using SQL Server 2005

  Hi All, Could anyone assist on this? I have a table that contains duplicate records and would like…

  Atang Mogwera

  10 replies

  15 years, 10 months ago

  By: sjimmo

• Client Tool Install Problem

  I am attempting to load the SQL Server 2005 Client Tools on a PC here at work. I've never had a pr…

  Lynn Pettis

  8 replies

  15 years, 10 months ago

  By: Lynn Pettis

• Index with Included Columns and Index Fragmentation

  I have a table with a status column. This column is heavily updated as a records status can change …

  Daniel Millstone

  5 replies

  15 years, 10 months ago

  By: Daniel Millstone