Forum Replies Created

Viewing 15 posts - 136 through 150 (of 189 total)

  • RE: how todeny drop permission to user on table , view and store procedure

    hello there,

    i am not 100% sure in my answer so if its incorrect my apologies BUT i do believe if you are the owner of an object(meaning able to create...

  • RE: SQL server configuration - Hardware recommendation

    Not exactly sure what you are wanting to achieve but first off... Make sure you are running Enterprise Edition of your OS and SQL otherwise you are going to find...

  • RE: How many databases in one server

    WOW!!!! What a loaded question. 🙂 There are tons of variables that always play a role in this decision so its truly difficult to put a number on how...

  • RE: Clusters Opinion

    Thanks to all for the time in your comments and suggestions. JBaxter your insight is much appreciated. Mark your ideas are right along the lines i was thinking previous...

  • RE: database connectivity problem

    Hello,

    Not sure how your app connects to the database but a lot of mine use an ODBC connection. Is that configured properly if its used.

    -D-

  • RE: Clusters Opinion

    Thanks for the looks... 🙂 How are we achieving the availability now. Well needless to say... we just hope the servers stay up and not have any...

  • RE: Sql Server 2005

    Do you have any recent system backups... Is it possible to restore your system databases? I am thinking if you restore your sytems database to the one previous to...

  • RE: Be a good Database Administrator?

    Brian has said it all...very well put :). Of course i will add my .02 from my experience. Make sure you have some broad shoulders and a good...

  • RE: SERVER config

    William,

    Log shipping vs clustering LOL you sure can pick some topics... both have setback and both have positives. I think its gonna be in YOUR best interest...

  • RE: SERVER config

    Wow you have a lot to discuss here.. 🙂 First (this is all just my crooked opinion hehehe) make sure IF you are getting a new server this...

  • RE: Server Stress Testing

    Hey MVJ,

    Not sure if this is asking too much but are those scripts something you have available and willing to share or are they something that i would need to...

  • RE: Server Stress Testing

    So i take it the "suite of scripts" are already prewritten specific to the server. I used SQLIO but didnt have anything to increase the stress as it sounds...

  • RE: Warning: "xxx\instancexxx\databasename" is a corrupt file. This file cannot verify.

    This is tell you that your file is not verified when the veritas system does the system check. I use veritas as well and sometimes it gets very picky....

  • RE: Dropping and Adding a server woooo's (EMERGENCY)

    Thanks for the help..got the server to work thru the use of the ip address.... the name is still showing null when i use @@servername ... 🙁 but...

  • RE: xp_sendmail

    Depending on how your system is setup there are many varibles but you may want to try to run:

    use Master

    exec xp_startmail

    go

    this should return that your mail client has started...

Viewing 15 posts - 136 through 150 (of 189 total)