Forum Replies Created

Viewing 15 posts - 46 through 60 (of 162 total)

  • RE: Stored Procedure Errors - Read Log via T-SQL?

    If that functionality exists out of the box I'm not familiar with it. I've always logged errors to a table in my catch blocks.

  • RE: XML

    GSquared (6/12/2012)


    Generally, I've been lazy and pulled the raw XML into a staging table with an XML datatype column, then used XQuery to shred the XML into relational format. ...

  • RE: Lock down and never patch sql server

    *Shudders*

    I've had to deal with this before. Every time I wanted to apply a SQL Sever SP or hotfix I had to download it to my machine, get our...

  • RE: Books for Newbies?

    Books are nice but not always necessary, especially for someone new who doesn't know where to begin. There are plenty of tutorials and intros online that are free and...

  • RE: i wrote a split function for insert value in this table plz any one solve my problem

    Sean beat me to it...:-P

    A couple things here. First, there's some formatting issues with the code you posted. If you copy and paste that to a new query...

  • RE: Replication as a partial DRS

    I see now, that database at site 2 is active all the time. Makes sense then. I would think it would work in this instance.

    Just a difference in...

  • RE: Replication as a partial DRS

    I read the first page where you said mirroring isn't an option but I'm still confused as to why? Can you expand on that?

    It sounds like your looking for...

  • RE: Split String

    I will be the third to say go with Jeff's splitter. I created my own splitter function before finding the link posted above and not only was Jeff's waaayyyyy...

  • RE: SQL Server Page Size

    This is a good question. I'm not really sure but I'd be willing to bet the answer lies somewhere within the storage subsystem and not with the way windows...

  • RE: Calculate percentage using sql server

    If you don't want to include unknown amounts in the % you would subtract them from the total and then divide each company's amount by that new total. Right?...

  • RE: Sanity Check - using CASE in WHERE clauses

    Rayven (1/18/2012)


    Brendan: The only thing which makes multiple procedures for parameters a pain is where I have 5 or 6 optional parameters with multiple combinations - it would mean hundreds...

  • RE: Delete Old T-log Backup File

    I would double-check to make sure you configured the maintenance plan to look for the right file location, folder, and you're looking at the right time frame. Did you...

  • RE: New and looking to advance my career

    I will add that it may make sense to skip the developer edition and start with the express version instead. I know the developer edition is cheap and offers...

  • RE: Foreign key on an IDENTITY column

    Nigel may be on to something. If you run those two statements they complete successfully, as long as the order is correct of course. Post the entire script...

  • RE: Delete Old T-log Backup File

    What Robert said is accurate. If you're maintenance plan isn't working it's probably a permissions issue. Double check the account that the SQL Server service is running under....

Viewing 15 posts - 46 through 60 (of 162 total)