SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Setting Notification email (When the job fails)

  Hi Everyone, I have setup a job(SQLS ERVER 2008 R2) in two servers Server1.Domain1 & Server1.D…

  Aspet Golestanian Namagerdi

  6 replies

  13 years, 1 months ago

  By: simmonssql

• user permission

  Hi, Here is the database settings: There is domainName\users unders security\ logins. db_owner is N…

  arkiboys

  5 replies

  13 years, 1 months ago

  By: John Mitchell-245523

• need script to set Port number

  need script to set Port number .

  charipg

  3 replies

  13 years, 1 months ago

  By: SQL Show

• witness server

  with out witness server can we set up mirroring?

  hydprasanna

  4 replies

  13 years, 1 months ago

  By: shohelr2003

• Change data capture retention

  I would like to retain the data for change data capture log tables to 365 days. Please let me know …

  Mvs2k11

  1 replies

  13 years, 1 months ago

  By: Sean Lange

• SQL Server Backups

  This is more of a poll but I'd like to get others opinions. What is the recommend and preferred me…

  Tony Fountain

  14 replies

  13 years, 1 months ago

  By: Tony Fountain

• acid properties

  Pls give detailed information about acid properties with suitable examples

  hydprasanna

  2 replies

  13 years, 1 months ago

  By: Sean Lange

• sp needed for sql 2005,2008

  What are the service packs is needed to install sql server 2005,2008

  hydprasanna

  1 replies

  13 years, 1 months ago

  By: Sean Lange

• SSMS with a hosted sql server database

  I am setting up a sql server database on a hosted account. Unfortunately, my current hosted accoun…

  fbrewer

  1 replies

  13 years, 1 months ago

  By: Lowell

• permisssion

  Hi, How do I make the users group i.e. domainname\users to be able to only select from tableA but u…

  arkiboys

  6 replies

  13 years, 1 months ago

  By: Ant-Green

• SQL Server Consolidation (25 servers)

  Our company plans to consolidate SQL Servers. Currently there are about 25 servers. They try to min…

  RVO

  13 replies

  13 years, 1 months ago

  By: RVO

• Multiple Index Rebuild

  Hi Experts, Production team have send a rebuild index script for 100 indexes ,i need to run this in…

  VastSQL

  2 replies

  13 years, 1 months ago

  By: Gail Shaw

• Shrunk data file in sqlserver2008

  we have shrunk a datafile in production is there any impact Please suggest.

  RK2012

  3 replies

  13 years, 1 months ago

  By: RK2012

• Database 'MyDWdb' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

  I had a transaction Log become full (no disk space). The database went into recovery. I deleted fil…

  Welsh Corgi

  8 replies

  13 years, 1 months ago

  By: Welsh Corgi

• DMV to replace SP_WHO

  I have been looking at the DMV's intended to replace SP_WHO and SP_WHO2. I have knocked up a query…

  john.hunt 59909

  2 replies

  13 years, 1 months ago

  By: Orlando Colamatteo