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 ...

  • 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
  • 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...

  • 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.

  • RE: Syslogins and passwords

    and your question is ???

  • 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...

  • RE: SQL Server Error Log Empty

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

  • 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....

  • 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...

  • 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...

  • 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
  • RE: SQL Server 2000 Stopping Unexpectedly

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

     

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

  • 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.

  • 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'...

  • 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...

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