Forum Replies Created

Viewing 15 posts - 3,271 through 3,285 (of 9,720 total)

  • RE: Use SSIS or SQL Server Agent to post to HTTPS site

    GAH.

    Is this Powershell error normal?

    Microsoft Team Foundation Server 2008 Power Tools\TFSSnapin.ps1 cannot be loaded because running scripts is disabled on this system.

    It gives me a link for execution polices on...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Use SSIS or SQL Server Agent to post to HTTPS site

    Powershell will do this?

    ROCK ON. I've been looking for an excuse to learn this. Thanks for the links and the reference.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Use SSIS or SQL Server Agent to post to HTTPS site

    I'm assuming so. The link they point to in their help document is http://www.w3.org/TR/html4/interact/forms.html.

    HelpDoc


    For automatic submission, post the embedded file over HTTPS using multipart/Form-data (MIME) encoding.

    It tells me to have...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Sql network name

    Beyond repeating what I've told you about permissions and SQL Server Browser Service, the only other thing I can recommend is that you call your software vendor or go to...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: xp_create_subdir for non-sysadmins

    Jeff Moden (4/16/2014)


    Brandie Tarvin (4/16/2014)


    I answered the OP before I fully read your post. Searching your error on Google, I found this article from TechNet. Does it help resolve your...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Sql network name

    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,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Use SSIS or SQL Server Agent to post to HTTPS site

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Use SSIS or SQL Server Agent to post to HTTPS site

    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.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Use SSIS or SQL Server Agent to post to HTTPS site

    Wow. I completely missed that one.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: recursive structure.

    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,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: recursive structure.

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: xp_create_subdir for non-sysadmins

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: xp_create_subdir for non-sysadmins

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Sql network name

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: SQL script to LOOP in and find sequence gap on Unique column

    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....

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 3,271 through 3,285 (of 9,720 total)