SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Log Shipping with Filestream data?

  I'm trying to set up a disaster recover setup so a copy of the databaes is available if the primary…

  david_wendelken

  4 replies

  15 years ago

  By: Ali Tailor

• Memory problems

  Dear All. We have the ssas cube server was setup; the server has been very sluggish. Under the Tas…

  srathna77

  3 replies

  15 years ago

  By: grahamc

• DPM Security Granularity?

  I have been told that it's not possible to set up DPM in such a way that someone using it to do dat…

  david_wendelken

  1 replies

  15 years ago

  By: grahamc

• Permissions For Multiple Logins To Run Only Specific Jobs

  All, I have a group of 5 developers and I want them to be able to create and run jobs. I have the…

  mnDBA

  2 replies

  15 years ago

  By: grahamc

• Cannot use KILL to kill your own process

  How do I kill a process that is my own? This process has had a table lock in effect since last wee…

  adams.squared

  10 replies

  15 years ago

  By: adams.squared

• Permissions Question

  Hi I need help with setting up permissions in SQL Server. There are just two different levels of p…

  Atat Rowcount

  6 replies

  15 years ago

  By: Perry Whittle

• Problem installing CU2 on SQL 2008 SP1 Active Passive Cluster

  CU2 is required for SharePoint 2010 and thus I want to install it on my production SQL Server 2008 …

  tnk

  1 replies

  15 years ago

  By: tnk

• Issues with "Cumulative Update package 3 for SQL Server 2008 R2"?

  Has anyone found any issues with the Cumulative Update package 3 for SQL Server 2008 R2? http://sup…

  Marios Philippopoulos

  7 replies

  15 years ago

  By: Marios Philippopoulos

• Rebuilding indexes

  Hi Is it good to do index rebulid with online option when production is going on. Is there any imp…

  Minto Minto(quendans)

  6 replies

  15 years ago

  By: Minto Minto(quendans)

• Using something other than cursors

  Hello, I'm trying to do more set based work rather than RBAR. So this is really a request to better…

  fenwicc

  2 replies

  15 years ago

  By: fenwicc

• Maintanance Plan

  Hi Friends, i have created a new maintanence plan and set the subplan under that, and schdeuled it …

  JakDBA

  4 replies

  15 years ago

  By: subbu_e

• Recurring deadlock in sharepoint 2010 on sql 2008

  We are having a frequent recurring deadlock on sharepoint, here is the deadlockgraph. I was assumin…

  jspatz

  4 replies

  15 years ago

  By: subbu_e

• SPID -2

  Had some blocking issue. A user spid was being blocked by spid -2. have never seen an spid numbered…

  zeenister

  4 replies

  15 years ago

  By: Gail Shaw

• SQL SERVER LOGIN

  HI all, can u please help me in ths one... How can i know from last 6 months(Users informatin…

  kollisudheer27

  1 replies

  15 years ago

  By: Luzi62

• Opened distributed transaction problem

  On one of my databases DBCC OPENTRAN returs following: Replicated Transaction Information: …

  darko IS

  2 replies

  15 years ago

  By: darko IS