Forum Replies Created

Viewing 15 posts - 661 through 675 (of 13,460 total)

  • RE: SQL Static Port

    the browser service helps application sort out the right place to connect.

    so assume that something is connecting with a connection string like this, and your sole SQL server...

    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!

    January 31, 2017 at 8:25 am

    #1925876

  • RE: SQL Static Port

    I'm a bit confused by what you mean when you say "Not sending data" when connecting via a port vs working file when using a named instance. i would expect...

    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!

    January 31, 2017 at 8:16 am

    #1925873

  • RE: SQL Static Port

    are you sure you've assigned a static port in the SQL configuration manager?
    The SQL Browser Service tells incoming connections to your instances which port to use, whether it's static...

    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!

    January 31, 2017 at 8:05 am

    #1925869

  • RE: SELECT timestamp in 20 second intervals

    i think your group by needs to round the timestamp to your interval of  20 seconds(DATEPART(SECOND, datetimestamp) %20, i think?)  or at least to the nearest minute, which is a...

    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!

    January 31, 2017 at 7:11 am

    #1925845

  • RE: Missing Records in Dimension Causing Incorrect Results

    I've seen far too many SSAS experts leave out foreign keys in the sources they build to fill the cubes,because they think the source it's coming from already has referential...

    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!

    January 30, 2017 at 4:55 am

    #1925572

  • RE: T-SQL help needed ....How do we copy schema objects from one schema to another ?

    COPY or MOVE? there's a difference!
    copy duplicates the data, so you have to script all the objects out, change the schema in that script , and create the objects...

    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!

    January 27, 2017 at 6:25 am

    #1925305

  • RE: T-SQL help needed ....How do we copy schema objects from one schema to another ?

    mw112009 - Thursday, January 26, 2017 2:16 PM

    So I created a new schema. Now I need to move the stored...

    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!

    January 26, 2017 at 2:37 pm

    #1925201

  • RE: AD Security Groups and Application Roles

    chris_barnhart - Tuesday, January 24, 2017 9:07 AM

    Good Morning All,
    I searched the forum and only found relevant posts from many, many years...

    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!

    January 24, 2017 at 10:38 am

    #1924681

  • RE: Dynamic SQL Help needed: Why doesn't this work?

    craig.bobchin - Tuesday, January 24, 2017 10:07 AM

    i believe the specific error/issue is here:
    @command1='INSERT #Sou

    it has to be marked with...

    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!

    January 24, 2017 at 10:31 am

    #1924679

  • RE: Really Bizzare Flat File Destination issue

    is your file name you are writing to dynamic? Did you modify your flat file destination to have an expression that points to what the dynamic file name should be?

    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!

    January 23, 2017 at 2:28 pm

    #1924476

  • RE: retrieving global variable for trigger

    you said I opened a new query window and ran this:

    select convert(nvarchar(64),context_info())

    the context_info is session specific, similar to a temp table.
    so if i call a...

    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!

    January 23, 2017 at 1:37 pm

    #1924465

  • RE: Identify Text in Stored Procedures to include Table Name

    duplicate post.
    no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.
    the "Latest Posts" link shows us everything.
    continue...

    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!

    January 23, 2017 at 8:21 am

    #1924404

  • RE: How to find same data for all the columns in a table

    the classic way would be to use GROUP BY HAVING count >  1

    SELECT
    Col1,Col2,Col3,Col10Or12
    FROM
    YourTable
    GROUP BY Col1,Col2,Col3C,Col10Or12
    HAVING COUNT(*) >...

    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!

    January 20, 2017 at 1:04 pm

    #1924142

  • RE: retrieving global variable for trigger

    if you can modify the stored procedure, you could populate the VARBINARY(128) CONTEXT_INFO property.

    that value is session based, i believe, so if the application calls a proc, and...

    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!

    January 20, 2017 at 7:56 am

    #1924043

  • RE: DBmail shut down and how to audit.

    anzz - Thursday, January 19, 2017 2:17 PM

    Thanks for the reply. 

    how to monitor DBmail, I mean in terms of audit if 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!

    January 19, 2017 at 2:43 pm

    #1923880

Viewing 15 posts - 661 through 675 (of 13,460 total)