Forum Replies Created

Viewing 15 posts - 1,246 through 1,260 (of 3,366 total)

  • RE: User Permissions to Email Report Subscriptions

    You could try publisher if that is not enough content manager which is very high permission for a user because even developers can use publisher.

    http://msdn.microsoft.com/en-us/library/ms156014(SQL.90).aspx

    Kind regards,
    Gift Peddie

  • RE: SQL Server Express Memory Issues

    You could try caching on the application layer or use regular SQL Server and look into hosting license which I think let you rent the CALs

    Kind regards,
    Gift Peddie

  • RE: Music for DBAs

    I'm particularly fond of cello concertos when I'm trying to concentrate on something...

    I like most concertos I watch most on PBS Great Performances.

    Disaster Recovery:

    Mannin' the Mirror (Michael Jackson, RIP)

    Talking about...

    Kind regards,
    Gift Peddie

  • RE: Release FileStream space

    Something still appears to be wrong. The files are not being removed, despite having run log, differential, and full backups, as well as running checkpoint.

    Has anyone else encountered this? Is...

    Kind regards,
    Gift Peddie

  • RE: ntext datatype issue in ssis

    In SQL Server 2005 why are you using NText instead of Nvarchar(max) which can grow to 2gig? If your database is from 2000 then change your compatibility to 90...

    Kind regards,
    Gift Peddie

  • RE: Release FileStream space

    How would that be possible when the old and new versions are needed within the log backup for standby systems/database recovery?

    One important factor to point out is the buffer size...

    Kind regards,
    Gift Peddie

  • RE: Release FileStream space

    Thanks for all the responses. After a bit more hunting around I found some info about the recovery mode. I had set it to "Full" and didn't realise that this...

    Kind regards,
    Gift Peddie

  • RE: Release FileStream space

    If the garbage collection could clean up a file while it was still necessary then any one of these cases could occur:

    A rollback fails because the old version of the...

    Kind regards,
    Gift Peddie

  • RE: Release FileStream space

    Paul Randal's written a very good whitepaper on filestream. Well worth searching for and reading

    I have seen it did not read I am still saying no garbage collection is...

    Kind regards,
    Gift Peddie

  • RE: Music for DBAs

    Cold Play Viva La vida

    Lil Wayne

    Online by Brad paisley

    Van Morrison Brown eyed girl

    Marvin Gaye What's Going on

    Bob Marley

    The first two are last year grammies. My taste...

    Kind regards,
    Gift Peddie

  • RE: Setup.exe to run UpgradeAdvisor locally

    That may be related to the fact that SSRS is not cluster aware so here is the doc of making changes to SSRS in a cluster.

    http://msdn.microsoft.com/en-us/library/ms191545(SQL.90).aspx

    Kind regards,
    Gift Peddie

  • RE: Release FileStream space

    Eugene (7/3/2009)


    Sorry to press the issue, but what does "under OS control" actually mean? How does the OS know that it is supposed to delete the files, and what service...

    Kind regards,
    Gift Peddie

  • RE: Release FileStream space

    I deleted some filestream rows containing large video files over a week ago on my Vista Ultimate laptop, and have restarted numerous times since, and the files are still there.

    Is...

    Kind regards,
    Gift Peddie

  • RE: How do I setup SQL Server 2008 Express to work with Visual Studio 2008 Pro?

    robblot (7/4/2009)


    Thank you for your quick response.

    I would like to use SQL Server 2008. Can you help me please?

    Check below and download one of the last two and there is...

    Kind regards,
    Gift Peddie

  • RE: How do I setup SQL Server 2008 Express to work with Visual Studio 2008 Pro?

    VS2005/8 will install SQL Server 2005 Express if you did not remove it during your VS2008 install so all you need is install the SQL Server Management Studio Express...

    Kind regards,
    Gift Peddie

Viewing 15 posts - 1,246 through 1,260 (of 3,366 total)