SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• SYSTEM_USER returns incorrect value for Win-auth user after Active-Directory change

  I have a user that when connecting to a specific SQL-2008 instance as herself - Windows authenticat…

  Marios Philippopoulos

  4 replies

  15 years, 10 months ago

  By: Marios Philippopoulos

• complete uninstall of SQL server

  Hi, I wants to complete uninstall of SQL server from My Server ... My doubt is After UN installatio…

  Shivrudra

  1 replies

  15 years, 10 months ago

  By: Henrico Bekker

• Strange-Log shipping & Mirroring option not available

  Hi Experts, I met one strange scenary that in one of our SQL Server 2008 Enterprise Evalutaion(RTM)…

  VastSQL

  4 replies

  15 years, 10 months ago

  By: VastSQL

• SQL 2008 install and accounts

  Hi there I am hoping someone could help me clear up the accounts and groups that are used and creat…

  Kwisatz78

  1 replies

  15 years, 10 months ago

  By: S. Kusen

• OPENROWSET mysteriously stopped working

  This worked last week: select top 1 a.* from OPENROWSET('SQLOLEDB','myServer';'myLogin';'myPassword…

  ZenDada

  2 replies

  15 years, 10 months ago

  By: ZenDada

• What are the ways to prevent alter procedure?

  hi, How can prevent the alter procedure when one developer is altering the procedure? Thanks, 🙂

  SQL*

  5 replies

  15 years, 10 months ago

  By: Geoff A

• Help with Powershell

  I am trying to get up and running with Powershell but keep running in to small problems and not sur…

  sqlhack

  1 replies

  15 years, 10 months ago

  By: Jeffrey Williams

• DATE AND TIME Datatypes storage

  Hi, I have a database from the sql server 2005 and migrated to sql server 2008, in that i have c…

  SQL*

  1 replies

  15 years, 10 months ago

  By: Sankar Reddy

• Restore Transaction Log

  Hello Everyone I have not been able to find anything in the SQL BOL, nor have I ever had to try thi…

  AndrewSQLDBA

  3 replies

  15 years, 10 months ago

  By: Source-NH

• Scripting languages to sql server(uses)

  hi, Kindly clarify very basic questions about scripting: What is the use of scripting language in…

  SQL*

  2 replies

  15 years, 10 months ago

  By: torpkev

• Performance Tuning

  i have 8 gb ram and i checked SQLserver.exe peocess is taking 6 gb memory, how wud i knw which proc…

  Zeal-DBA

  4 replies

  15 years, 10 months ago

  By: Shivrudra

• SQL server service did not started automatically

  Before two day’s I have changed Password of my windows domain account. This same account we use to …

  Shivrudra

  3 replies

  15 years, 10 months ago

  By: jeff.mason

• Memory Utilization

  Hi all, I am using SQL SERVER 2008. When ever i see Physical Memory usage its nearly going to 7.4GB…

  viswanath09

  9 replies

  15 years, 10 months ago

  By: Jim McLeod

• Restore database 2008 to 2005

  Hi , i m currently running database server 2008 , but due to some reason i want to switch to sql 20…

  honey47

  8 replies

  15 years, 10 months ago

  By: chetanr.jain

• Maintenance Plan not deleteing old backup files

  I have Maintenance Plans for groups of my databases: System, User & Management databases. Each…

  BigSam

  7 replies

  15 years, 10 months ago

  By: Sankar Reddy