Forum Replies Created

Viewing 15 posts - 16 through 30 (of 60 total)

  • RE: Seeking Guidance on RFID input to 08R2 Express

    SQL Express is feature-lite, so I would hazard a guess that you couldn't do it directly.

    I was mooching about over some StreamInsight stuff the other day. Have you had a...

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

  • RE: Policy Based Management

    I really like PBM, but....

    I would suggest that the reason there isn't already a user-group / forum / topic /whatever for it is that it's not used widely enough in...

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

  • RE: Policy Based Management

    Personally, I'm not sure that one is required. PBM should really be called 'Policy Exception Reporting and Alerting'.

    That said, it would be a great tool if it only worked...

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

  • RE: checking database permissions from master

    I've come across this a few times and it's usually down to the authentication process.

    Can you ask them to run the following code themselves (assuming they have access via SSMS)...

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

  • RE: Does LiteSpeed works good for SQL 2012

    That must be why Dell (who acquired Quest a while back) have added it to their latest LiteSpeed offering, NetVault LiteSpeed for SQL Server. 🙂 Not sure if it's enough...

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

  • RE: Does LiteSpeed works good for SQL 2012

    I've used LiteSpeed for several years now, but since SQL2008, I've always favoured native compression over 3rd Party tools. In some environments, LiteSpeed will slow to a crawl if there...

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

  • RE: I am unable to connect the SQL instances without giving port number.

    If you're connecting to SQL 2005, sometimes you get this when you're network admin has blocked UDP 1434 as protection against the SQLSlammer worm.

    ..and that would happen even if the...

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

  • RE: job is failing

    Have you restarted either the instance or SQL Agent ? And confirmed that the proxy account still hase the requisite OS and SQL permissions ?

    Maybe SQLAgent is running on cached...

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

  • RE: Setting up snapshot replication on vendor database

    Given that your subscriber only needs refreshing twice a day, are you sure that replication is the right option, since it's giving you so much trouble ? 🙂

    Have you considered...

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

  • RE: Setting up snapshot replication on vendor database

    Looks like this is way way down in the undocumented hidden stored procs that do replication.

    [font="Courier New"]sp_articlecolumn[/font] adds the column to the article for publication / subscription.

    This calls [font="Courier New"]sys.sp_MSrepl_articlecolumn[/font]...

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

  • RE: Setting up snapshot replication on vendor database

    Could you post a relevant section of the error message ? The only thing I can think is that your source database has a user-defined datatype called DATE (but to...

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

  • RE: Simple databases / warm failover

    What's the purpose of the warm standby ? Clustering may be your best bet if it's to protect against hardware failure, but I can't see how you could protect against...

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

  • RE: SUBSTRING and CAST Help Required

    Agreed - It looks like your logic gets you something which isn't possible. Hence the error 🙂

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

  • RE: Migration: detach & copy vrs backup & restore

    If you have backup compression as an option, that may prove quicker to move to the new server and restore than copying the data files. Either way, backup / restore...

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

  • RE: Regarding adding another data file on PRIMARY

    One approach would be to create an new FILEGROUP on the spare disk, add the .ndf to that, and move over some of your tables to the new filegroup.

    I'm not...

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

Viewing 15 posts - 16 through 30 (of 60 total)