SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• How to capture sqlscript from a specific computer while using sqlserver profiler

  There is a web-based oa system, it has an IIS application server(OA was deployed on this IIS applic…

  892717952

  7 replies

  1 week, 2 days ago

  By: Jeff Moden

• SSL Certificate

  Hi.. SSL certificate has been installed in our standalone and cluster servers . and from Registry E…

  WhiteLotus

  1 replies

  2 weeks, 4 days ago

  By: WhiteLotus

• Getting Max Date with Join Statement

  I am trying to get the max PRM_StartDate from the query below but unsure how to format the query. …

  MP-iCONN

  10 replies

  3 weeks, 4 days ago

  By: MP-iCONN

• Fixing a mismatched collation on MSDB

  Hi, I've been tasked with finding out why we've been unable to patch the SQL server on our SCCM ser…

  NoDowt

  5 replies

  2 months ago

  By: Jo Pattyn

• Bcp queryout issue

  Hi all, I am running the following query in SQL, trying to export some data to a csv file, with hea…

  kakovatos7

  5 replies

  2 months, 1 week ago

  By: kakovatos7

• Strange 'Bug'(?) with SQL Native Client 11.0 and MultiSubnetFailover

  Hi, I have a SQL Server Multi Subnet cluster across Data Centres. Yesterday I set up an availabilit…

  dbamohsin

  1 replies

  2 months, 2 weeks ago

  By: shawn

• Arithmetic overflow error converting expression to data type smallint. The state

  hi, I have started getting this message, from a stored procedure, which is not repeating, it comes …

  rajemessage 14195

  17 replies

  2 months, 4 weeks ago

  By: Ed B

• SQL SORULAR

  Selamlar, aşağıdaki sorulara cevap bulamadım. Yardımcı olabilir misiniz acaba ? 1-) SELECT TO…

  ridvanyildiz

  1 replies

  3 months ago

  By: ridvanyildiz

• SQL Server 2012 Standard Media/ISO

  Does anyone have a copy of SQL Server 2012 Standard handy? I just need the ISO or DVD contents to i…

  oldenkafe

  2 replies

  3 months ago

  By: frederico_fonseca

• query results of last full month's data

  Thanks in advance for any help. I've found similar topics but not quite sure how to do this one. I …

  DaveBriCam

  4 replies

  3 months ago

  By: Jonathan AC Roberts

• Safa Insert

  Hello, i'm looking a way to make safe insert in a table avoiding PK problems. I have a table like t…

  Alessandro Andreatta

  8 replies

  3 months, 3 weeks ago

  By: Jonathan AC Roberts

• Database details missing in SYS.MASTER_FILES view

  Hi, I noticed that one of the database information is missing in sys.master_files catalog view toda…

  sanei05

  1 replies

  3 months, 4 weeks ago

  By: Ant-Green

• SSISDB SELECT Permission was denied on object 'projects', database 'SSISDB, schema 'catalog'

  I want to post a resolution to a problem that I was having that appeared to be permission related. …

  ggoble

  4 replies

  4 months ago

  By: george

• 60 Second Rolling Avg With Different Starting Points

  Hi, I have a table with columns: jobId, timeStamp (for duration per jobId) and tempData (see attach…

  highjump231

  3 replies

  4 months ago

  By: Steve Collins

• Log Size is too high

  Hi Friends, I have been assigned to manage an SQL server pool with some standalone and with Log shi…

  Arsh

  11 replies

  5 months ago

  By: Grant Fritchey