Administering

• Topics

  Started by

  Posts

  Last post

• Update doesn't update if the condition of Instead of update is unfulfilled

  Hello, i'm newbie in t-sql.. and when i try to catch event before update on trigger sql using inste…

  xmozart.ryan

  10 replies

  13 years ago

  By: Lynn Pettis

• TempDB Growing MDF

  Hi I am responsible for a SQL Server in an emergency Organization in Austria. We use MS Sql Server …

  peter-661823

  11 replies

  13 years ago

  By: Orlando Colamatteo

• Two databases share same Full Text Catalog

  Hi Administrators :), I need to duplicate one database. It should be copied on same server, just wi…

  Boris Pazin

  1 replies

  13 years ago

  By: Bhuvnesh

• SP in Rollback

  I have a script that is marked as being in rollback in the master database. The wait time for this …

  Ian_McCann

  3 replies

  13 years ago

  By: Bhuvnesh

• Is it possible to look for a word in the Database ?

  Hello fellow developers, I have been trying to look for a column in a table A for joining it with …

  SQL SERVER ROOKIE

  8 replies

  13 years ago

  By: SQL SERVER ROOKIE

• Temporarily stop and then restart jobs between Sat 9 pm and Sun 2 am

  Here's a start but I don't know how to identify the days. Help? I then need to take this list and…

  ZenDada

  2 replies

  13 years ago

  By: Jeff Moden

• Dynamic SQL, Ownership Chaining, and EXECUTE AS

  Hi all, I've got a procedure which is using dynamic SQL to construct an SQL statement, and then exe…

  kramaswamy

  5 replies

  13 years ago

  By: Orlando Colamatteo

• Modify same trigger on all db's in the server

  I have a trigger in alsmost 500db's, now i have ot make some changes on all those, how do i do that…

  Tara-1044200

  2 replies

  13 years ago

  By: Sean Lange

• Find out why a maint plan failed

  Hi all, a maintence plan failed last night and im trying to find out why. now apart from the fact t…

  n00bDBA

  2 replies

  13 years ago

  By: T_Peters

• Getting Ntfs error

  Hi, We have 2 node cluster setup on Windows 2003 x64 with SP2 and we are ready to install SQL Serve…

  gary1

  2 replies

  13 years ago

  By: NMHDBA

• Intermittent Connectivity/DB availability issue

  Hi All, I've got a problem intermittent Connectivity/DB availability issue Here's quick low-down o…

  OnTheNumbers

  2 replies

  13 years ago

  By: OnTheNumbers

• changing assigned sql memory - any impact?

  I was in an impression that if i change the assigned sql memory it shouldn't impact any online oper…

  curious_sqldba

  1 replies

  13 years ago

  By: SQL Show

• How to notify when SQL Server Agent stopped automatically?

  Hello all, I have many jobs running and for some reason sql server agents stops automatically not s…

  sqlpanther

  7 replies

  13 years ago

  By: jamessdba

• select permission denied to login number

  i have provided db_datareader permission but still getting below error in sqlserver 2005 Dev Editio…

  jamessdba

  4 replies

  13 years ago

  By: Ant-Green

• Database list from multiple SQL servers and instances???

  Hi I'm currently looking for a script to get a list of all databases from our SQL 2005 and above i…

  angelspawn

  5 replies

  13 years ago

  By: Your Name Here