SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Closest less date

  Hi, I'm search for a solution how to find the nearest less date to a given date. Here is a example:…

  rb76

  6 replies

  10 years ago

  By: Cadavre

• Function to convert a datetime value into a harvest season year

  Hi guys, I'm from a vba background and I'm looking to use an SQL function to convert a datetime val…

  joe-584802

  21 replies

  10 years ago

  By: Jeff Moden

• Data recovery from system or application crashes

  Hi, Can anyone please let me know what are the steps to recover the database after system is crashe…

  sneaulal

  9 replies

  10 years ago

  By: Brandie Tarvin

• where can i get complete information about security and permissions in sql server

  hi any one can suggest me i want to learn the complete details of security regarding logins,permi…

  naveenareddy

  1 replies

  10 years ago

  By: Steve Jones - SSC Editor

• Date data manipulation.

  I have the following data ID startDate EndDate 1 1/1/2001 1/9/2001 2 3/1/2001 …

  sql_2005_fan

  4 replies

  10 years ago

  By: Jeff Moden

• Is there a way to extract certain parts of data

  For example...I have fields that return: MG MG/5ML MCG/0.5ML MG/ML I just need to extract the numbe…

  cory.bullard76

  5 replies

  10 years ago

  By: Luis Cazares

• Problem with update in procedure

  Hello, Can anyone explain why the following queries lead to different results ? Testing environmen…

  siarsko

  6 replies

  10 years ago

  By: Terje Hermanseter

• Long running queries more than 24 hours

  I am trying to pull details and send to email with HTML format. Requirement is to report details of…

  - Win

  14 replies

  10 years ago

  By: - Win

• Licensing Question

  Is there a difference in licensing for SQL Server for installing the SQL Native Client on a server …

  Brandie Tarvin

  7 replies

  10 years ago

  By: Brandie Tarvin

• how can i install and configure smtp server/services

  Hi how can i install and configure smtp server/services. i installed only sql server 2012 software.…

  naveenareddy

  21 replies

  10 years ago

  By: Brandie Tarvin

• SQL Server 2012 table structure

  Hello, I have this table structure: I have primary keys on [V] and [CA] but I am able to insert dup…

  PJ_SQL

  8 replies

  10 years ago

  By: PJ_SQL

• Should DBA grant developer access to system tables?

  A developer wants to create a front-end application that presents job scheduling information from t…

  HookSQLDBA7

  7 replies

  10 years ago

  By: Steve Jones - SSC Editor

• transactional replication slowdown

  hello a few days ago we had a network issue and caused a pk violation against a couple of replicate…

  lilywhites

  1 replies

  10 years ago

  By: gfoxxy93

• Impact of trace flag 272 on SQL Server 2012 apart from disabling identity jump

  I am upgrading my application's SQL Server from 2008 R2 to 2012. As discussed in the below URL I am…

  ghoshal.soumyadeb

  9 replies

  10 years ago

  By: Igor Micev

• Copy Database Backup from One Server to Another

  Hi, On one of our servers, we run weekly Full backup (through Maintenance Plan) for all databases o…

  ajay.g

  3 replies

  10 years ago

  By: Jeff Moden