Forum Replies Created

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

  • RE: SSRS Connection Issues

    Thanks for the links.

    I finally gave up and just went thru each of the little steps in the report server configuration tool and clicked the 'apply defaults' button. (which...

  • RE: SSRS Connection Issues

    I haven't set up share point integration or the e-mail settings, or backed up the encryption keys, but I wouldn't think those would stop it from working. Everything else...

  • RE: SSRS Connection Issues

    It seems to be OK.

    I get a decent looking error screen and not just a nasty 404 page or something, and if I just go to http:/// I...

  • RE: My Modelog.lgd file is too large

    Jeffrey Williams (7/17/2009)


    Jason Shadonix (7/17/2009)


    If I'm counting over to the right column, then for the data file you have 856 Pages (under 8MB) and only have 96 Pages (< 1MB)...

  • RE: My Modelog.lgd file is too large

    If I'm counting over to the right column, then for the data file you have 856 Pages (under 8MB) and only have 96 Pages (< 1MB) in the log file....

  • RE: My Modelog.lgd file is too large

    Maybe run this:

    select * from msdb.sys.database_files and post the results?

    Also might be worth considering turning the default auto-grow settings off or resticting the growth quite a bit. In...

  • RE: My Modelog.lgd file is too large

    Since this is a dev/test box, might try making the model database read-only and see what breaks.

  • RE: My Modelog.lgd file is too large

    h_maksuda (7/16/2009)


    I'm worried about my model db log file. And I'm not using this bd for anything still it's growing faster.

    So I'm worried. What causing my model log...

  • RE: Adventureworks Install Woes

    Thanks for the tips. Turns out I'm dense, and had the FullText service for another instance started, but not the instance I was installing on. Once I started...

  • RE: Database Mirroring Issue

    Mani Singh (6/17/2009)


    What are the SQL Server Service accounts (local or domain accounts)

    Are the DB compatibility modes same for both the databases.

    What is the service pack levels and SQL server...

  • RE: Database Mirroring Issue

    Mani Singh (6/17/2009)


    For teh timeoout error do this:

    in Query window: on principal server do this:

    ALTER DATABASE "Db name here" SET PARTNER TIMEOUT 30

    the dbname witout Quotes:

    But isn't the timeout error...

  • RE: Database Mirroring Issue

    Thanks for the links. That first one is interesting. I saw a couple of others saying they were having backup troubles on the principal server with database mirroring...

  • RE: Database Mirroring Issue

    I also just noticed a bunch of these in yesterday's log: Downgraded restore buffers from 4096K to 2048K. (hundreds of them).

    I see another post on this site with that...

  • RE: Replicate from AS400 DB2 to SQL Server 2008

    I did something somewhat similar several years ago. We just set up a linked server in SQL pointing to the AS/400 databases.

    We didn't use SSIS or DTS...

  • RE: CAST

    Interesting, I didn't know that.

    Just for fun I just created a dummy table with a VARCHAR column that I didn't specify the length for, and it made it of length...

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