Administering

• Topics

  Started by

  Posts

  Last post

• DB Availability

  How does one check the availability of a DB on a regular basis, with that I intend to ask how shoul…

  The_SQL_DBA

  3 replies

  17 years ago

  By: Jonathan Kehayias

• Listing table names and columns in a database

  Hi All, How do I get a list of all the table names and their column names from a database? Than…

  ramadesai108

  8 replies

  17 years ago

  By: Robert Bedick

• Can any body tell me reason to raise this error , and how can solved? ..Error Message : Executed as user: svr11\SYSTEM. Process is terminated due to StackOverflowException.The return value was unknown.The process exit code was -2147023895.The step failed.

  Error when takeing differential backups : Message Executed as user: svr11\SYSTEM. Process is termi…

  Paresh Prajapati

  6 replies

  17 years ago

  By: AJit Sanghera

• Database Mirroring or Log shipping on different server

  I have to implement Database Mirroring or Log shipping on different server in which one server is l…

  Paresh Prajapati

  36 replies

  17 years ago

  By: Schadenfreude-Mei

• Error in starting sql server in single user mode

  Hi all, Do I need to stop sql server services before starting the instance in single user mode.....…

  Ahmad Osama

  23 replies

  17 years ago

  By: Ahmad Osama

• uninstallation problem

  when i am uninstalling my instance i am getting following error plz reply me, am attaching my error…

  amarnath_sk

  1 replies

  17 years ago

  By: Nicholas Cain

• Diff Between SPID and Process ID

  The Gurus, Can anyone tell me the difference between SPID and Process ID? Thanks. Regards, Sahoong.

  sahoong

  4 replies

  17 years ago

  By: Suresh B.

• make store procedure

  hello i want to make a store procedure from aquery, how should i do that?

  nazaninahmady_sh

  6 replies

  17 years ago

  By: ps.

• SQL Server Upgrade - Login backups

  I am in the process of doing an upgrade from SQL Server 2008 evaluation to SQL Server 2008 develope…

  isuckatsql

  5 replies

  17 years ago

  By: Paresh Prajapati

• backup newly created database automatically

  Hi, I'm trying to write a trigger that will backup a database on creation, but i get this error "Ca…

  Mad-Dog

  27 replies

  17 years ago

  By: Paresh Prajapati

• Log shipping

  Hi, While configuring the log shipping environment, i faced a problem. Problem is the check b…

  Deeptiprasad

  3 replies

  17 years ago

  By: liebesiech

• How can i watch a table with Select and Update statements

  Hi all, I want to watch select and update transactions on a table in my database with SQL Profiler.…

  thinknight

  3 replies

  17 years ago

  By: Paresh Prajapati

• a

  a

  mnDBA

  7 replies

  17 years ago

  By: Jonathan Kehayias

• Hey, merry xmas and a happy new year fellow SQL dudes (and dudettes)

  as title :crazy: ---------------------------------------------------------------------------------…

  Perry Whittle

  8 replies

  17 years ago

  By: Ninja's_RGR'us

• mirroring witness offline for some time in high safety mode

  hi I have database mirroring running on prod environment with high safety with automatic failover(s…

  dallas13

  1 replies

  17 years ago

  By: MANU-J.