Forum Replies Created

Viewing 15 posts - 196 through 210 (of 774 total)

  • RE: Extracting tables from SPs

    This way:

    USE arf_etl

    GO

    SELECT OBJECT_NAME(object_id) AS referencing_object_name

    ,COALESCE(COL_NAME(object_id, column_id), '(n/a)') AS referencing_column_name

    ,*

    FROM sys.sql_dependencies

    WHERE referenced_major_id = OBJECT_ID('[bmb_ms].[usp_BMBBI_ft_estimated_sale_control_insertupdate]')

    ORDER BY OBJECT_NAME(object_id), COL_NAME(object_id, column_id);

    GO

  • RE: Extracting tables from SPs

    USE arf_etl

    GO

    SELECT OBJECT_NAME(object_id) AS referencing_object_name

    ,COALESCE(COL_NAME(object_id, column_id), '(n/a)') AS referencing_column_name

    ,*

    FROM sys.sql_dependencies

    WHERE referenced_major_id = OBJECT_ID('dbo.bmb_ms.usp_BMBBI_ft_ingredient_consumption_direct_insert')

    ORDER BY OBJECT_NAME(object_id), COL_NAME(object_id, column_id);

    GO

  • RE: Extracting tables from SPs

    When I try to use that I get empty back. No records returned

  • RE: SQL Server Management Studio

    The point is: I should have the option to join (register) Data engines, SSAS, SSIS and SSRS . Same as I have in SQL Server 2012 cliente tool. I don't...

  • RE: SQL Server Management Studio

    There are not four. Just two (database engine and compact SQL edition)

  • RE: Report Server (where does it stores the reports)

    Grest help. Thsnk you very much. Have a great new year.

  • RE: Report Server (where does it stores the reports)

    Thank you lowell.

    Just two more questions.

    1) You say that shared connections are also deployed. What about it the connections are not shared (if they belong just to that report)?...

  • RE: TempDB Log growing

    That's what I wanted to know. Thanks for clarify

  • RE: TempDB Log growing

    It goes to almost 100 and then starts again from 0

  • RE: SQL Compact - Set reinicialize method = true

    I don't think so.

    I think that there is a method with that name that needs to be called and after that just use another method name synchronise.

    Any one can...

  • RE: Snapshot agent

    Ok. So, once the initial snapshot has been applyed on the subscriber it is no longer needed according to your explanation.

    So, Way are they gereration new snapshots from 3 to...

  • RE: Log addind

    Also, using tthis quey to see stats:

    WITH [Waits] AS

    (SELECT

    [wait_type],

    [wait_time_ms] /...

  • RE: Suspended

    Canot be lack of disk perfortmance what is causing this ?

  • RE: Suspended

    Another piece of the log:

    2015-11-13 17:00:18.99 Backup Log was backed up. Database: DatabaseName_Central, creation date(time): 2014/04/12(07:23:44), first LSN: 18637:4063:1, last LSN: 18647:2210:1, number of dump...

  • RE: Suspended

    The resource wait on the activity monitor is very high for the logging:

    With wait time and recent wait time above 16000

Viewing 15 posts - 196 through 210 (of 774 total)