Viewing 15 posts - 3,271 through 3,285 (of 9,715 total)
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,...
April 16, 2014 at 7:59 am
Shawn Melton (4/16/2014)
April 16, 2014 at 7:54 am
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.
April 16, 2014 at 7:48 am
Wow. I completely missed that one.
But what type of connection manager would I use for the destination?
April 16, 2014 at 7:11 am
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,...
April 16, 2014 at 6:57 am
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...
April 16, 2014 at 6:50 am
rollercoaster43 (4/7/2014)
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...
April 16, 2014 at 6:39 am
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...
April 16, 2014 at 6:35 am
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...
April 16, 2014 at 6:31 am
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....
April 16, 2014 at 6:18 am
Brandie Tarvin (4/10/2014)
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.
April 10, 2014 at 8:24 am
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.
April 10, 2014 at 8:19 am
Chris Wooding (4/1/2014)
April 1, 2014 at 4:26 am
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?
March 31, 2014 at 11:50 am
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...
March 31, 2014 at 8:33 am
Viewing 15 posts - 3,271 through 3,285 (of 9,715 total)