Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by MELc

  1. MELc

    Datasource drop-down is empty when creating new linked server

    I want to create a new linked server in Enterprise Manager but the datasource provider drop-down list is empty. How do I fix the problem or what do I need to install on the SQL server? Your help is much appreciated.
  2. MELc

    Need ideas on SQL failover system

    I would like to gather different options for a failover system to protect against application outage if our SQL Server box fails. SQL Server clustering is one option but I understand it requires SQL Server 2000 Enterprise Edition which costs ten times more than the Standard Edition. Thank you...
  3. MELc

    How can standby server take the identity of production server?

    Thanks for your response. Some of our applications use ODBC and some use OLEDB to connect to our SQL server. We have no web apps. I was looking for a way to make our standby server 'impersonate' our production server (in case our production server goes down) without having to re-point our...
  4. MELc

    How can standby server take the identity of production server?

    After I restore and recover our SQL 2000 standby server, how do I turn it into our production server without having to change the data sources and config files of our applications? Thank you in advance for your help.
  5. MELc

    Opening a Word Document From VB

    How do I open and display a Word document from an external VB6 routine? I appreciate your help.
  6. MELc

    Hyphen in server name causes incorrect syntax error

    The SQL query below fails with incorrect syntax error. Is there a workaround without changing the server name? The server is a linked server. SELECT * FROM server-1.msdb.dbo.backupset Your help is appreciated.
  7. MELc

    How do I store images in SQL table?

    I've added an image column but I don't know how to store an image into the column. Please help.
See more

Part and Inventory Search

Back
Top