Forum Replies Created

Viewing 15 posts - 1,366 through 1,380 (of 13,460 total)

  • RE: Get count of last consecutive rows with 0 value

    because this looks a bit like homework, let me throw out suggestions and not the solution.

    the key here is that you need to test consecutive values. to do that, you...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 23, 2015 at 6:28 am

    #1841680

  • RE: Reduce core on SQL Server 2005

    GilaMonster (11/23/2015)

    Then you'll need to disable the cores in the server's BIOS, If the cores are visible to Windows, they have to be licensed. Ask the sysadmins to do the...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 23, 2015 at 6:13 am

    #1841674

  • RE: SSIS -- Need to down load file from HTTPS server using ssis

    ok, if it's dynamic, it a pain, but doable. so much of it depends on the page that is presented with the listof files, because you have to extract them...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 23, 2015 at 6:09 am

    #1841673

  • RE: SSIS -- Need to down load file from HTTPS server using ssis

    If you know the file name(s),there's quite a few articles on how to do this either via the SSIS component or a script task; i saw a lot in the...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 23, 2015 at 5:31 am

    #1841657

  • RE: DDL Trigger Error

    Could you be raising an error but left off the rollback tran command?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 20, 2015 at 2:16 pm

    #1841465

  • RE: DDL Trigger Error

    the core error is that xml is case sensitive, but you capitalized some of the values.

    SELECT

    @edate=GETDATE(),

    ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 20, 2015 at 1:18 pm

    #1841453

  • RE: Tune SQL Query with very large tables

    reformatted for readability, still looking at the code....

    offhand, because of the OR statements turnign this into a catch all query, i think this should be multiple queries that insert into...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 20, 2015 at 10:20 am

    #1841408

  • RE: Script task experts welcome

    caojunhe24 (11/20/2015)

    And I saw some people had same issue with job agent and they solved problem by making folder as shared folder. But the point is my folder is in...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 20, 2015 at 7:25 am

    #1841354

  • RE: Script task experts welcome

    caojunhe24 (11/19/2015)

    everyone has access permission on that folder and if I create a job then will use my account credential to run that job anyway I guess. And like I...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 20, 2015 at 5:43 am

    #1841322

  • RE: Error: Could not allocate space for object ..because the primary filegroup is full

    the error is fairly straightforward, tempdb ran out of space.

    Typically this is because tempdb auto expanded until it literally fill up the disk is is on.

    That assumes you have one...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 19, 2015 at 11:16 am

    #1841111

  • RE: Deny create table in [dbo] schema

    sounds like every user is in the db_owner role, so that's most likely the issue.

    remove all permissions assigned to an existing user, and start fresh.

    something like this is what you...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 19, 2015 at 10:35 am

    #1841087

  • RE: Script task experts welcome

    if the script task is counting files on some file share like \\servername\sharename, does the account[MEDASSURANT\BPA_UAT_DS] have access to that share? is that a domain account?

    when you run it locally,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 19, 2015 at 10:08 am

    #1841070

  • RE: How to DELETE Thumbs.db File?

    caojunhe24 (11/19/2015)

    I have a script task in my SSIS package and count file numbers in the folder but always return mecount = 1 even if there is no file placed...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 19, 2015 at 9:55 am

    #1841066

  • RE: Primary key and unique indexes question

    doesn't a modificiation featuring these three constraints satisfy the requirement?

    i read "but VhID and PrID can be the same in one row so long as ExtID is different" as unique...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 16, 2015 at 5:34 am

    #1839918

  • RE: SQL Server Express 2014 Agent does not start on Windows 10 Home

    SQL Express does not include the SQL Agent. it does nto get installed, and that's the reason for the error.

    if you need agent, you need either the developer edition(~50 USD...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 15, 2015 at 2:01 pm

    #1839858

Viewing 15 posts - 1,366 through 1,380 (of 13,460 total)