SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Help with a simple TSQL script to open and save an Excel file.

  I have an SSRS report that exports to a specific folder on a scheduled basis.  There's a probl…

  Karen Grube

  26 replies

  8 years ago

  By: Sue_H

• R Services

  Hi.. I'm installing R services for the first time.. I have a few questions Please assist 1. If we u…

  atulyan.aries

  1 replies

  8 years ago

  By: Steve Jones - SSC Editor

• Inner Joins

  Hello ! I was just wondering is there some sort of methodology that you would use with T-SQL inner …

  Data Rat

  2 replies

  8 years ago

  By: sgmunson

• To CASCADE DELETE or not?

  There is a healthy debate going on between a couple teams in my area regarding the use of the casca…

  Orlando Colamatteo

  5 replies

  8 years ago

  By: jcelko212 32090

• Anyone have a script that will script out all server/database-level permissions for a specific login, across ALL databases?

  Hi there  I have gathered a number of scripts over the years that give me partial info but wha…

  doodlingdba

  2 replies

  8 years ago

  By: Thom A

• Proxy account not working in stored procedure

  I have a stored procedure that uses xp_cmdshell to copy a file from one folder to another (right no…

  jack_walker

  15 replies

  8 years ago

  By: Sue_H

• R Code error with SSIS: 'ts' object must have one or more observations

  My first attempt in R Server using SSIS to run R code predictive modeling. I'm running the followin…

  oroman1026

  5 replies

  8 years ago

  By: sgmunson

• SSIS Visual Studio 2017 Toolbox

  Hi,I just recently migrated my SSIS packages to the 2017 version.  As I have been going throug…

  skaggs.andrew

  2 replies

  8 years ago

  By: skaggs.andrew

• SQL Server Database Tests / Changing Server

  We use database tests in our CI environment and these are configured to run on our QA server. This …

  Phil Parkin

  7 replies

  8 years ago

  By: RAThor

• SSIS package error

  Currently in my org there is some migration activity going on from sql 2012 to 2016.So currently th…

  samal.sidharth221

  6 replies

  8 years ago

  By: sgmunson

• Convert varchar to datetime

  Hi, I'm getting 20180401 111843 varchar value from a table, and I have to convert it to date t…

  hoseam

  3 replies

  8 years ago

  By: Grant Fritchey

• Find dialog box too small

  Hi,    does anybody  know how to change the size of this dialogo box? &nbs…

  Mauricio_

  10 replies

  8 years ago

  By: Mauricio_

• Converting a MS Access query to SQL

  I am attempting to move a database from MS Access to SQL Server. For the most part things have gone…

  ordnance1

  3 replies

  8 years, 1 months ago

  By: Luis Cazares

• Select All Records Where Date Falls Within Next Week

  Id like to run query that would display records where the Build Day occurs next week. So if I run a…

  netguykb

  2 replies

  8 years, 1 months ago

  By: Jeff Moden

• Does a Unique Constraint Store the Row Identifier at the leaf level of the b-tree

  Given that a unique constraint essentially creates a unique non-clustered index on the table, does …

  DimUser

  1 replies

  8 years, 1 months ago

  By: Eric Isaacs