SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• How to split records evenly into 4 tables from one table is sql

  Hi, I have to design solution that will help me out to load data into 4 tables from 1 master table.…

  Learner44

  7 replies

  9 years, 12 months ago

  By: TheSQLGuru

• Help me find this constraint and remove it ? - Syntax Help

  Hello Please see attached. I need to DROP the MEMBER_IN table and recreate it. Can you help me with…

  mw_sql_developer

  1 replies

  9 years, 12 months ago

  By: Luis Cazares

• leaving a SQL Agent job as failed

  The SQL Agent jobs that are set up where I work all have a final step labeled 'complete.' This ste…

  inevercheckthis2002

  2 replies

  9 years, 12 months ago

  By: inevercheckthis2002

• ATTACH Rebuild Log

  Hi All If a database has been cleanly shutdown, detached and the transaction log deleted. Is there …

  SQLSACT

  1 replies

  9 years, 12 months ago

  By: Gail Shaw

• Need help calculating percentages between rows in a dataset

  Hello, I'm relatively new to SQL, having been primarily a SAS user in the past. I've having a hard…

  c_cox46

  2 replies

  9 years, 12 months ago

  By: pietlinden

• How to take string and turn into multiple rows

  Hello, I am looking to turn a string into multiple rows of data. For example, my data is: ID STR 1…

  rjjh78

  1 replies

  9 years, 12 months ago

  By: Luis Cazares

• Function that concatenate for multiple types and evaluates field length

  Hello, I am trying to create a function that will: 1. Concatenate email by email type 2. Limit the …

  rjjh78

  2 replies

  9 years, 12 months ago

  By: rjjh78

• SQL Cluster

  I have four node active-active cluster. Let's say I have two servers A11,A12,A21,A22 and they need …

  PJ_SQL

  1 replies

  9 years, 12 months ago

  By: lsalih

• AS400 to SQL via SSIS

  I've inherited a process that imports AS400 to SQL. The process pulls it in and dumps it to text f…

  SQLHeap

  1 replies

  9 years, 12 months ago

  By: SQLHeap

• Stored Procedure Permission Issue db_executor

  Hi there, Very sorry if I am posting this in the wrong sections. I am stuck on a reporting issue wi…

  Rudu.Jobs

  5 replies

  9 years, 12 months ago

  By: Rudu.Jobs

• SQL Server dynamic script to grant access to objects in database

  Hello Team, Any one have dynamic script to grant permissions to specific table or stored proc or vi…

  Sgar...

  3 replies

  10 years ago

  By: spaghettidba

• Is ADDYs Focus Safe? Where do I get it?

  The ADDYs Focus supplement is constructed from effective active ingredients which is accumulated fr…

  TeresaValerie38

  1 replies

  10 years ago

  By: TeresaValerie38

• 2 SQL Tracefiles on startup

  Hi Guys I have 2 trace jobs running on start up 1 is the defailt trace file, the other tracefile I …

  alnor

  19 replies

  10 years ago

  By: alnor

• Login can't be deleted because it granted permissions

  I'm trying to delete an individual login from a server but am failing because the login "has grante…

  Brandie Tarvin

  16 replies

  10 years ago

  By: Brandie Tarvin

• My Computer says I already have a default Instance

  Hello, I forgot that I can only install Enterprise Edition on Windows Server. I have Windows 10 Pro…

  Jacob Pressures

  3 replies

  10 years ago

  By: Beatrix Kiddo