Forum Replies Created

Viewing 15 posts - 1,846 through 1,860 (of 2,436 total)

  • RE: Hardware requirement

    I have not forgotten your request Todd ... been a tad bit busy on this end ...

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

  • RE: Index already exists - EM bug?

    "It would look like this: jsmith.dbo.products and jjohnson.dbo.products"
     
    Based on the standard naming convention database.owner.object I believe it is more like: database.jsmith.products and database.jjohnson.products

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

  • RE: Cannot Delete Job from Target Server

    Is the JOB still executing ? If it is then kill the spid. If it does not 'die' you may have to resort to a /stop/start of SQL Server. If...

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

  • RE: 20 million row partition strategy

    If speed is the highest priority then Raid 5 outperforms Raid 0. You will take an infinitessimal performance hit on writes.

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

  • RE: Syslogins and passwords

    and your question is ???

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

  • RE: OLTP vs. OLAP servers

    I don't have a good suggestion for which server to use. However I think you might want to add 1 additional HBA to each physical server in each cluster. Part...

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

  • RE: SQL Server Error Log Empty

    Are you referring to the 'errorlog' and 'sqlagent.out' files ?

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

  • RE: Moving Registered server from one SQL EM to another EM.

    As I seem to remember this is a 'flaw' in SQL 2000. I have seen a few tools 'written' to perform this task but it only worked for 'simple' registrations....

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

  • RE: SQL 2000 installation

    As far as I know there is no option for this. The system databases both mdf/ldf file (data/transaction) go to the drive/directory specified. There are a few kb articles on...

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

  • RE: Cannot Delete Job from Target Server

    On your MSX server have you tried  'Manage Target Servers' have you tried to 'Post Instructions'  from either tab ? Also, have you tried a stop and restart ot the...

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

  • RE: Active/Passive cluster

    You'll need a number of IP addresses:

    • Physical node A IP
    • Physical node B IP
    • Virtual Windows IP
    • MSDTC IP ?
    • Virtual SQL Server Instance IP
    • Physical node A crossover IP
    • Physical node B crosover IP

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

  • RE: SQL Server 2000 Stopping Unexpectedly

    ... ahhh ... another 'team' player ...

     

     ... over here ther's a 3 person team - Me, Myself and I !

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

  • RE: Service Pack

    Search for: cdoSMTPServerName

    Change it to 'your.fully.qualified.dnsname' or 'your.ip.add.ress'

     

    ... and Yes, the server name or IP address need to be supplied by your network or email admins.

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

  • RE: SQL Server 2000 Stopping Unexpectedly

    I checked my local management server security log and found the 540-538-576 style messages, in spurts, but not continuously . These messages seem normal. As for 'staying on the wire'...

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

  • RE: Service Pack

    Have you entered your organizations SMTP server information ? Is your SMTP server set up to 'relay' messages ? Could you post your proc code just so we can make...

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

Viewing 15 posts - 1,846 through 1,860 (of 2,436 total)