Forum Replies Created

Viewing 14 posts - 1 through 14 (of 14 total)

  • RE: checkdb error in master database

    prettsons (3/6/2012)


    The DBCC command finishes but reports problem about data inconsistency. If this is the case, you will have to clean the database to remove the inconsistencies and then attempt...

  • RE: checkdb error in master database

    GilaMonster (3/5/2012)


    I would recommend restore from a clean backup.

    That is my thought as well ... it is just a pain to get downtime for this system,

    particularly if no users...

  • RE: missing msp files

    I reviewed several articles on replacing the msp files. For what ever reason I was not able to get instructions from the previous one to produce results. However the script...

  • RE: policy based management for the STIGS

    Eventually I managed to get this to work though it is not clear to me why. This morning I thought the issue was related to the double quotes, because if...

  • RE: Reporting Services Disaster Recovery

    I am wondering the same thing. Did you ever get an answer to this?

  • RE: Query using a dynamic date range

    Ramesh (4/2/2009)


    If you have Tally or Numbers table then you can loop through them to form a dynamic PIVOT clause (or SQL) and execute it using EXECUTE or sp_executesql statements.

    What...

  • RE: not both

    OK, thanks.

    I was trying different variations on this and did not realize you can negate multiple arguments in that way.

  • RE: SQL Server 2000/2005 Security Audit Scripts

    Looks like a helpful article ... I just wish the scripts had uploaded.

  • RE: SQL Overview SSIS Package III - Full Package

    Hi,

    I love this SSIS package. However because I have over a thousand SQL Servers that I would like to monitor I am breaking it in to smaller parts. I...

  • RE: SQL Overview SSIS Package III - Full Package

    David Bird (7/28/2008)


    Here are somethings to check

    Thanks for the detailed reply.

    What I actually wound up doing was buiding the project a little bit at a time in another Visual Studio...

  • RE: SQL Overview SSIS Package III - Full Package

    In table Database_Info, what are the meanings of the columns Size and SpaceUsed? Size and SpaceUsed are not exactly the same, so what is it that makes them different?

  • RE: SQL Overview SSIS Package III - Full Package

    David Bird (7/24/2008)


    You might want to look at the discussions for SQL Overview Part I for additional ideas on how to fix the MultiServer issue.

    The article provides details on...

  • RE: SQL Overview SSIS Package III - Full Package

    Hey, I am having trouble with the MultiServer connection manager in the SQL_Overview_Package. It is having trouble making an initial connection. I have tried to configure the MultiServer connection manager...

  • RE: Daylight Saving Time

    What about the datediff type functions? The differences between times will change when the period of daylight saving time changes.

Viewing 14 posts - 1 through 14 (of 14 total)