Forum Replies Created

Viewing 15 posts - 12,421 through 12,435 (of 39,963 total)

  • RE: Nesting of Transaction

    +1 to what Sean said.

    Don't use them, and don't depend on them.

  • RE: New Group Permisssion

    and "it" was?

    (someone else might search this post. Be nice to provide the solution).

  • RE: Back up failed

    It looks like the cleanup task failed, not the backup. Did you check the backup file?

    As mentioned above, you should have a detailed log for the package. Don't use the...

  • RE: Are the posted questions getting worse?

    This week is the first SQL in the City of 2013. Anyone coming?

  • RE: Trust

    Gary Varga (6/17/2013)


    For too long we have rolled out the young/immature industry arguments. We must stop because quite simply: we know better.

    A lot of these industries which have compliance, regulatory...

  • RE: Log File Continues to grow

    How big are your log backups? Check the size for each hour. If they are small, then you have something preventing the truncation of the log, like replication or mirroring...

  • RE: Need a help in backup Encyption Certificate

    At this point I wouldn't drop the master key. That won't help with your encryption status.

    If you cannot drop this (encrypted state = 2) database, or do not have an...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/14/2013)


    ***************************************************

    I am officially going to Afghanistan!

    I leave for IRDO at Camp Atterbury in Indiana on Sunday, June 23rd. All should go well there with me leaving there...

  • RE: Need a help in backup Encyption Certificate

    It should complete by itself. Has the progress changed at all?

    If not, then I think you are in trouble. I'd backup the database, or copy out all data/schema and my...

  • RE: Indexing

    Thanks for the correction, Hugo. Moving too fast today.

    Not sure why you would disable a clustered index then. Perhaps it was included to keep consistent syntax for all indexes? Seems...

  • RE: sql 2000 jobs

    It still isn't quite clear. The exact error and exact steps are needed, but you can debug this yourself as well.

    run a trace on the 2000 server and watch what...

  • RE: Questions on resources and removing instances

    That makes more sense. I'm not familiar with terminal services licensing, but can you have 2 or 3 terminal servers under the same licensing? Is it by CAL or is...

  • RE: Indexing

    Luis Cazares (6/14/2013)


    The question is interesting but I do wonder why would someone would disable a clustered index?

    ETL loads is one reason. It can be faster to load without indexes...

  • RE: sql 2000 jobs

    It's not quite clear what you mean, or what you did for access.

    What did you do to grant access.

    When you say he gets an error, do you mean he...

  • RE: Indexing

    My apologies. I think I cut and pasted the drop in the wrong spot when this was proofed. It definitely ran correctly when it was tested.

    I will award points back...

Viewing 15 posts - 12,421 through 12,435 (of 39,963 total)