Forum Replies Created

Viewing 15 posts - 61 through 75 (of 284 total)

  • RE: Query to show Database Objects last change

    MyDoggieJessie (3/17/2015)

    Not sure if this is something you're looking for but I recently posted a process on SSC to track these types of things. Feel free to check it...

    March 18, 2015 at 7:18 am

    #1784754

  • RE: Query to show Database Objects last change

    Thanks for your help.

    March 17, 2015 at 10:47 am

    #1784550

  • RE: Query to show Database Objects last change

    GilaMonster (3/17/2015)

    No, SQL doesn't track object change history.

    You can look at sys.objects in each database and look at the create_date and modify_date, but I think there are things you can...

    March 17, 2015 at 9:07 am

    #1784527

  • RE: Changing Order by

    CASE figures out what type it is returning before the query is executed. It is not expecting to get different types for different rows. If thats what you give...

    March 11, 2015 at 10:40 am

    #1783388

  • RE: Changing Order by

    For some reason it is trying to convert my data type to a number... one is varchar and the second is an ID field.

    , CASE @Sort_Sel

    WHEN 'Resource' THEN R.RESCODE

    ELSE D3.DATEID

    END...

    March 11, 2015 at 7:25 am

    #1783267

  • RE: Changing Order by

    Thanks... did not know you could put case into ORDER BY ... it is a good day when you learn something new..

    March 11, 2015 at 7:00 am

    #1783256

  • RE: Avoid using a Cursor

    Thanks for both of your replies.. During lunch I read through the article. Will try and get back to this project tomorrow.

    David

    January 22, 2015 at 11:29 am

    #1772346

  • RE: Jobs Deadlocked

    Ok thanks.. got misled by it stating job step.

    November 21, 2014 at 6:59 am

    #1760109

  • RE: Using SSIS 2008 to handle file retention

    BTW I created a script task for each server, that way I could disable a server's removal of database files if needed (this came up last week and we needed...

    November 20, 2014 at 7:02 am

    #1759824

  • RE: Using SSIS 2008 to handle file retention

    I did finally get the C# syntax for 2008... so this is what I ended up with, in the script task box. Note it connects to our file and print...

    November 20, 2014 at 6:55 am

    #1759819

  • RE: Problem with creating a Index on a temp table

    DonlSimpson (11/12/2014)

    Since it's a one column key, you can put the constraint on the column definition:

    CREATE TABLE [dbo].[#ShipTo]

    ([Ship_to_Num] [int] not null PRIMARY KEY CLUSTERED,

    [Country_key] [nvarchar](3) NULL)

    Forgot about that.......

    November 12, 2014 at 2:48 pm

    #1758102

  • RE: Problem with creating a Index on a temp table

    dogramone (11/12/2014)

    Get rid of the square brackets after the word constraint. So instead of "CONSTRAINT [] PRIMARY KEY CLUSTERED " have "CONSTRAINT PRIMARY KEY CLUSTERED "

    Ok, thanks...

    CREATE TABLE...

    November 12, 2014 at 2:44 pm

    #1758100

  • RE: Problem with creating a Index on a temp table

    Gail,

    How do you not name the constraint?

    I get the following error : An object or column name is missing or empty.

    If I try the following:

    CONSTRAINT [] PRIMARY KEY CLUSTERED

    (

    [ship_to_Num]...

    November 12, 2014 at 1:38 pm

    #1758089

  • RE: Excel Data Source Fails

    Phil Parkin (9/11/2014)

    dwilliscp (9/10/2014)

    Does anyone know how to fix this problem?

    SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE...

    September 13, 2014 at 5:36 pm

    #1745295

  • RE: Win7, Two Monitors and SSMS

    DeWayne_McCallie (9/4/2014)

    I just click in the window on Monitor #2 (SSMS) to change the focus to the window I want to type in and then type away.

    That is the way...

    September 5, 2014 at 9:35 am

    #1743555

Viewing 15 posts - 61 through 75 (of 284 total)