Forum Replies Created

Viewing 10 posts - 1 through 11 (of 11 total)

  • RE: SAN and Fragmentation

    If possible you can backup the databases on the drives that are fragmented, delete the databases from the drives, defrag (it'll take seconds if the drive is empty) and then restore from the backups. ...

    37SOLUTIONS
    We'll find the solution that's right for you!
    Website Hosting | Website Design | MSSQL/MySQL Hosting | Database Development | Research/Consulting

  • RE: Documenting your SSIS package

    Everything is still in view it's just that the objects are arranged all nice and neat in the top left corner while the annotations are left exactly where I placed...

    37SOLUTIONS
    We'll find the solution that's right for you!
    Website Hosting | Website Design | MSSQL/MySQL Hosting | Database Development | Research/Consulting

  • RE: Documenting your SSIS package

    I haven't had any problems with corruption when using annotations.  But when I select Format | Auto Layout | Diagram from the menu bar the annotations are left in limbo while...

    37SOLUTIONS
    We'll find the solution that's right for you!
    Website Hosting | Website Design | MSSQL/MySQL Hosting | Database Development | Research/Consulting

  • RE: Why does column default look like this - ((0))

    Yeah, that's weird.  It only happens after you save the table.  And when you script the table the double parens are listed there too.

    37SOLUTIONS
    We'll find the solution that's right for you!
    Website Hosting | Website Design | MSSQL/MySQL Hosting | Database Development | Research/Consulting

  • RE: SSIS error when doing Fiuzzy Grouping

    Do you have SQL Server 2005 SP1 installed on both machines?  There was a memory leak problem with Fuzzy Lookup/Grouping that SP1 fixed.

    I'm sure I've run across this error during my...

    37SOLUTIONS
    We'll find the solution that's right for you!
    Website Hosting | Website Design | MSSQL/MySQL Hosting | Database Development | Research/Consulting

  • RE: 180-day Evaluation Edition - SQL Management Tools

    Unfortunately that won't work because I need to use it with Integration Services, Report Services and SQL Server Agent.  But thanks anyway!

    http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en

    "SSMSE cannot manage Analysis Services, Integration Services, SQL Server...

    37SOLUTIONS
    We'll find the solution that's right for you!
    Website Hosting | Website Design | MSSQL/MySQL Hosting | Database Development | Research/Consulting

  • RE: Multiple Filegroups

    Perfect, thanks!!!

    37SOLUTIONS
    We'll find the solution that's right for you!
    Website Hosting | Website Design | MSSQL/MySQL Hosting | Database Development | Research/Consulting

  • RE: DBO Objects without allowing db_owner/sysadmin

    Thanks everyone for your responses!

    37SOLUTIONS
    We'll find the solution that's right for you!
    Website Hosting | Website Design | MSSQL/MySQL Hosting | Database Development | Research/Consulting

  • RE: Report Generation

    If you have the budget, MicroStrategy is amazing for sites that need heavy duty reporting. Check out http://www.microstrategy.com. They have a good flash demo with narration.

    37SOLUTIONS
    We'll find the solution that's right for you!
    Website Hosting | Website Design | MSSQL/MySQL Hosting | Database Development | Research/Consulting

  • RE: SQL Password Guessing Tool

    Not bad; very fast. Now all I need is a dictionary list.

    37SOLUTIONS
    We'll find the solution that's right for you!
    Website Hosting | Website Design | MSSQL/MySQL Hosting | Database Development | Research/Consulting

Viewing 10 posts - 1 through 11 (of 11 total)