Problem: previously i was using sql server 2000 (windows 2000 server sp4), from previous one week i could not connect to my web server using sql server 2000 enterprise manager. it is poping up an error that : to connect this server you must use sql server management studio or sql server management object(SMO)...
so finding out solutions, i downloaded and install Microsoft SQL Server Management Express.
but like in sql server 2000 enterprise manager, i could not found any method to direct import or export tables directly from my local server to web server. this software is only giving me snapshot of my current db.
can any one please tell me how to import tables and other objects into web server (suppose 18.104.22.168) from my local sql server 2000.
thanks & regards