Forum Replies Created

Viewing 15 posts - 3,601 through 3,615 (of 5,109 total)

  • RE: Is it Okay to Use Visual Studio 2012 with SQL Server 2016?

    SQL Server 2016 requires SSDT 2016 to be able to deploy SSIS, SSRS, SSAS projects. Unless I'm mistaken, SSDT 2016 is only supported in VS 2015 onwards. I would imagine...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Creating Identity column reorders table

    Tables are not ordered to start with. How are you defining your current "order". Alphabetically?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Help Needed in Date Logic Query

    HappyGeek raises a good point here. If you want meaningful answers, you need to provide meaningful sample data. According to your data, 2649 visits all happened at exactly 21:35:37 on...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Changing default Language for a database - Interesting

    As a thought, probably a long shot, but I wonder if a column in your database has a different collation to the actual database. Does this yield any results?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Stop Duplicates - SQL Task - SSIS 2010

    What are you trying to use the variable to do exactly? In SSIS you reference a variable by using the following expression:
    @[User::YourVariableName]

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: SQL Server is Lagging a Bit

    Rod at work - Wednesday, June 28, 2017 8:00 AM

    Just curious to know, do other people here declare columns as VARCHAR and...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    Sergiy - Wednesday, June 28, 2017 7:08 AM

    Jeff Moden - Wednesday, June 28, 2017 6:55 AM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Populate table with column retrieved from a stored procedure using SET processing

    Just as a side note, you can't use SET to set the value of multiple variables. You either need to use SET, and do one at a time, or use...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Untrusted Constraints

    alex.sqldba - Wednesday, June 28, 2017 4:41 AM

    Thom A - Wednesday, June 28, 2017 4:23 AM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Untrusted Constraints

    Issuing a command of NOCHECK does change the is_not_trusted value for me, however, you could also make double sure my inserting an untrusted record:
    USE DevTestDB;
    GO

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: SSRS report takes more time

    Just to chime in a little, is SSRS hosted on the same server as the SQL Server engine? If so, how much of the resources is SQL using? Is it...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: How to convert english to arabic in Sql Server 2012?

    Database's don't recognise languages; to them a "female" and "femelle" are just two strings (one 6 characters, one 7). If you need to change the language...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Email report (letter) to specific email

    Those are your versions, I asked for Licence type. Do you have Express, Standard, or Enterprise?

    If you have Enterprise, you should be able to achieve something with

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: SQL server Analysis services getting stopped

    Sue_H - Tuesday, June 27, 2017 8:22 AM

    My apologies - I forgot this one changed a couple of times and is...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Email report (letter) to specific email

    maria.lindquist - Tuesday, June 27, 2017 8:16 AM

    When I asked the forum about creating letters as report they suggested it could be...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 15 posts - 3,601 through 3,615 (of 5,109 total)