Forum Replies Created

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

  • RE: Going to Dev Edition

    It's active active. Does that make a difference in your comments?

  • RE: First Record Set

    Oh that is beautiful! Thanks a million...

  • RE: Trigger spid

    Thx. Hey, I found that you can just use @@spid. Seems to work just fine based on my preliminary testing.

  • RE: Lost Transaction?

    Sorry - push transactional immediate. We have a distributor server.

    Intg article. I actually read something similar yesterday. The only thing is this: the data is not...

  • RE: Virtual SQL Server

    In addition, I think the real underlying questions is whether Microsoft "certifies" certain configurations of VM and/or hardware configurations? In other words, can you make a VM environment that...

  • RE: Virtual SQL Server

    rgtft (7/13/2011)


    At a previous job, we moved a SQL Server from a physical box to a virtual server. I was pleasantly surprised that performance didn't suffer. I had...

  • RE: Identity Issue - Massive Table

    opc.three (6/28/2011)


    Whisper9999 (6/27/2011)


    I've got a large table (70+G) with an identity column. I want to rebuild the table using paritioning but don't want to lose the identity or the...

  • RE: Defrag Script

    Ninja's_RGR'us (5/24/2011)


    Whisper9999 (5/24/2011)


    I'm using a pretty old version. I will try the latest version to see if it runs faster. Plus, now it has an exclusion table. ...

  • RE: Defrag Script

    Okay, I'll try it. I also tried using 'sampled' instead of 'limited' per another suggestion but that hasn't seemed to have helped. And this is where the script...

  • RE: Defrag Script

    I'm using a pretty old version. I will try the latest version to see if it runs faster. Plus, now it has an exclusion table. So maybe...

  • RE: Attach Failure in a Cluster

    Yes. Looks good. It was the file issue above...

  • RE: Attach Failure in a Cluster

    I found the issue. Some of the detached files had weird permissions on them.

    When I gave myself full control over the file, I could do the attach.

  • RE: Database Mail Ip

    Sorry - actually, I don't need the ip necessarily and what I gave our win admins was the dns name.

  • RE: Database Mail Ip

    I'm looking for the SMTP ip or address that it sends the email to.

    I figured one way to do it. I went into the config wizard for the specific...

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