Administering

• Topics

  Started by

  Posts

  Last post

• SSRS SQL Agent Jobs Missing?

  Hi I am trying to add a step to a SQL Agent job to call an SSRS schedule and email a report out. Th…

  agerard

  1 replies

  9 years, 12 months ago

  By: agerard

• Unable to start SQL jobs remotely

  I am facing a strange problem the past 2 weeks. We have registered many servers remotely in Managem…

  Arun Benjamin

  6 replies

  9 years, 12 months ago

  By: bsclyde

• Restoring .mdf .ldf files to a new server

  There was corruption on a box and lo and behold the only backups are of the mdf and ldf files. To …

  chrisph

  6 replies

  9 years, 12 months ago

  By: Kristen-173977

• cannot run job script on new server

  I have a job running on a server, and i am trying to copy it onto another server. i scripted the jo…

  winston Smith

  4 replies

  10 years ago

  By: kommamadhu

• How to run .XMLA on Analysis Services script via SQL Server Database Engine?

  Hello fellow SQL buffs, Does anyone know how to execute an .XMLA query on Analysis Services via sql…

  db_bunny

  3 replies

  10 years ago

  By: jjradha

• Find the last executed part of a stored procedure

  Hello I have a stored procedure that performs a number of tasks (inserts, updates etc.) It's been r…

  DamianC

  4 replies

  10 years ago

  By: Gail Shaw

• High CPU from Distributed Query Cache??

  Ok, this is a weird one so bear with me. We have some load balanced application servers that every …

  Y.B.

  1 replies

  10 years ago

  By: Y.B.

• Transaction logs

  Hi, how can i reduce the size of the transactional logs in SQL database? thanks

  lglzba

  4 replies

  10 years ago

  By: Gail Shaw

• In sqlserver Clustering network name getting error

  when i am trying to give SQL Server Network name it showing error error: the Sql Server Failover c…

  ramu.a

  4 replies

  10 years ago

  By: lsalih

• How to send PARAMETER to a SQL JOB while calling

  Hi All, Following description specifies my requirement. Can you guys go through this and provide me…

  kirankumar342

  5 replies

  10 years ago

  By: Gail Shaw

• Strange DB Mail issue.

  DB mail has been running fine until recently. Sending a test e-mail produces no errors, but the mai…

  Scott Jones-362227

  12 replies

  10 years ago

  By: Ed Wagner

• Info on Service Packs & Patches

  Hi, Is there any way I can get notified whenever Microsoft release Patches or Service Packs for SQL…

  haichells

  4 replies

  10 years ago

  By: DeWayne_McCallie

• My log file became not available and the database went into Recovery Pending mode

  Around 1:01 AM in the morning, the drive that houses my log files (1 of 4) filled up. The particula…

  tjaybelt

  6 replies

  10 years ago

  By: SQLAssAS

• Login Failed - Login already has an account under a different user name

  Hi I'm new to SQL Admin. Have 2 databases that need login to be db_DataReader, db_DataWriter, &…

  jess-359518

  9 replies

  10 years ago

  By: Chetandutt2008

• Install sql 2005 on windows 2008?

  Can I install SQL Server 2005 64 bit enterprise edition on Windows server 2008 R2 64 bit Enterprise…

  fizzleme

  2 replies

  10 years ago

  By: JeremyE