SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Error related to OPENROWSET

  Hi Friends, I am running an OPENROWSET query to access data from other server: SELECT a.* , 2 AS Kp…

  SUBRAHMANYA HEDGE

  1 replies

  15 years, 8 months ago

  By: yeek li

• backup user

  Hi All, i am creat users in my database and assing give permission to users to assing database. now…

  hodhod26

  4 replies

  15 years, 8 months ago

  By: hodhod26

• How do I downgrade from SQL 2008 Std to 2005 Std?

  Hi everyone! I currently have the SQL Server 2008 Std installation cd (1 processor license) and sin…

  Pierre M. Camilleri

  3 replies

  15 years, 8 months ago

  By: Reo

• How I can get alert if SQL Server Login is Locked Out due to wrong password attempts exceeded?

  Hi Everyone; I have a SQL Server Instance on it there are around 2500 databases and around 2500 SQL…

  Reo

  3 replies

  15 years, 8 months ago

  By: The_SQL_DBA

• SQL Server 2008 Express on Vista Home

  Hi I have installed SQL Server 2008 Express onto my laptop with Vista home edition o/s. I can conn…

  Lorna-331036

  7 replies

  15 years, 8 months ago

  By: Lorna-331036

• Swapping the Sql Server Instance root directory with another server

  I have a production sql server instance (say Prod1). Now I bring down the services, copy the instan…

  pdchandran

  6 replies

  15 years, 8 months ago

  By: pdchandran

• Forgot sa password and can not connect by Window Account!

  Hi all, I have a computer which had been installed from ghost file. So, in this computer has Sql s…

  sol.nt

  3 replies

  15 years, 9 months ago

  By: Jeff Moden

• Why experienced DBA try to embraces to younger DBAs in interviews?

  Hi; Why experienced DBA try to embarrassing to younger DBAs in interviews? Why thy thing that they …

  Reo

  17 replies

  15 years, 9 months ago

  By: Matt Miller (4)

• If database in Bulk Log recovery model then how you will configure Transaction Replication?

  Hi All; If a database in Bulk Log recovery model then how you will configure Transaction Replicatio…

  Reo

  2 replies

  15 years, 9 months ago

  By: Reo

• If MSDB is corrupted and SQL Server not started what you do?

  Hi All; If MSDB is corrupted and SQL Server not started what you do? Ram MSSQL DBA

  Reo

  5 replies

  15 years, 9 months ago

  By: Gail Shaw

• Explain the SQL Server Architecture?

  Hi everyone; An 11 year experienced DBA asked me a question Explain the SQL Server Architecture? Wh…

  Reo

  2 replies

  15 years, 9 months ago

  By: Gail Shaw

• Enforcing T-SQL Coding Standards

  My company is looking at getting some software to enforce T-SQL coding standard, naming conversion …

  Neal Sivley

  3 replies

  15 years, 9 months ago

  By: Jeff Moden

• Upgrading a SQL Server 2005 cluster to SQL Server 2008

  Today I am planning to upgrade a 2 node SQL Server 2005 cluster (running on Windows Server 2003 SP2…

  rwilkes-1123382

  2 replies

  15 years, 9 months ago

  By: Mile Higher Than Sea Level

• moving databases from SQL Server 2005 to SQL Server 2008

  Hello Guys. Happy New Year ! I am planning to move my databases from SQL Server 2005 to a new sepe…

  discover.sql

  4 replies

  15 years, 9 months ago

  By: Mile Higher Than Sea Level

• Truncating Large Tables Problem

  I have a table that contains more than 10,000,000,000 records, what is the best way to empty this t…

  SqlDeveloper2246

  4 replies

  15 years, 9 months ago

  By: SqlDeveloper2246