SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• most valuable company's database

  I am a worker in IT company. One of my tasks is to handle our database in MS SQL Server. But some d…

  ChloeSanchez

  3 replies

  8 years, 2 months ago

  By: Arsh

• how to determine the locale of sql sever

  Im developing a web app in azure and we have an instance of sql server hosted in a VM in an azure e…

  solus

  2 replies

  8 years, 2 months ago

  By: Arsh

• SQL Server - It's not really a Mailer Service, is it?

  I'm not entirely sure if I'm looking for an answer or an opinion here, sorry. The topic started off…

  Thom A

  6 replies

  8 years, 2 months ago

  By: Thom A

• Updating SQL table from external source

  Hi,  I am not sure if this post is meant to be in this thread so apologies in advance.  I…

  ExhibitA

  2 replies

  8 years, 2 months ago

  By: ExhibitA

• Optimize query that is using like statements

  I currently have a large query which is taking over an hour to run, and am attempting to optimize. …

  ollyjolly

  10 replies

  8 years, 2 months ago

  By: Alan Burstein

• How can I use data returned from a query to delete files on my network?

  Hi all At my workplace, we use a SQL Server based application - Dynamics AX. Using this application…

  Naz

  4 replies

  8 years, 2 months ago

  By: Lowell

• Max isn't working in my query

  Hello, I have this script which is an extract of my database. I don't design it, so the structure w…

  team.bernard

  6 replies

  8 years, 2 months ago

  By: Chris Harshman

• Failed to create AppDomain "mssqlsystemresource.dbo[runtime].3". - SQL ERROR LOG

  Error :Date  8/8/2017 12:39:47 PM .....Source  spid62MessageFailed to create Ap…

  Abhishek

  5 replies

  8 years, 3 months ago

  By: Perry Whittle

• Login failed for user' has occurred in SSMS

  Hello. I can not connect from SSMS using sql users from a computer with windows 10 (let's say …

  l.ambrozie

  7 replies

  8 years, 3 months ago

  By: Thom A

• SQL Query Doubt/Clarification?

  I would like to write a query against one table which gives unique value from "pm_process_guid" for…

  venkatraj.evr

  2 replies

  8 years, 3 months ago

  By: John Mitchell-245523

• Audit script for sqlserver to include: logins, permissions, last login date, last password change

  Hi I am looking for an Audit script for sqlserver to include: logins, permissions, last l…

  caz100

  12 replies

  8 years, 3 months ago

  By: richardmgreen1

• Scripting to a Server That Requires a Gateway

  We have a set of remote SQL Servers (2012) that are PCI and, when we rdp, require us to go through …

  Whisper9999

  2 replies

  8 years, 3 months ago

  By: Whisper9999

• Search a string in entire datababe

  Is there a script to search a string stored in all cell of all tables?For example, I want to find o…

  adonetok

  9 replies

  8 years, 3 months ago

  By: adonetok

• SET NOCOUNT ON at instance level - not working.

  Hello Members, I have configured nocount as default connection property using following command. EX…

  GroverVivek

  9 replies

  8 years, 3 months ago

  By: Gail Shaw

• sys.master_files and sys.database_files difference

  for one of my critical database , physical name for sys.database_files and sys.master_files doesn't…

  Abhishek

  4 replies

  8 years, 3 months ago

  By: Abhishek