Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Sql server 2005 --> 2014 upgrade. Risks/things to consider/etc...

  Hi, Hope I'm in the right forum. Can you help me please? I have an upgrade to do from Sql-Server…

  jellybean

  30 replies

  11 years ago

  By: jellybean

• Sql Server 2005 R2 to R4 - suggestions/advice etc...

  Hi everyone, Can you help me please? I want to do a service pack upgrade on Sql Server 2005 from…

  jellybean

  2 replies

  11 years ago

  By: Grant Fritchey

• Recover SQL Server SA Password

  I’ve forgotten the password of SA account, therefore I am not able to login to my SQL Server 2008 R…

  rawatsonika4u

  2 replies

  11 years ago

  By: Grant Fritchey

• How to get number of execution in specific time-not from first

  Hi I have this query SELECT top 100 Ltrim([text]),objectid,total_rows,total_logical_reads , executi…

  MotivateMan1394

  10 replies

  11 years ago

  By: Grant Fritchey

• I need a guideLine for Standard Database Design

  Hi We should monitor Database Objects created by development dept. in 2 views : - View , s…

  MotivateMan1394

  3 replies

  11 years ago

  By: Grant Fritchey

• Licensing cost SQL Server 2014

  It is my understanding that SQL Server 2014 is Licensing by core with a minimum of 4 cores per CPU.…

  Welsh Corgi

  8 replies

  11 years, 1 months ago

  By: EdVassie

• Guidelines to setup db part of data centre

  Hi My company is migrating all their servers to a new data centre and I get to specify what we need…

  martin 22999

  1 replies

  11 years, 1 months ago

  By: Alan Burstein

• Backup and restore issue.

  All, I am copy my databases from server A to server B by backup and restore. since I want the pro…

  BoobyB

  5 replies

  11 years, 1 months ago

  By: DeWayne_McCallie

• User Audit - XP_LOGININFO help

  I am trying to write a script that generates a user audit of users who actually can and can't acces…

  JZ-45

  2 replies

  11 years, 1 months ago

  By: JZ-45

• Copy Database Wizard fails from 2008 to 2014

  I am trying to migrate a 2008 R2 (SP1) database with one secondary data file to a separate 2014 ser…

  thotvedt

  3 replies

  11 years, 1 months ago

  By: thotvedt

• Can I lock a table only for a specific user for some seconds

  Hi I ned to do some operations on a table when any user dont work with it. How do i do it? Do i loc…

  MotivateMan1394

  8 replies

  11 years, 1 months ago

  By: Phil Parkin

• Why do I leave my DB in Restoring State after attaching to the instance?

  Hi All, Why do I leave my DB in Restoring State after attaching to the instance? Could not this fir…

  Thinky Night

  2 replies

  11 years, 1 months ago

  By: Perry Whittle

• how Do I Identify the job with the code

  I got query from sysproccesses and the result for one spid is : SQLAgent - TSQL JobStep (Job 0xF3BD…

  MotivateMan1394

  1 replies

  11 years, 1 months ago

  By: Koen Verbeeck

• I want hyperlinkFiled in my Query Result

  Hi I Have a field in my Query Result with this Value : For example "Http://www.sssss.com" I want To…

  MotivateMan1394

  3 replies

  11 years, 1 months ago

  By: Phil Parkin

• Changing Replication Topology

  I have a replicated database on 2008 R2 being moved to a new instance with 2014. Application regre…

  MMullane-222251

  2 replies

  11 years, 1 months ago

  By: free_mascot