Administering

• Topics

  Started by

  Posts

  Last post

• query to get updates/inserts done everyday

  Hi, Is there any query to know what type of changes done by users on sql server tables?

  scuby.me

  4 replies

  11 years, 10 months ago

  By: jcb

• Msg 7314, Level 16, State 1, Line 1 The OLE DB provider "SQLNCLI" for linked server "CHIMSSQLDEV" does not contain the table ""ArrowProdDB"."dbo"."sysfiles"". The table either does not exist or the current user does not have permissions on that table.

  I can select from a master table however get this error for all user databases. any idea what is go…

  sunshine-587009

  11 replies

  11 years, 10 months ago

  By: DBA_NEW

• Audit tasks

  Hi, I want to create a database that log into a table this type of operations: 1) t-SQL script pass…

  river1

  1 replies

  11 years, 10 months ago

  By: Sean Pearce

• Always save query to file

  Hi, I would like to know if there is any property in Management Studio that I can change to save au…

  river1

  5 replies

  11 years, 10 months ago

  By: LutzM

• Regarding SQL Server certification.

  Dear Experts, I have passed my MCTS (70-431) exam. I would like to do more certifications on SQL Se…

  Joy Smith San

  4 replies

  11 years, 10 months ago

  By: PravB4u

• What's the best practice to replicate data in the same table on 2k5+

  I am looking for the best and simplest solution to quickly replicate data in the same table. e.g. I…

  halifaxdal

  1 replies

  11 years, 10 months ago

  By: Sean Lange

• Not able to install SQL Server 2005 SP3 in SQL Server 2005 SP2 installed Server.

  Hi, I am not able to install SQL Server 2005 SP3 for Database Services, Analysis Services in SQL Se…

  gvenka10

  8 replies

  11 years, 10 months ago

  By: hannes.linzbauer

• can we do database mirroring in different domains.Is it possible

  Hi guys, can we do database mirroring in different domains.Is it possible can you please provide …

  kvr1985

  4 replies

  11 years, 10 months ago

  By: abhu2487

• Best Practices for implementing Indexes

  I'm working with a database that has some performance prolems. We have determined that some indexes…

  K Currie

  3 replies

  11 years, 10 months ago

  By: Bhuvnesh

• Database on emergency mode

  Hi Team , I have set my database in emergency mode then i ran the command as like alter database xy…

  vivekinmadar

  2 replies

  11 years, 10 months ago

  By: Gail Shaw

• Statistics Needed - When loading data?

  I have a bunch of empty tables, i will be disabling all the nc indices and leave clustered index en…

  curious_sqldba

  7 replies

  11 years, 10 months ago

  By: Gail Shaw

• Craeting DR in sql 2012 standarad version for priamry server 2005 enterprise sp4

  Hi I have one query Is it possible to create DR in sql server 2012 standarad edition for a primary…

  anoop.mig29

  3 replies

  11 years, 10 months ago

  By: Gail Shaw

• database options not being copied from model db

  I have made some db level changes on model db and the intent was to have those settings copied over…

  curious_sqldba

  1 replies

  11 years, 10 months ago

  By: Jeff Moden

• Strange column names in execution plan

  In the attached execution plan, at the sort operator(50% cost),when i hover over the operator in th…

  curious_sqldba

  4 replies

  11 years, 10 months ago

  By: Sean Pearce

• CHANGE TRACKING

  Hello, I am testing Change Tracking on some of the exiting tables. Have implemented CT on an existi…

  asir83

  1 replies

  11 years, 10 months ago

  By: asir83