Administering

• Topics

  Started by

  Posts

  Last post

• What was running last night to fill my tran log.

  How can I find out what? It's in full recovery mode, autogrew to max size (just under full disk), s…

  snomadj

  4 replies

  14 years ago

  By: Orlando Colamatteo

• Linked Server : :Cannot start more transactions on this session"

  Hi All, I have a job on a production server A which has two steps: Step1: Inserts records older tha…

  MI_DBA

  1 replies

  14 years ago

  By: spaghettidba

• Creating a Schema if it doesn't exist

  I've create a small script which creates some tables but i'm have aproblem with creating a schema i…

  RedDoorSQL

  5 replies

  14 years ago

  By: Sean Lange

• how to make this batch file work using xp_cmdshell?

  If i copy and paste this "D:\SQL2005_CU\SQLServer2005-KB2507769-x64-ENU.exe" /allinstances /quiet …

  curious_sqldba

  8 replies

  14 years ago

  By: Orlando Colamatteo

• SQL 2005 Service Pack Updates

  Hi All, I have been tasked with Planning some Service Pack Updates on our SQL Servers. I have 2 ser…

  ldorian81

  3 replies

  14 years ago

  By: Orlando Colamatteo

• AES encrypted column

  Hi, I have been tasked with dumping data from an encrypted column. Acutally the data in the field h…

  krypto69

  9 replies

  14 years ago

  By: krypto69

• DataFile Out of Disk Space Issue

  Ok... never thought it would have happened, but dropping and trying to re-create a clustered index …

  DB_Newbie2007

  3 replies

  14 years ago

  By: DB_Newbie2007

• How to read from the SQL Agent Log.

  Hi, We use - 'xp_readerrorlog' to read from the SQL Errorlog file. What is the query/command to rea…

  SQL_Hunt

  3 replies

  14 years ago

  By: SQL_Hunt

• Going to Dev Edition

  We've got 2005 Enterprise Edition (SP3) on a cluster. This is actually a dev cluster, so we need t…

  Whisper9999

  6 replies

  14 years ago

  By: EdVassie

• OLE DB error when trying to query excel sheet from Management Studio

  Hi, I have a user who is getting the following error when trying to query an excel file from within…

  Isabelle2378

  1 replies

  14 years ago

  By: Orlando Colamatteo

• SQL Server Memory

  Hi, I am using SQL Server R2. I set the sp_configure 'max server memory', 12288; But still it is …

  rvasanth

  7 replies

  14 years ago

  By: Orlando Colamatteo

• How to create Rule or Trigger for Object Names

  HI there! I'd like to know if there is an existing rule or trigger I can use for developers not to …

  sunshine-587009

  2 replies

  14 years ago

  By: Orlando Colamatteo

• Question on Indexing

  I just used sys.dm_db_index_physcal_stats tables to view indexs in a DB. I used AdventureWorks. to …

  na1774

  1 replies

  14 years ago

  By: Gail Shaw

• BCP OUT - Force Order

  I am using BCP out to extract some 50 records into excel. In table, the records are sorted correctl…

  balasach82

  1 replies

  14 years ago

  By: Orlando Colamatteo

• Truncating the SQL Server 2008 Log file..

  Hi, I am having a database in SQL Server 2008 its Transaction log reached around 70 GB whereas data…

  saadi92

  5 replies

  14 years ago

  By: Perry Whittle