Administering

• Topics

  Started by

  Posts

  Last post

• Howto Query system views on linked server?

  Hi all! I hope you can help me, this problem is a pain in the ***. Situation: I want to create a s…

  Themod

  3 replies

  15 years, 8 months ago

  By: Themod

• Data Generator and Data Masking Tools - Open Source

  Are there any open source Data generator and Data Masking tools available? I know RedGate has Sql D…

  _UB

  2 replies

  15 years, 8 months ago

  By: jackie.lee1982

• Changing password of logins

  hii, I have a development server with sql server 2005 on it. When i have to change a password…

  Skybvi

  6 replies

  15 years, 8 months ago

  By: chetanr.jain

• couldn't use Lock Pages in SQL 2005 x64 Standard Edition

  My configuration : SQL Server 2005 x64 Standard Edition, MS clustering, version : 9.0.4226 I enable…

  onlo

  5 replies

  15 years, 8 months ago

  By: onlo

• Can anyone share cool Scripts used for DB Administration ?

  Hello Guys, Can anyone be nice to me and share the scripts you use for various Databse administrati…

  SqlServerLover

  10 replies

  15 years, 8 months ago

  By: Steve Jones - SSC Editor

• Dynamically Create/Alter procs - tables.

  I have a control server and want to make changes on all other servers with this server. All the bas…

  curious_sqldba

  3 replies

  15 years, 8 months ago

  By: curious_sqldba

• Cumulative Updates & Hotfixes

  Just out of curiosity, how are you as a production dba deal with cumulative updates and hotfixes? D…

  Paul Mu

  17 replies

  15 years, 8 months ago

  By: Jeff Moden

• How to stop a 'Shrink Database' from the GUI

  Hi everyone. Have been lurking off and on for a few months. Lots of great info. I'm not a DBA, but …

  ricnav

  10 replies

  15 years, 8 months ago

  By: ricnav

• compatibility level of reportServer & reportserverTempdb changing to 100 every day at same time

  Hi, We have performed the upgrade from SQL Server 2005 to SQL Server 2008 using Side-by-side upgrad…

  gary1

  3 replies

  15 years, 8 months ago

  By: Richard M.

• DBCC Page output

  Hi How to know what object or index is on particular Page I ran following command DBCC Page(51,6,5…

  gupta1282

  2 replies

  15 years, 8 months ago

  By: Gail Shaw

• Need to fire an Memory Insufficient alert using DBmail

  Hello, Our system is having a sudden trust of certain applications that is causing the Server memor…

  amitghosh83

  1 replies

  15 years, 8 months ago

  By: Adiga

• tempdb

  Find user database operation on temp db, I need a information to find operations on user database …

  Sharon Kumar

  1 replies

  15 years, 8 months ago

  By: Vikas S. Rajput

• DBCC CHECKDB Error

  Hi This is the output of DBCC CheckDB statement of our one database Extent (6:5008984) in databas…

  gupta1282

  7 replies

  15 years, 8 months ago

  By: gupta1282

• Do you advise to apply Recomendations given by DTA?

  Hello Guys, I have a question. When i analyze the workload captured from profiler, DTA shows me bun…

  SqlServerLover

  18 replies

  15 years, 8 months ago

  By: Rick.Cornell.SME

• Could not open error log

  Hey Guys i am at loss, im getting the following error message on one of our SQL Servers sitting on…

  timster

  7 replies

  15 years, 8 months ago

  By: Simon Facer