Phil Parkin

Forum Replies Created

Viewing 15 posts - 5,191 through 5,205 (of 13,879 total)

RE: Installed edition

as1981 - Tuesday, September 12, 2017 8:44 AM
All,
We did need installation media from the reseller. Thanks for everyone's help.
Now I've hit a...

September 12, 2017 at 8:48 am

#1959129
RE: Copy records from one DB to another

Another option which may be less painless than comparing scripts is to create two identical temp tables and perform the inserts to them, one from script 1 and one from...

September 12, 2017 at 6:24 am

#1959077
RE: ssrs 2016 pivot capability over tabular models

stanteitelbaum - Tuesday, September 12, 2017 5:44 AM
Thx Steve and pietlinden. I already hooked power bi (pbi) up to the model directly...

September 12, 2017 at 5:48 am

#1959074
RE: Installed edition

alexander.huberti - Monday, September 11, 2017 12:53 PM
You can make an Edition Upgrade (see https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades) instead of reinstall. Developer Edition is...

September 11, 2017 at 12:59 pm

#1959009
RE: SSIS Packages: SQL 2012 to SQL 2016

Joe Torre - Monday, September 11, 2017 11:23 AM
Is the DDL accessible?
Joe, did you mean DLL?

September 11, 2017 at 12:04 pm

#1958998
RE: Installed edition

as1981 - Monday, September 11, 2017 10:41 AM
All,
We have a license for Standard. I installed the developer edition thinking that it was the...

September 11, 2017 at 10:47 am

#1958975
RE: How to write / Save files in Remote location using sp_OAMethod in SQL SERVER

manavairajan - Monday, September 11, 2017 8:06 AM
Hi Every one.
I want to convert blob data into normal file using SQL, So, I...

September 11, 2017 at 10:26 am

#1958971
RE: Not able to add SSIS Components to toolbox in SSDT 2015

SQL Espo - Monday, September 11, 2017 8:48 AM
I am unable to add components and/or data flow tasks into my SSIS Toolbox...

September 11, 2017 at 10:24 am

#1958970
RE: SSIS Packages: SQL 2012 to SQL 2016

John.Boehm - Monday, September 11, 2017 6:42 AM
Thanks for the reply. Yes, I should have stated in my original post that I...

September 11, 2017 at 7:20 am

#1958921
RE: SSIS Packages: SQL 2012 to SQL 2016

John.Boehm - Sunday, September 10, 2017 8:00 PM
We are testing our SQL 2012 applications against SQL 2016 to determine what (if any)...

September 10, 2017 at 8:22 pm

#1958883
RE: SSIS Package is failing with overridden

@Patrick123 - Friday, September 8, 2017 5:50 PM
Hi,
When im running the package manually it got success,running through job in 2012 its failing...

September 8, 2017 at 6:10 pm

#1958824
RE: Replace the first charatcer in a String

audrey.abbey - Friday, September 8, 2017 11:02 AM
--
Update would look something like this:
UPDATE table set column =

September 8, 2017 at 11:23 am

#1958764
RE: Foreach Loop not Looping

You need to move the data flow and file system task so that they are inside the foreach loop.
This sort of thing:

September 7, 2017 at 1:18 pm

#1958632
RE: Procedure executes even though nested sub-procedure missing or missing permissions

s b dragoo - Thursday, September 7, 2017 11:19 AM
OK. That answers what happens when the nested proc exists but is missing...

September 7, 2017 at 1:16 pm

#1958631
RE: Procedure executes even though nested sub-procedure missing or missing permissions

This behaviour is down to which is known as 'ownership chaining'. You may find this link informative.

September 7, 2017 at 10:52 am

#1958609

Viewing 15 posts - 5,191 through 5,205 (of 13,879 total)