Administering

• Topics

  Started by

  Posts

  Last post

• Transaction job fails after integrity job runs

  Hello, I discovered that after this code runs, my transaction job only for 2 db fails (log chain is…

  Krasavita

  6 replies

  16 years ago

  By: Jeffrey Williams

• Tran Replication

  Does Insert only replication replicated only committed inserts to subscriber or does it even try to…

  T_SqueaKquel

  7 replies

  16 years ago

  By: Animal Magic

• SQL Server Schemas

  If I want a particular user to have SELECT permissions only on certain tables is there someway of a…

  David-155102

  16 replies

  16 years ago

  By: Perry Whittle

• Slow Database Backup & Restore

  Hi All We are facing slow backup & restore database backup issue SQL sevrer 2005 express Editi…

  gupta1282

  4 replies

  16 years ago

  By: Bhuvnesh

• Table Index HINT

  Hi I've inherited a very poorly designed database. I have realized that some sprocs are doing Index…

  Bobby Glover

  10 replies

  16 years ago

  By: Bhuvnesh

• An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown

  Hi, We have developed import/export script and generated high volume of test data to conduct perfor…

  coolchaitu

  1 replies

  16 years ago

  By: Grant Fritchey

• @@Servername

  Hi, I have named instance in sql server 2000 version. while executing the @@servername command it…

  sudhakara

  10 replies

  16 years ago

  By: bpflanzer

• restricting schema name

  Hi i have a database which has many jobs running on it under a proxy agent. When the proxy creates …

  hussain27syed

  2 replies

  16 years ago

  By: Grant Fritchey

• Silly question - does an index reoganisation carry over to restored db?

  I'll run some dbcc contigs once i've restored it just to check, but i was just wondering if the nic…

  Mat-381415

  1 replies

  16 years ago

  By: Grant Fritchey

• Reindex minimally logged - Does not work

  Hi I am using a job to rebuild indexes. Step one I put the database in Bulk Load. Step 2 I reindex …

  OomBoom

  18 replies

  16 years ago

  By: OomBoom

• Checklist Needed

  Hi Folks, Can any one provide me a checklist to validate while doing the database migration from o…

  lkarthikraj-609584

  2 replies

  16 years ago

  By: - Win.

• Archiving an area of an enterprise sized SQL server 2005 DB

  Hi Guys, I am currently undergoing a process of archiving an area of an enterprise-scale database (…

  Scozzard

  2 replies

  16 years ago

  By: Scozzard

• Administering and Monitoring Multiple database versions

  Hi I am new to SQL administration. We have over 100 production/development databases on multiple s…

  Ejacksonjames

  8 replies

  16 years ago

  By: Shawn Melton

• script to monitor service up/down

  I was about to start writing some script/batch file that I can schedule to generate an alert if the…

  NJ-DBA

  1 replies

  16 years ago

  By: NJ-DBA

• SSIS package from JOB failing.

  Hi All, I have a task of scheduling backup of Single table from one server to another. So, through …

  - Win.

  1 replies

  16 years ago

  By: pmoore-763907