Does it not give you the option of entering your own server name?

If not, double-check that SQL Server Browser Service is enabled on the server (if it's a new server,...

Shawn Melton (4/16/2014)

---

If the vendor also offers secure FTP you could use SSIS to do this but would require a third party add-on or script since SSIS FTP task does...

That won't work. A file connection manager does not give me the option of using a user name and password to connect to the HTTPS server.

Thanks for the suggestion, though.

Wow. I completely missed that one.

But what type of connection manager would I use for the destination?

Another note.

Even if that one data line is bad, I don't think the CTE will work because you're using VARCHAR for the ChildID and ParentID. In such a case,...

IF OBJECT_ID('tempdb.[dbo].[#sample]') IS NOT NULL

DROP TABLE [dbo].[#sample];

create table #sample(sno int identity,ChildID varchar(30), ParentID varchar(30),task varchar(50));

--Corrected code by removing extra paren preventing table creation.

insert into #sample (ChildID,ParentID,task) values('222','111','aerospace');

insert into #sample...

rollercoaster43 (4/7/2014)

---

Hi Jeff,

Sorry to Jump in here but I was facing the same issue and thought of continuing on the thread.

I have a Stored procedure created in MAster DB which...

Did you check Jeff's other recommendations? The owner / creator of the proc being SA or someone with sysadmin perms? The database being owned by SA or an account with...

How are you "pointing" SQL Server? Is this an attempt to connect via SSMS or an actual connection string in a program?

When you say "but in place wher i point...

Agreeing with Cody here.

I learned the hard way in my first job that trying to "fix" the data for purely cosmetic reasons can and does screw with the end users....

Yes. Please post this to the appropriate forum for your SQL version under Business Intelligence or General. This is not the proper forum for this quesiton.

Chris Wooding (4/1/2014)

---

Granting execute on the schema has worked in other databases. Is it because this user is part of domain users and therefore only using those permissions rather than...

Odd question. Is there perhaps a database trigger that is rolling back any attempts at A) Executing this proc, or B) deleting data from this (or all) tables?

I think Lowell's on the right track here. It seems the jumping around has a lot to do with your issues.

If you are able to impersonate the login using this...