Forum Replies Created

Viewing 15 posts - 616 through 630 (of 2,436 total)

  • RE: Performance Concern With Lock Pages in Memory Option

    DBADave, I have used this setting as a default on all of my SQL 2000 servers (at least 200+) for a number of years (when did SQL 2000 come out) now...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Cannot Connect to Server

    First thing you need to do is download the setspn utility (link below):

    http://www.microsoft.com/downloads/details.aspx?familyid=5fd831fd-ab77-46a3-9cfe-ff01d29e5c46&displaylang=en

    Install it on your computer (or server). Next you'll need a Domain Admin account to use (unless...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: How to create a new database from existing database in SQL Server 2005

    You need to execute sp_fix_users_login when moving the database from one server to another:

     

    ---

    --- fix_users_login.sql

    ---

     use master

     go

     set quoted_identifier off

     go

     if exists (select * from dbo.sysobjects where id = object_id('dbo.sp_fix_users_login'))

         begin

      print 'dropping old...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Failed backup job

    Look into the System and Application event logs then the cluster.log file immediately after a failover. The take this information to the sysadmin. If he does nothing then take it...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Sprint''s New Business Model

    Woe be it me to say this bit I think that it may be time for federal reregulation of the telecommunications industry both wired and wireless as it was back...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Getting email messages from SQL

    kai - I just prefer to use the abbreviated form:

        SSDD

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Four instances of SQL Server

    I think that TheSQLGuru was being a bit overly optimistic about the 3-legged dog ... more likely than not the aforementioned dog would have to learn how to walk upright...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: CLR and Performance...

    The programmer might need a different (bigger) hammer however the fault lies in management or to be more specific project management and architects. If the folks running things were on...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: How to Unit Test SQL Changes

    ... ahh yes ... the old 'tune it up with money' trick ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Service Pack

    I cut out the URL and apparently MS has moved the page !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Sql Server Logs (no items) showing in Enterprise Manager

    Could it be a permissions issue ? Are you using the same credentials for EM that you use in QA to run xp_readerrorlog ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: How to Unit Test SQL Changes

    Jeff maybe we should link this question to the certification debate

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: The other side of outsourcing

    Agreed on the outsourcing. It has almost done as much for our collective careers as DBA-less software !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: The other side of outsourcing

    Steve, I was being a bit facetious in the post. I actually am very happy with my present package. As a matter of fact is is 'most excellent' ... it...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Does anyone know anything about the company SetFocus?

    loner please run as fast as possible from this firm. Any firm 'worth their salt' will hire you and train you appropriately. and not have you essentially 'pay them' for...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 15 posts - 616 through 630 (of 2,436 total)