Francisco H Tapia
my.lists at verizon.net
Tue Mar 25 17:53:11 CST 2003
Arthur, There is code that you can use by downloading all the source from the following link http://www.asql.biz/DbaMgr.shtm For those workstations w/ MSDE this is an alternative to using EM to manage the database :D there is more SQL-DMO info at http://www.sqldev.net/ http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8804 HTHs -Francisco http://rcm.netfirms.com On Tuesday, March 25, 2003 6:20 AM [GMT-8], Arthur Fuller <artful at rogers.com> wrote: : Lately I have been researching the SQL-DMO library, so that I can : write a tool to backup and restore databases for MSDE installations : where Enterprise Manager is not present. Not one of your MSDN : examples is complete. You can't cut and paste any of them into a : module. They all contain provisos such as : : ' creation of the oSQLServer object is not covered here : oSQLServer.DoSomething : : Which means that you have to go look up the SQLServer object and find : an example of how to create it, then copy and paste that into your : current code. It's not that big a deal: one line to declare it and : another to instantiate it -- but that's precisely the point! Are you : so short of cash and/or time that you can't add a couple of lines to : the examples so they work? And even these examples are not installed, : unless you specifically install them -- which means go find the CD, : navigate to the samples directory and copy the relevant subdirs. : : All is not lost, however. Turns out that google is the best way to : search this stuff. Type a propertyname such as RelocateFiles into : google and you get some meaningful and instructive hits -- unlike the : MSDN docs or the "help" files. : : Your friend, : Arthur : : "If you think education is expensive, try ignorance." : : : -----Original Message----- : From: dba-sqlserver-bounces at databaseadvisors.com : [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of : Billy Pang Sent: March 24, 2003 6:40 PM : To: dba-SQLServer at databaseadvisors.com : Subject: [dba-SQLServer]MSDE - server network library configuration : : : Is it possible to edit the "server network library configuration" : without going to : "Start menu, point to Programs/Microsoft SQL Server, and then click : Server Network Utility"? : : I am trying to change the port number from 1433 to something else. : : Thanks in advance : Billy : : _________________________________________________________________ : Help STOP SPAM with the new MSN 8 and get 2 months FREE* : http://join.msn.com/?page=features/junkmail : : _______________________________________________ : dba-SQLServer mailing list : dba-SQLServer at databaseadvisors.com : http://databaseadvisors.com/mailman/listinfo/dba-sqlserver : http://www.databaseadvisors.com : : _______________________________________________ : dba-SQLServer mailing list : dba-SQLServer at databaseadvisors.com : http://databaseadvisors.com/mailman/listinfo/dba-sqlserver : http://www.databaseadvisors.com