Forum Replies Created

Viewing 15 posts - 1,696 through 1,710 (of 2,436 total)

  • RE: Renaming a Virtual SQL Servername under SQL 2000 - without re-installing?

    We had to reinstall a clustered SQL Server instance due to hardware upgrades and in the process changed the instance name to match with current standards. This left us with...

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

  • RE: Cannot delete backup file; access is denied

    You should also look into anti-virus software. Additionally, if you are using a SAN or NAS, there may be volume replicating servi ces executing. However you can actually delete the...

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

  • RE: SP_HELP DB gives error.. Model and MSDB ''''unknown'''' owner

    To recreate the problem you'll probably have to edit the system tables on another server ... if you can do that, then why not just fix the system tables on...

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

  • RE: Disk Partitioning/Binning

    This is the minimum IP addressess needde for SQL2K, SQL2K5 should be the same since clustering is performed on the OS level. Here are a few links that you need...

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

  • RE: Disk Partitioning/Binning

    Here's what you need

    • physical machine A network card
    • physical machine B network card
    • virtual windows server
    • sql server instance
    • msdtc
    • physical machine A network crossover
    • physical machine B network crossover

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

  • RE: bcp temp table within a SP

    Why even use a 'temp' table when you can bcp out the data directly through a view. This trick should work in your situation.

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

  • RE: Job fails due to an error which is being handled by the script being called

    Unfortunately I do not have a solution. I've always been able to have a script behave in the same way in QA as in a Job/Scheduled task. The only solution...

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

  • RE: Slow SQL Server Connection

    You can check the following for starters:

    System/Application/Security event logs for errors when you register and when you connect

    Workstation:

    NIC card setting - minimum 10 MB/Half Duplex

    Have the network folks check...

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

  • RE: Is there a need for real-time monitoring tools? Budget Time...

    Just what counters, etc in perfmon are you looking to do monitor Dave ?

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

  • RE: Is there a need for real-time monitoring tools? Budget Time...

    How about MOM 2005 - it does SQL Servers very well fir the SQL Management Pack ... an adding selling point is that it can and will monitor all of...

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

  • RE: Detecting SQL Server Installations

    I've had good luck 'free' third party tool like SQL Recon from Special Ops Security. Once you install a tool like this you'll need to speak with your network folks and...

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

  • RE: list of sql server running in my domain

    I've had good luck 'free' third party tool like SQL Recon from Special Ops Security. Once you install a tool like this you'll need to speak with your network folks and...

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

  • RE: Recovery Mode

    Definitely check with the vendor. Even MS (as I found out with MOM 2005) ...

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

  • RE: Job fails due to an error which is being handled by the script being called

    Could you post the error text from the 'trapped' error ?

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

  • RE: Restoration of a deleted Job

    It appears you have found your solution.

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

Viewing 15 posts - 1,696 through 1,710 (of 2,436 total)